Sometimes the source database isn’t appropriate for live queries from a reporting tool.
If that is the case, you can use an ETL tool to convert the data in the live database to a SQLite reporting database and upload it to Rational BI through our REST API.
This approach limits the total size of the database to what is appropriate to to transfer over the network in compressed form and load into the web browser.
For best performance, reporting databases < 100 MB are ideal. This means that data should be somewhat pre-aggregated into data cubes that can drive reports and provide filtering/drill-downs as needed.