DB CONNECTION & DATASETS

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).