Auto Link: Connections Strings

Michael Rentschler  29 March 2010 09:33:11 AM

Auto Link Connection Strings can either be defined via the separated fields (Server Name and Security Settings) on the table properties dialog

or by defining the entire connection string in the connection string field

The following formats are supported:

C#
MS SQL
Data Source=myServerAddress\instanceName;User Id=myUsername;Password=myPassword;

Oracle:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVERÞDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;

MySQL
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Java:
MS SQL
jdbc:sqlserver://myServerAddress\instanceName;user=myUsername;password=myPassword

Oracle:
jdbc:oracle:thin:myUserName/myPassword@//myServerAddress:portNumber/serviceName

MySQL
jdbc:mysql://myServerAddress/myDataBase?user=myUsername&password=myPassword

Note on Java:
Please be aware that the connection strings used for C# and Java (JDBC) are very different, and hence JDBC connection strings will *not* work in the UI and the only way to test them is via the TestExecutive.

Note on Java and Oracle
The use of the "@" character in the username/password is not supported, so that it will have to be specified in the "UserName" and "Password" fields/attributes. The connection string is as follows: “jdbc:oracle:thin:@//myServerAddress:portNumber/serviceName”

Decision Server Runtime:
"ConnectionString" attribute is also available on DbConnection elements in decisionServer.config, allowing users to override "ServerName" ("WindowsAuthentication" - when available, "UserName", and "Password" still apply as above).

• Comments [0]