Multiple OLEDB Connections?

Tue, 25 Nov 2014 03:57:35 GMT

I have a Config file where I set an OLEDB connection, data paths and other variables for a data loader.

Looking for suggestions on the best way if its possible, to define multiple OLEDB connections in the Config file then swap between connections as needed in the loader script.

Thanks in advance.

JHS

Re: Multiple OLEDB Connections?

Anonymous — Tue, 25 Nov 2014 04:04:25 GMT

Hi ,

You can create a text file will all OLEDB connection information one by one for ex: dev, test and prod.

Use Include clause to reference the txt file with OLEDB connecation. At a time keep one connection is Uncommented and rest commented.

Suppose if you are in test , keep the TEST OLEDB connection un commented.

Script code is as follows:

$(Include=..\..\_DBConnection\DCTserver_Connection.txt);

Hope ths helps .

BR,

Chinna

topic Re: Multiple OLEDB Connections? in QlikView

Multiple OLEDB Connections?

Re: Multiple OLEDB Connections?