How to create new System DSN on DEV and PROD servers

[#1]

Hi

I want to create n ew system DSN

EXAMPLE :

On Prod Data Source Name – ABC_DW_X

                TNS Service Name  - ABC_DW_X

                User Name       - ipm_qlikview

                Password       - “the assigned team member for this task will receive the password in a separate email – please reply to me for this”

This is needed as temporary solution due to slow loading time through OLE DB to the new EXDATA ABC DW (XYZ) servers

Please suggest.

Br

Anta

[danielrozental]

You mean an ODBC System DSN? You need to login to each server with an administrator account and create them, I don't know if there is another way.