Connect
Creating, modifying, and managing connections.
What is a Connection?
Connections define the external locations where data will be ingested from and into your lakehouse as well as where your data can be published to. You can create Connections within Empower to contain the credentials and settings to sync data back to your Lakehouse.
For a full list of our available connections, please see the supported connectors section.
To see information about our Fivetran partnership and Fivetran Connectors, please see the Fivetran Connectors page!
Creating New Connections
Select a Connector Type
Need Help Connecting?If you need assistance while setting up a connector from the Empower UI, you can click on the Quick Help button in the upper right hand corner of your screen to open a side panel of that connector's documentation page.
Navigate to the connections tab on the left side of the screen. Click "+" to bring up the New Connection configuration screen.
Select the desired connection type from the list. Use the search bar at the top of the configuration screen to quickly find any supported connection.
Selecting a new connector type
ℹ️ Request a Connection
Some Connectors are only available by request. These can be identified by the bubble in the upper left hand corner. To request the Connector, simply select the option you want then click on the "Request" button atthe top of the page. This will send our Empower product team an email of your request and we will get back to you shortly with next steps.
Authenticate Your Connection
Connection Providers
Note that some Connections may have the option to choose a Connection Provider, as shown below.
After selecting the connection type, fill out the fields required for this connection. Each connection type has its own required configuration, so be sure to double check the fields for accuracy.
Defining Custom Bronze and Silver Schemas
Bronze and Silver schemas define the raw and current locations of this connection connection's objects and fields. Bronze and Silver schemas are defined by the following rules:
- Bronze: The value of the Bronze Schema field, if present. Defaults to "(Display Name)".
- Silver: The value of the Silver Schema field, if present. Defaults to "(Display Name)_silver".
⚠️ Define these fields before running an associated Acquire Task for the first time to ensure data is ingested using your defined schemas. Any changes made to schemas after the first run are ignored.
When all fields have been filled, click "Save and Test" to advance.
Define How Data is Brought In
After you have successfully authenticated your connection, you can click on View Metadata Catalog to view all of the objects and fields within the connection as well as configure how your data is brought in.
Managing & Modifying Existing Connections
From the Connect page, you can select the connection you want to modify from the connection list. You will then see that connection's field details displayed to the right side of it.
Feel free to modify any of these values as you wish (or leave as is if you only want to view them). Make sure to press "Save and Test" to save any changes!
What happens under the hood?
- Your connection details will be saved for this source
- Empower will automatically test your connection for this connection if applicable.
- If applicable, you may receive a testing status message on the page in a few moments. If this connection test fails, be sure to double check your connection details for accuracy.
- Your connection details will be saved and you may attempt to extract metadata from this connection.
Archiving a Connection
How it Works
You may elect to archive a connection that you no longer wish to use. Archiving a connection will automatically archive any associated Tasks. This means that these flows will not run as scheduled. You may not restore any archived Tasks when their connection is still archived. In order to modify, trigger, or schedule an Acquire Task with an archived connection, you must restore the connection first.
How to Archive
In the upper right corner of any selected connection, you can click on "..." to bring up a list of options.
Options menu on a selected connection
Upon a successful connection archiving, you will see the an alert similar to the following on your screen:
Restoring an Archived Connection
You may wish to restore an archived connection conection. This is easily done by navigating to the desired connection and clicking "Restore" in the upper right hand corner.
"Restore" is only available on archived connections
Upon a successful connection restoration, an alert will appear on your screen.
Deleting a Connection
Deleting a connection will automatically permanently archive all associated Tasks! This action will be irreversible!
Please consider archiving a connection instead if you anticipate wanting to restore any associated Task.
Similar to archiving, navigate to the desired connection and click "..." to bring up a list of options.
Click on "Delete" to initiate the deletion action for this connection.
If you wish to proceed with deletion, confirm by clicking "Delete".