What is Changing Connections?

How do you Change Connections?

FAQs for Changing Connections

What is Changing Connections?

Coefficient allows you to swap out one connection to a data source to another connection with that same data source. For example, if I am using a shared connection to MySQL that a colleague created and I would rather use my own connection instead, I can create a connection with MySQL using my credentials and point my import(s) to my connection instead of the shared one.

Note: This feature is only supported with our SQL Connectors. Users can change connections within the same data source so MySQL → MySQL. Changing from MySQL → PostgreSQL is not supported.

How do you Change Connections?

(This example will be using MS SQL)

1. From your Imports list, click the 3-vertical dots next to your import’s name and select “Edit” from the options.

1. The details of your import will appear. Click the 3-vertical dots (again) next to your import’s name and select “Change Source” from the options.

1. Select an existing shared connection (top) or click “Add Connection” (bottom) to create a new connection.

1. If you selected “Add Connection” you will be prompted to enter your credentials to create this new data connection.

1. Once a new connection is selected, you will be prompted to confirm the changes by clicking “Change Source”.

   

2. Coefficient will confirm the update in the sidebar. 😎 You may need to refresh your import to pull in the latest data.

Note: Make sure that the new connection is linked to a database server that has the same tables, fields, columns, etc. needed for your import to work. If not, your import will break.

FAQs for Changing Connections

What should I consider before using this feature?

• Changing connections is only supported for the same source changes. Examples: MySQL→ MySQL or PostgreSQL→PostgreSQL. Cross-source changes are not supported. Example: MySQL→PostgreSQL.
• Confirm prior to Changing Connections that the new connection has the same tables, columns, and fields that exist in your current connection. If they do not your import will break.