Managing Data Source Connections
FAQs with managing data source connections
Coefficient requires that you connect to a data source (ie: Salesforce, MySQL, Jira, etc.) in order to pull data into Google Sheets. Maintaining/managing these data connections are very important and can affect your imports - especially dashboards built on imports using Coefficient.
There are 3 actions you can take once connected to a Data Source in Coefficient, “Rename”, “Reauthorize” and “Delete”.
(Data Source Example: Salesforce)
Click the Menu (hamburger icon) from the sidebar.
Select “Connected Sources”.
Look for the connection you want to rename. Click the 3-vertical dots icon and select “Rename Connection”.
Enter a new (unique) name for your data connection.(press Enter to save)
Moving forward, you will now see that name in the list of data source connections.
You may be wondering why you will need to “Reauthorize” your data connection in Coefficient after you have successfully connected to this source. Sometimes the connection with the data source is broken/disconnected for one reason or another. “Reauthorizing” your data connection will resolve this disruption and get your imports refreshing again.
Click the Menu (hamburger icon) from the sidebar.
Click “Connected Sources”.
Look for the connection you want to Reauthorize. Click the 3-vertical dots icon and select “Reauthorize” from the options.
Click “Authorize”.
You are redirected to the Salesforce login page. Enter your credentials and “Log In”.
Select “Allow” to continue. If successful, you will be taken back to Google Sheets.
Click the Menu (hamburger icon) from the sidebar.
Click “Connected Sources”.
Look for the connection you want to Delete. Click the 3-vertical dots icon and select “Delete Connection” from the options.