Salesforce

Connect String (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Connect String (Magic xpa 4.x)

To work with the SQL database and execute SQL commands, the user must first connect to the SQL server by sending a connect string to the database. The connect string includes the user name and password of the user to connect with.

Each database has a different connect string structure.

When working with a remote Oracle server, in addition to the user name and password, you need to add an alias pointing to the remote server.

This property does not support logical names.

Windows authentication:

SQL Server: The user name and password should remain blank.

Oracle: The user name should be a forward slash (/) and the password should remain blank.

Examples:

Oracle: (local)
sqlplus username/password
(remote)
sqlplus username/ password@alias

Relevant interfaces: MSSQL and Oracle

Reference
Attachment 
Attachment