create connection

Creates a database connection profile, which includes the agent and the JDBC parameters.

Syntax

create connection connection_name 
set type [{to|=}] {ASE | ASE_CLUSTER | RSSD | MSSQL | ORACLE | IQ | HANADB | UDB}
and set agent [{to|=}]agent_name 
and set host  [{to|=}] host 
and set port [{to|=}] port
and set database [{to|=}] database_name
and set user [{to|=}] user
[and set password [{to|=}] password]
[and set desc [{to|=}] description]
[with node set host [{to|=}] host and set port [{to|=}] port
[and node set host [{to|=}] host 
and set port [{to|=}] port]…]
[with properties set property_name [{to|=}] property_value
[and set property_name [{to|=}] property_value ]…]

Parameters

connection_name – the name of the connection to be created.

type – the connection type supported by Replication Server Data Assurance Option.
Each DA connection configuration object has a type parameter:
- ASE – for an SAP Adaptive Server database connection.
- ASE_CLUSTER– for an SAP Adaptive Server Cluster database connection.
- RSSD – for an SAP Replication Server System Database (RSSD) connection.
- IQ – for an SAP IQ database connection.
- ORACLE– for an Oracle database connection.
- HANADB – for an SAP HANA database connection.
- MSSQL – for a Microsoft SQL Server database connection.
- UDB – for an IBM DB2 Universal Database (UDB) connection.
Note: Configure the JDBC drivers before creating IBM DB2 UDB, Microsoft SQL Server, Oracle or SAP HANA database connections. type is case-insensitive.
You cannot set the host name and port number for an ASE_CLUSTER connection; you must set these values inside a node definition. agent_name is invalid, if the connection type is Replication Server System Database (RSSD). An RSSD connection cannot define an agent.
agent_name – the name of the agent that establishes the connection to the database.
database_name – the name of the target database.
host – the host name of the machine on which the target database is installed.
port – the port number of the machine on which the target database is installed.
user – the database login name. The user must have select permission. To automatically reconcile inconsistent, missing, and orphaned rows in the target database, the user must have the update, insert, and delete permissions.
password – (optional) the password for the user login name.
Note: If your Adaptive Server instance has a system administrator (sa) login with a null password, you must also state a null password in DA server, either by setting a blank password or by not setting a password at all.
description – (optional) description of the agent. Use double quotes if you are using a reserved word or blank spaces.
property_name – the JDBC driver connection property name.
See Connection Properties in the SAP jConnect for JDBC 16.0 Programmers Reference.
property_value – the value of the property to be set.

Examples

Example 1 – creates an SAP Adaptive Server connection named “MyConnPDB”:

create connection MyConnPDB
set type=ASE
and set agent=pdbAgt
and set database=mypdb
and set host=myhost
and set port=1111
and set user=myuser
and set password=mypwd
go

Example 2 – creates an RSSD connection:

create connection MyRSSDConn
set type=RSSD
and set host=rshost
and set database=RSSD_database_name  
and set port=2222
and set user=rsuser
and set password=rspwd
go

Example 3 – creates an SAP Adaptive Server connection that authenticates the user with a Kerberos authentication server:

create connection MyConnPDB
set type=ASE
and set agent=pdbAgt
and set database=mypdb
and set host=myhost
and set port=1111
and set user=myuser
and set password=mypwd
with properties
set REQUEST_KERBEROS_SESSION=true  
and set SERVICE_PRINCIPAL_NAME=myserver
go

Example 4 – creates an SAP Adaptive Server connection that encrypts the login password:

create connection MyEncryptedPasswordConn
set type=ASE
and set agent=pdbAgt
and set database=mypdb
and set host=myhost
and set port=4901
and set user=myuser
and set password=mypwd
with properties
set ENCRYPT_PASSWORD=true
go

See Connection Properties in the SAP jConnect for JDBC 16.0 Programmers Reference.

Example 5 – creates an Oracle database connection:
```
create connection ora1
set type=oracle
and set agent=localagent
and set host=“10.0.14.129”
and set port=1521
and set database=XE
and set user=Aladdin
and set password=Op3nSesame
with properties
   set sessionTimeZone 'Europe/London'
go
```
The Oracle database attribute must be set to the Oracle SERVICE_NAME value, which is stored in the tnsnames.ora file, in :%ORACLE%\product\10.2.0\server\NETWORK\ADMIN\. The exact path varies, based on the Oracle database version installed on your machine.
The attribute might contain:
```
SERVICE_NAME = XE
```
The sessionTimeZone connection property is used by the Oracle JDBC driver, when comparing TIMESTAMP WITH LOCAL TIME ZONE columns.

Example 6 – creates an SAP IQ database connection:

create connection iq1
set type=IQ
and set agent=myagent
and set host= “10.0.14.119”
and set port=2638
and set database=iqdemo
and set user=Aladdin
and set password = Op3nSesame
go

Example 7 – creates an SAP HANA database connection:

create connection myHDBconn1   
set type=HANADB   
and set agent=myagent   
and set host="10.0.14.119"   
and set port=30315
and set user=HAUSER   
and set password=Pa55word   
go

Example 8 – creates an IBM DB2 UDB connection:

create connection myIBMdb1
   set type=UDB
   and set agent=myagent
   and set host="10.0.14.121"
   and set port=5001
   and set database=PUBS2
   and set user=JOHN
   and set password=ibmsq12
   go

Example 9 – creates a Microsoft SQL Server connection:

create connection mysqldb2
   set type=MSSQL
   and set agent=myagent
   and set host="10.0.14.133"
   and set port=1433
   and set database=pubs2
   and set user=steve
   and set password=mste11
   go