JDBC Sources > Before you begin > Create a connection
  

Create a connection

Before you configure the JDBC catalog source, create a connection object in Administrator.
    1In Administrator, select Connections.
    2Click Add Connection.
    3Search for and select JDBC V2 and then click Next.
    4Enter the following connection details:
    Property
    Description
    Connection Name
    Name of the connection.
    Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
    Maximum length is 255 characters.
    Description
    Description of the connection. Maximum length is 4000 characters.
    Use Secret Vault
    Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
    This property appears only if secrets manager is set up for your organization.
    When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
    Note:
    If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option.
    For information about how to configure and use a secrets manager, see Secrets manager configuration.
    Runtime Environment
    The name of the runtime environment where you want to run tasks.
    Select a Secure Agent.
    JDBC Driver Class Name
    Name of the JDBC driver class.
    For example, to connect to Apache Cassandra, specify the following driver class name: cdata.jdbc.cassandra.CassandraDriver
    For more information about which driver class to use with specific databases, see the corresponding third-party vendor documentation.
    Connection String
    Connection string to connect to the database.
    Use the following format to specify the connection string: jdbc:<subprotocol>:<subname>
    For example, the connection string for the Apache Cassandra database type is jdbc:cassandra://<host>:<port>[/keyspacename].
    For more information about the connection string to use with specific drivers, see the corresponding third-party vendor documentation.
    User Name
    The user name to connect to the database.
    Password
    The password to connect to the database.
    5In the Advanced Settings section, you can choose to enter sensitive information such as the client ID, client secret, or refresh token in the following property:
    Property
    Description
    Additional Security Properties
    Masks sensitive and confidential data of the connection string that you don't want to display in the session log.
    Specify the part of the connection string that you want to mask.
    When you create a connection, the string you enter in this field appends to the string that you specified in the Connection String field.
    6Click Test to test your connection to the source system.
    7Click Save.