Skip to main content

User Guide

Create a Connection to the Data Source

MDP_Connections_Create1.png

As a data owner, you can create a connection to a data source.

  1. Click Connections in the left navigation.

  2. Click Create Connection.

    The Connections Details page appears.

  3. Title—Enter a name for the connection.

  4. Description—Explain the connection's purpose.

  5. Source Location—Select the physical location of the data or file storage system.

    For example, if the data is stored on a database that resides in your organization's office in London, select "United Kingdom." If the data is stored in an Amazon S3 bucket that resides in the region us-east-1, select "United States of America."

  6. Data Agent—Select which data agents can use this connection.

    Note

    The selected data agents must be able to connect to the infrastructure that you define in the following steps.

  7. Connection Status—Select Enabled when you are ready to use this connection. Select Disabled if the connection is not yet ready for use.

  8. Click Next.

    The Connection Parameters page appears.

  9. Click Select a Connection Type.

  10. Connection Type—Select the type of connection.

  11. JDBC Connection String—Enter the JDBC connection string required to connect to your database.

    Important

    The string must have a specific format depending on the database type. For details about the connection string to use with specific drivers, see your database vendor's documentation.

  12. Username—Enter the username of the system user needed to authenticate the connection.

    Note

    We suggest that you use a shared username and password rather than your own username and password because this username and password will be shared by all users using this connection.

  13. Password—Enter the password needed to authenticate the connection.

  14. Extra Parameters—If your connection requires parameters not specified in the JDBC connection string, click Add Parameters to add them here. Check your database vendor's documentation to learn more.

  15. Click Test to test the connection from each of the data agents that you selected.

  16. Review the results of the tests.

  17. When you are ready to save the connection details, click Next.

    The Review and Confirm page appears.

  18. Review the connection details.

  19. Click Save.

    A confirmation message appears.

MDP_Connections_Create2.png
In this section:

The data agent provides access to the data plane whenever required by the control plane, for example to retrieve the schema for a data asset. It makes a long-lived connection to the data bridge on startup.