Oracle connection string to be used in a KTA DAS node

Issue

What format of connection string should be used in a DAS node/action when connecting to an Oracle database?

Solution

KTA connects to Oracle using OLEDB so we recommend using the below connection string format.

Provider=OraOLEDB.Oracle;Data Source={TNS Service Name};User Id={Username};Password={Password};

Level of Complexity 

Easy

Applies to