Create connection in Data Enrichment

In this article, you will learn how to create a connection in Data Enrichment. The Edit Connections window is accessible from the connection dropdown that is located in multiple places where you need to connect to an external datasource. For example, when importing into a table from a database or creating a publish data action.

Create a connection

1. Open a table in Data Enrichment and click Import Data
2. Select Database as the Data source.
3. Click Edit connections...

   

4. Click Add to create a new connection.
5. Write a name for your connection.
6. Select the connection type (SqlServer or ODBC) from the dropdown
7. Fill in the Connection Information and Authentication.
   Authentication can be either; Windows Authentication which uses the credential of the user running Data Enrichment, or Username and Password which uses SQL Login as authentication.
8. Click Generate Connection String.
9. Then, click Test Connection to confirm that the connection works.
10. After configuring the connection, click Save Connection