How to created OLE DB connection string with encrypted username and password for ORACLE?

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I got an requirement to create the OLE DB connection for ORACLE Database which should not contain the USER ID and PASSWORD in plain text.

When I am creating the Connection string User Name and Password is shown as below:

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=DBREPORT;Data Source=DBDEV;Extended Properties=""] (XPassword is ABjSOIUIXaXEVCBKRRNCP);

How to make above OLE DB Connection encrypted so that UserID and Xpassword should not visible similar to MS SQL SERVER.

I need your help.

Regards,

Vijay Anand

topic How to created OLE DB connection string with encrypted username and password for ORACLE? in QlikView

How to created OLE DB connection string with encrypted username and password for ORACLE?