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

Other Relational Databases

This article describes how to connect to:

  • Amazon Aurora MySQL

  • Amazon Aurora PostgreSQL

  • Amazon Redshift

  • MariaDB

  • MySQL

  • Oracle

  • PostgreSQL

  • SAP HANA

  • Sybase

  • Teradata

Availability

Data processing & catalog Edge processing Lineage Exceptions

✔

✗

✗

Edge processing: Supported for PostgreSQL and Amazon Aurora PostgreSQL.

Oracle: Lineage supported. See Oracle Lineage Scanner.

Teradata: Doesn’t support:

  • Data preview

  • Anomaly detection

  • Data transformation plans (read or write)

Prerequisites

Add a connection

  1. Go to [your source] > Connections and select Add Connection.

  2. In Connection type, select your database type (for example, PostgreSQL, MySQL, or Oracle).

  3. Fill in the following:

    • Name: A meaningful name for your connection. 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 your data source can be reached. See JDBC connection string format.

  4. Optionally, select Enable analytical queries if you want to create data visualizations in ONE Reports based on catalog items from this connection.

    Available only for PostgreSQL and Amazon Aurora PostgreSQL connections.

JDBC connection string format

When setting up the 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 might require additional parameters depending on your environment. Consult your database administrator or see your database documentation.
Amazon Redshift
jdbc:redshift://hostname:5439/database_name
MySQL/MariaDB/Amazon Aurora MySQL
jdbc:mysql://hostname:3306/database_name
Oracle
jdbc:oracle:thin:@hostname:1521:service_name
PostgreSQL/Amazon Aurora PostgreSQL
jdbc:postgresql://hostname:5432/database_name
SAP HANA
jdbc:sap://hostname:30015
Sybase
jdbc:sybase:Tds:hostname:5000/database_name
Teradata
jdbc:teradata://hostname/database=database_name

Add credentials

Only username and password authentication is supported.

  1. Select Add Credentials.

  2. Fill in the following:

    • Name: Provide a clear name for this set of credentials.

    • Description (Optional): Explain what the credentials are used for or provide other useful information.

    • Username: The username for the data source.

    • Password: The password for the data source.

  3. To use this set of credentials by default when connecting to the data source, select Set as default.

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

Add write credentials

If you want to export data to this source, add write credentials. Select Add Credentials and follow the instructions in Add credentials.

Next steps

Test and save your connection to complete setup.

Was this page useful?