Using Custom SQL to Import Data
Sisense allows you to import data from a variety of data sources. For users that want additional control over the data that is imported, you can define custom queries that run custom SQL against the source database. For example:
- Write SQL to import only selected table columns when you do not require all the data.
- Perform various procedures in the database such as table joins and import only the result set.
After writing your custom query, you can preview the new table before importing the data into the ElastiCube.
- This feature is available for the following relational databases: Microsoft SQL Server and MySQL.
- This feature runs a query in the source database. The performance will depend on processing power from your database, especially for complex queries.
To add tables with custom queries:
- After selecting your database, click + at the bottom the list of tables and views in the database.
An empty custom table is added and the Settings area is displayed.
- Click + to add additional custom tables.
- In the Settings area, enter your custom SQL query.
- Click Preview Table to preview the results of your custom query.
Select the table from the Table list and click Done to import your custom data into Sisense.