Feature – After Query Scripting

If it involves Data - we can help you

Scripting in InSights Into Data

It is one thing to import data into a program and use it as is. InSights Into Data takes it one step further by providing the ability to run Scripts that allow you to customize your data and do new things with it.

InSights uses a real programming language (C# – the most popular .Net programming language) as its scripting language. This provides maximum flexibility and power while allowing the user to do just about anything with their data in their scripts. You can write a script that adds a new column and populates it, update one in-memory table from the values in another. You could even write a script that would export the data out to a custom format, or encrypt it and upload it to some cloud site. The possibilities are endless!!

Example Script

The above screen capture shows a sample script that adds a new Integer (number) column and then populates it with a value of 1. The actual script code that the user needs to write – it just between the two lines of “//—————————-“. All the rest is just a framework of code that has to be there.

InSights ships with a few example scripts that you can load and modify to do whatever you want with your data.

InSights allows you to utilize scripts both in an AdHoc manner (run whenever you want) – and set them up to automatically run immediately after a SQL statement or a File Import is run. Scripting allows you to extend the abilities of InSights in an almost unlimited number of ways!