![]() ![]() The website cannot function properly without these cookies.Ĭloudflare sets this cookie to identify trusted web traffic. Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. ![]() The Definitive Guide to Jython: Python for the Java Platform. Scripting in Java: Languages, Frameworks, and Patterns Jython If you want to master scripting in ODI get the following books. Of course, your ODI agent must not run as the Local System account but use a network account that has the appropriate MS SQL privileges to log into the SQL Server. Jdbc:sqlserver://: databaseName= integratedSecurity=true ĩ. Open Topology Manager module and create Physical Server for MS SQL technology. Re-install the ODI agent with the “agentservice -i” command.Ĩ. Next you need to edit the “nf” file in the toolswrapperconf directory.ħ. Stop the agent and uninstall the agent with the agentservice –r command. If you have set up the ODI agent as a Windows service you need to re-install the agent. set ODI_ADDITIONAL_JAVA_OPTIONS=”=c:oracleoracledidrivers”Ħ. Open odiparams.bat and add the following entry: set ODI_ADDITIONAL_JAVA_OPTIONS=”=oracledidrivers”, e.g. Copy the sqljdbc4.jar file to the oracledidrivers folderĥ. Copy the sqljdbc_auth.dll to the oracledidrivers folder.Ĥ. The driver comes with a separate dll (sqljdbc_auth.dll) that will allow you to connect to SQL Server via your Windows login. If you haven’t done so already now is the time to install JDK 5.0 or even better JDK 6.0.ģ. You will need to be up and running on JDK 5.0 or later with your ODI installation. This is compatible with versions 2000, 2005, and 2008 of MS SQL. Download the Microsoft SQL Server JDBC Driver 2.0 from the Microsoft website. Note: This will only work where the ODI agent has been installed on a Windows OS.ġ. ![]() Below are the steps that you need to perform to get this to work. You often end up with the message “This driver is not configured for integrated authentication”. Setting up integrated security with the SQL Server JDBC driver can be tricky. Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |