Connection String Formats

Syniti recommends creating a connection by using the connection forms. If you need to use connection properties that are not on the form, provide a connection string using the following example formats.

Replace the information within the brackets with your values. These example formats only show commonly used properties. Depending on your setup, you may require other properties.

SQL Server

• Profiling—mssql+pymssql://[username]:[password]@[hostname]:[port]/[instance [optional]]/?charset=utf8&database=[database]

• Data Quality—sqlserver://[p.Username]:[Password]@[Hostname]:[Port]/[Instance]?database=[Database]

• Migration Working Database—Data Source=[IP or ServerName];User ID=[UserName];Password=[PWD];

• Replication—Data Source=[IP or ServerName];User ID=[UserName];Password=[PWD];

• Construct—Data Source=[Hostname],[Port];User ID=[Username];Password=[Password];Initial Catalog=[Database]

Note

Database is a required parameter in order for Construct to know which database to use when querying tables/views.

• Metadata Scanning—jdbc:sqlserver://[server]:[port],[instance [optional]];user=[username];password=[password]

SAP HANA

• Profiling—hana://[Username]:[Password]@[Hostname]:[Port]

• Data Quality—hdb://[Username]:[Password]@[Hostname]:[Port]

• Migration Working Database—Server=[IP]:[Port];UserID=[UserName];Password=[PWD];

• Replication—Server=[IP]:[Port];UserID=[UserName];Password=[PWD];

• Metadata Scanning—jdbc:sap://[hostname]:[port]/?user=[username]&password=[password]

SAP Sybase ASE

Replication—Data Source=10.1.2.110;User ID=username;Password=*******;Port=5000;QuotedIdentifier=1;

Snowflake

Replication—DRIVER={SnowflakeDSIIDriver};UID=USERNAME;PWD=*******;DATABASE=DATABASE_NAME;SERVER=eab51413.us-east-1.snowflakecomputing.com;

Oracle

• Profiling—oracle+cx_oracle://[Username]:[Password]@[Hostname]:[Port]/?service_name=[ServiceName]

• Data Quality—oracle://[Username]:[Password]@[Hostname]:[Port]/[ServiceName]

• Migration Working Server—Data Source=[IP]/[Instance];User ID=[UserName];Password=[PWD];

• Replication—Data Source=[IP]/[Instance];User ID=[UserName];Password=[PWD];

• Metadata Scanning—jdbc:oracle:thin:[username]/[password]@//[hostname]:[port]/[service_name]

IBM Db2 LUW & IBM Db2 OS/390

Replication—Data Source=[IP];User ID=[UserName];Password=[PWD];Database Server Name=[ServerName];Port Number=[50000];Host CodePage=[SelectOne];

PostgreSQL

• Data Quality—postgresql://[username]:[password]@[hostname]:[port]/[database]

• Replication—Data Source=[HostName];User ID=[UserName];Password=[PWD];Database=[DatabaseName];Port=[5432;

• Metadata Scanning (.Net framework)—Server=[hostname];User ID=[username];Password=[password];Database=[database];Encoding=utf-8;Port=[port];Sslmode=Disable;Pooling=True;MaxPoolSize=100;MinPoolSize=0;Timeout=15;

SAP Application Server

• Replication—DRIVER=Syniti-CData Driver for SAP ERP;Client=[Client];Endian Type=Auto;Host=[IP];Initial Value Mode=[InitialValue];Pagesize=[25000];User=[UID];Password=[PWD];System Id=[SID];System Number=[SNR];

• Metadata Scanning—'{"properties":[{"name":"jco.client.ashost","value":"[ApplicationServer]"},{"name":"jco.client.sysnr","value":"[InstanceNumber]"},{"name":"jco.client.r3name","value":"[SystemID]"},{"name":"jco.client.client","value":"[Client]"},{"name":"jco.client.user","value":"[Username]"},{"name":"jco.client.passwd","value":"[Password]"}]}'

SAP Message Server

• Replication—DRIVER=Syniti-CData Driver for SAP ERP;Client=[Client];Endian Type=Auto;Host=[IP];Initial Value Mode=[InitialValue];Pagesize=[25000];User=[UID];Password=[PWD];System Id=[SID];System Number=[SNR];

• Metadata Scanning—{"properties":[{"name":"jco.client.r3name","value":"[SystemID]"},{"name":"jco.client.mshost","value":"[MessageServer]"},{"name":"jco.client.group","value":"[SAPGroupServer]"},{"name":"jco.client.client","value":"[Client]"},{"name":"jco.client.user","value":"[Username]"},{"name":"jco.client.passwd","value":"[Password]"}]}'