Shared Content for Data Engineering All Products
./infacmd.sh createConnection -dn Domain_irl63ppd06 -un Administrator -pd SAM123 -cn PostgreSQL -cid PostgreSQL -ct JDBC_V2 -cun adaptersX1 -cpd adaptersX1 -o "connectionstring=' jdbc:postgresql://aurorapostgres-appsdk.c5wj9sntucrg.ap-south-1.rds.amazonaws.com:5432/ JDBCV2' jdbcdriverclassname='org.postgresql.Driver' schemaname='public' subtype='PostgreSQL' supportmixedcaseidentifier='true' quoteChar='(quotes)'"
The database user name.
User name with permissions to either access the Azure SQL Database, PostgreSQL, or relational database.
The password for the database user name.
The schema name to connect in the database,
Name of the JDBC driver class.
The following list provides the driver class name that you can enter for the applicable database type:
For more information about which driver class to use with specific databases, see the vendor documentation.
Connection string to connect to the database.
Use the following connection string:
The following list provides sample connection strings that you can enter for the applicable database type:
For more information about the connection string to use with specific drivers, see the vendor documentation.
The database type to which you want to connect.
You can select from the following database types to connect:
Enable if the database uses case-sensitive identifiers. When enabled, the Data Integration Service encloses all identifiers within the character selected for the
SQL Identifier Characterproperty.
For example, PostgreSQL database supports mixed-cased characters. You must enable this property to connect to the PostgreSQL database.
SQL Identifier Characterproperty is set to none, the
Support Mixed-case Identifiersproperty is disabled.
Type of character that the database uses to enclose delimited identifiers in SQL queries. The available characters depend on the database type.
Select (None) if the database uses regular identifiers. When the Data Integration Service generates SQL queries, the service does not place delimited characters around any identifiers.
Select a character if the database uses delimited identifiers. When the Data Integration Service generates SQL queries, the service encloses delimited identifiers within this character.