CONFIGURING DB CONNECTIONS
Overview
For your data to appear in a report you must set up a DB Connection pointing to your dataset(s).
Once a database connection is created in RockDaisy it is automatically available throughout the application and usable by multiple reports and datasets.
From the setup portal choose Add [DATASETS] -> [DB Connection] and enter the connection information.
Supported data source types include:
- MS SQL SERVER
- MYSQL
- ORACLE
- POSTGRES
- AMAZON REDSHIFT
- GOOGLE BIG QUERY
- EXCEL / CSV (via RockDaisy import wizard connecting to MS Excel data).