This content has been marked as final. Show 3 replies
Instead of manually creating Connection pool, if you import XML data Admin tool will take care of things right?
To import XML data using ODBC:
To access XML data sources through ODBC, you need to license and install an XML ODBC driver.
Next, create ODBC DSNs that point to the XML data sources you want to access, making sure you select the XML ODBC database type.
From the File menu, choose Import > from Database.
Follow the instructions in the dialog boxes to import the ODBC DSNs into the repository.
i think you have misundertood my post, or i have not explained myself clearly
I dont want to import XML data using admin tool or use XML as a datasource
Instead I want to find out if there is an XML file that holds the ODBC connection parameters
hope this is more clear
I think Yes, and for that we have to go for repository variables and Connection Scripts tab in connection pool wizard.
DSN,uid, and pwd are values of rep variables and these are loaded using Connection Scripts options.