The following are just some of the features of InSights Into Data. You can click on the Title or Image to see more information on each – including more detailed screen shots.
To see InSights Into Data in Action – you can view our Video Overviews.
InSights Into Data allows you to access your data by either connecting to number of different databases or importing files such as CSV, Excel, etc. The database connectivity uses native drivers where ever possible but is capable of using ODBC drivers to access many other data sources. We are more than willing to talk with you if you need to connect to your particular data source!
Modifying SQL can be a pain. Even for professionals! InSights introduces the concept of reusable queries that allow the user to enter data, at run time, each time you run a query. This means that by using our custom tag language (simple wizards make this really easy to do) you can reuse and change what records are selected each time you run that query – without ever having to edit the SQL!!
InSights Into Data is all about your data, and what you can do with it! What would that mean without the ability to export that data to a multitude of formats. The program provides a Wizard that will take you through exporting your data to the following formats: MS Access, Excel, CSV, XML, RTF, PDF, DIF, Text (Columns) HTML, DBF, SYLK, and as SQL Insert statements.
As well as acquiring data via SQL queries, you can bring data into the program via File Imports. InSights has a Wizard to help you import the data – and can even store the import settings as a script that can be run automatically any time in the future.
Currently we import Excel and CSV files, but will be adding Text files (Column delimited) and possibly others like XML and JASON files.
InSights has the ability to not only save (backup) your queries, which includes all the notes, dashboard and report definitions, but to share them with other users as well.
You can share them either by using the same configuration database, or by saving them to file – and emailing that file to another InSights user – who can then import them into their own program.
While importing files and using SQL to get data from a database work well, there are times you may want to do more with that data! Something that is not built into the program?
InSights has the ability to run a Script after the Query or Import is run. These scripts are written in C# (.Net). This means the ability to do things via Scripting is pretty much unlimited.
We provide sample scripts for common tasks such as adding columns, modifying column data, etc.
As part of the program, InSights Into Data has a built in Spreadsheet that is 100% Excel compatible. This means that you can export data from the Grids & Pivot Grids to this spreadsheet, keeping all formatting and formulas – and then save it to an Excel Spreadsheet. All – without having Excel on your machine!