Embedded Business Intelligence Software Resources

One possible way to solve this would be to create Datasets with SQL - you can merely copy the SQL to form the new dataset. Once you have created the dataset, you can make a workbook from it and allow the business users the ability to manipulate in the "spreadsheet" format.

Hi George! Thanks for your question! Toucan has hundreds of connectors that bring in data from any type of data source. Our clients can also create their own connector if there's a need to adapt! Toucan also works with both real-time and loaded data as per our client's need. This decision often depends on the speed of processing. As a rule of thumb there should never be more than 2 seconds of waiting time for a screen to load, otherwise our analytics show that this affects adoption.