Data Sources

Overview

Overview

Data connectors are used by Connetra to connect to your database/warehouse in order to make metadata searchable and to allow for alert creation.

There are two ways to add data connectors. If you are initializing a new workspace then in step 3 of the set-up you can add new data connectors. If the workspace already exists, you can add data connectors by going to ‘Settings’ -> ‘Data Connectors’ & click on the ‘Add Data Connector’ button.

Note that the roles that can create a new data connection are ‘Workspace Owner’ and ‘Admin’ so ‘User’ does not have the required permissions to create a data connection.

Best practice would be to create a Connetra user on the specific data connector you plan on using, and use this in the connection parameters for user/password.

The following data sources are available:

  • MySQL
  • MSSQL
  • PostgreSQL
  • Amazon Redshift
  • Google BigQuery
  • MariaDB
  • Oracle