Forum Discussion

reema's avatar
reema
Data Storage
05-19-2022

Drill down from one dataset(sql table 1) to another(sql table 2).

I am fairly new to sisense.  I have this situation as below:   I have connected sisense to a "Sample Sales" SQL Server Database with 2 Tables: Database : Sales_db Tables : tb_sales_summar...
dashboards & reporting
reema's avatar
reema
Data Storage
05-23-2022

Thanks again for the different insights! 

Can I know what type of datasource you connected to in Sisense?

As the loading speeds vary right with different types of Datasources. Just curious as Our's would be more than 100's of million's of records that too using Traditional SQL Server and not cloud based.

HamzaJ's avatar
HamzaJ
Data Integration
05-23-2022

reema 

For our tables that are this big, we do not use live-query as that would put a big strain on our DB-server. We import the records into the elasticube (datasource is MySQL) and build/query it from there without any issues. In our case importing we can do via accumulative builds. Speeds things up