Cloud Portal ONE Desktop ONE DQ&C ONE MDM ONE RDM ONE Runtime Server
User Community Service Desk Downloads

Other Relational Databases

Follow this guide if you want to connect to Amazon Aurora MySQL, Amazon Aurora PostgreSQL, Amazon Redshift, MariaDB, Sybase, SAP HANA, Teradata, Oracle, PostgreSQL, or MySQL.

Create a source

To connect to a relational database:

  1. Navigate to Catalog > Sources.

  2. Select Create.

  3. Provide the following:

    • Name: The source name.

    • Description: A description of the source.

    • Deployment (Optional): Choose the deployment type.

      You can add new values if needed.

    • Stewardship: The source owner and roles. For more information, see Stewardship.

You do not always need to create a new data source. You can also add connections to existing sources.

Add a connection

  1. Select Add Connection.

  2. In Select connection type, choose Relational Database > [your database type].

  3. Provide the following:

    • Name: A meaningful name for your connection. This is used to indicate the location of catalog items.

    • Description (Optional): A short description of the connection.

    • JDBC: A JDBC connection string pointing to the IP address or the URL where the data source can be reached.

      When setting up your connection, use one of these JDBC URL formats based on your database type. Make sure to:

      • Replace hostname with your server address.

      • Adjust port numbers if your database uses non-standard ports.

      • Specify the specific database or schema you want to connect to in database_name.

      Some connections may require additional parameters depending on your environment.

      JDBC connection string examples

      When setting up your connection, use one of these JDBC URL formats based on your database type:

      MySQL/MariaDB/Amazon Aurora MySQL

      jdbc:mysql://hostname:3306/database_name

      PostgreSQL/Amazon Aurora PostgreSQL

      jdbc:postgresql://hostname:5432/database_name

      Oracle

      jdbc:oracle:thin:@hostname:1521:service_name

      Amazon Redshift

      jdbc:redshift://hostname:5439/database_name

      SAP HANA

      jdbc:sap://hostname:30015

      Teradata

      jdbc:teradata://hostname/database=database_name

      Sybase

      jdbc:sybase:Tds:hostname:5000/database_name

  4. In Additional settings:

    • Select Enable analytical queries if you want to create data visualizations in ONE Reports based on catalog items from this connection.

      This feature is available only for Snowflake, PostgreSQL, and Amazon Aurora PostgreSQL sources.

  5. Proceed to Add credentials.

Add credentials

Only username and password authentication is supported.

  1. Provide the following:

    • Name (Optional): A name for this set of credentials.

    • Description (Optional): A description for this set of credentials.

    • Username: The database user account name or login ID used to authenticate with the database server.

    • Password: The password associated with the database user account.

  2. If you want to use this set of credentials by default when connecting to the data source, select Set as default.

    One set of credentials must be set as default for each connection. Otherwise, DQ evaluation fails and previewing data in the catalog is not possible.

  3. Proceed with Test the connection.

Add write credentials

Write credentials are required if you want to export data to this source.

To configure these, in Write credentials, select Add Credentials and follow the corresponding step depending on the chosen authentication method (see Add credentials).

Make sure to set one set of write credentials as default. Otherwise, this connection isn’t shown when configuring data export.

Test the connection

To test and verify whether the data source connection has been correctly configured, select Test Connection.

If the connection is successful, continue with the following step. Otherwise, verify that your configuration is correct and that the data source is running.

Save and publish

Once you have configured your connection, save and publish your changes. If you provided all the required information, the connection is now available for other users in the application.

In case your configuration is missing required fields, you can view a list of detected errors instead. Review your configuration and resolve the issues before continuing.

Next steps

You can now browse and profile assets from your connection.

In Catalog > Sources, find and open the source you just configured. Switch to the Connections tab and select Import or run Term detection. Or, to import or profile only some assets, select Browse on the Connections tab. Choose the assets you want to analyze and then the appropriate profiling option.

Was this page useful?