Changing Connectivity Settings for Data Sources

This topic describes how to change the connectivity settings for an existing data source.

After you have modeled your data in the ElastiCube, a data source may have changed location or you may want to change a table without importing a new table into your schema from scratch.

If this happens, you can update your connection settings to the data source.

When changing connectivity settings, you can choose one of the following:

If a table has changed, but the source and its settings are the same, for example a new column was added, and you want to update your schema without importing the data into the schema all over again, click Refresh in the table’s menu.

Note: The data source name, columns, and column types must remain the same for existing widgets in the dashboard to be able to reference the data correctly.

The table below describes which sources support changing connectivity settings in the web-based ElastiCube Manager:

Data Source Connection Settings Change Database Table Settings Sync Columns

Excel

N/A

N/A

Yes

Yes

CSV

N/A

N/A

Yes

Yes

Google Sheets

Yes

Yes

Yes

Yes

MySQL

Yes

Yes

Yes

Yes

SQL Server

Yes

Yes

Yes

Yes

PostgreSQL

Yes

Yes

Yes

Yes

Oracle

Yes

Yes

Yes

Yes

Redshift

Yes

Yes

Yes

Yes

To change connectivity settings:

  1. In your schema, select the Data Source view in the Navigation Pane.
  2. For the relevant data source, select > Connection Settings and one of the following options:
    c
    Change Provider: Selecting this option opens the first step of the Connection Wizard where you select the data source. In the Connection Wizard, click to select a data source connection type, for example, change MySQL to an Oracle database. When done, enter the connection credentials and select the relevant tables.
    Change Connection: Selecting this option opens the second step of the Connection Wizard where you define the connection settings of the data source. In the Connection Wizard, click to edit the login details to the data source. When done, select the relevant tables.
    Change Table: Selecting this option opens the third step of the Connection Wizard where you select the relevant database from a list of databases in your data source. In the Connection Wizard, select the relevant database.
  3. After you have selected the relevant database in the Connection Wizard, click Done. The connection settings are updated.