Can I use InSights with our Company Data?

If your data is held in one of the supported databases to the right – then the simple answer is Yes.  If it is not in the list above – contact us let us know what database technology you are using.  This will help us prioritize which database technology gets added in what order.

What database can I use InSights Into Data with?

InSights Into Data in Version 2.x supports:

  • Microsoft SQL Server
  • MySQL & MariaDB
  • Oracle
  • Postgres
  • Firebird
  • SQLite
  • CSV Files

In version 3.x we will be adding support for other databases, such as DB2, MS Access, Sybase, and OLE/ODBC connections.  If your database technology is not on the list – let us know and we can look at adding it!!  

What do I need to use it with our Data?

Well – first of all you would need to download our trial 🙂.  After that you will need to do a few things:

  • work with your IT department to get access to your data. You will need the IP address of the database server, the name of the database and a user id and password to access the database server.
  • When you first start the program you will be asked to configure the connection. After that, the program will automatically create the few tables that it needs to run inside the database itself.  We recommend you watch the Database Connection Configuration video here before you do this.  
  • After this point – you are able to start using InSights!

NOTE: You should work with your IT support to setup and configure InSights. We will be happy to supply any information to them so that they are comfortable with what the program does and how it works.

Re-Usable Queries - what are they?

In the past you might have queries that needed data from the user when they ran the query. It had to be manually entered into the SQL – which introduced the possibility of errors. Take a simple query like – find me all the Male patients in a table. You would have to have a WHERE clause like “Sex = ‘M'”. Now what happens if you want Female patients? Or Transgender? You have to change the SQL! Now for this simple example it is not that hard. But what if you needed a list of the all the patients on a particular drug, between certain dates and that have not had a particular lab test. Now you are introducing a level of complexity to the next level and huge possibilities of misspelling things like drug names. And what date format do you use? So – you get the idea that these sorts of SQL statements are not truly reusable.

InSights gets around this issue by introducing SQL extensions that allow the program to prompt the user at run time to choose (or enter) a value that will be substituted into the SQL when it is run. So – in the above example we would have a LUSTRING extension that would prompt the user to enter the Sex of the patient they are looking for. InSights has extensions for Strings, Numbers, Dates and Table Lookups. The benefits to this approach are huge in terms of query reuse and error reduction! And it works fully with our Visual Query Builder.

What SQL Syntax do you use?

We actually use the native SQL syntax for each database.  Our system senses which database is currently being used and does syntax checking based on that. This is true of the Visual Query Builder as well. The only time we vary from this is when we use our SQL extensions to create truly reusable queries!

What if I accidentally Change the data??

The simple response here is that you cannot!  InSights is designed to be Read-Only!!  It does not allow the user to run anything but Select SQL statements, so that you cannot run Insert/Update/Delete statements and therefore change the data.

What are the different License Types?

The system is sold as three different license types:

Designer:  This license is for the folks who will be the ‘power’ users.  They will be the ones creating the Queries, designing reports, dashboards, exports, etc.  

Discoverer:  This license type is for users who will be running (but not creating or editing) queries.  They are also not able to design reports or dashboards.  However, they are able to run the queries and explore the latest data results using the standard grids, pivot grids, charts, dashboards (already designed), etc.  

Viewer:  This license type is aimed at management level users, who just want to consume the results of queries by viewing the data in dashboards, pivot grids, etc.  

What do you mean by a 'Shareable' Query?

A ‘Query’ in InSights Into Data is not just the SQL.  It includes any designed reports, dashboards, grid layouts, export configurations, etc.  This can be saved to an external file (no data – just the query definition) – and then sent to another user of InSights (say in another company or a branch office, etc.) – where they can import the query and use it.  This is a great way to share work load and ideas with your peers!! 

Do you offer Education Classes on how to use the product?

Yes – we do offer personalized education at a chargeable fee.  We provide a variety of demonstration videos and some help files to get you started.  To talk with someone about our training offerings – please use our contact page to reach out to us! 

What version should I get?

This is a good question.  You will need at least one license of a Designer for each organization that will be using InSights.  This version will allow you to create new queries.  Without the Queries – the other versions are not able to function.   The Discoverer are for users who will be running the queries created by the Designers – and want to fully explore their data.  The Viewer users are consuming extracted data and visualizations created by Designers and Discoverers.  If you have any questions about which license type (or mix) is right for you and your organization – don’t hesitate to contact our sales team!  We are here to help you.