My Oracle Support Banner

Frequently Asked Questions Concerning The Use Of ODI With Microsoft SQLServer (Doc ID 811186.1)

Last updated on OCTOBER 14, 2019

Applies to:

Oracle Data Integrator - Version 10.1.3.4.0 and later
Information in this document applies to any platform.




Purpose

This FAQ is created to summarize all of the Oracle Data Integrator (ODI) - Microsoft SQLServer related articles into one location for easy reference and a quick synopsis of the article content.  Please note that the articles are specific technical questions used to document solutions to frequent customer issues.

 

You can also refer to the Oracle Data Integrator User's Guide and Oracle Data Integrator Knowledge Module Reference's Guide to find more detailed information about the use of the Microsoft Corporation SQLServer Technology in ODI.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 How to choose a JDBC Driver for Microsoft SQLServer?
 Hints for Oracle Data Integrator (ODI) 11g
 Hints for Oracle Data Integrator (ODI) 10g
 How do we install ODI and Microsoft SQLServer on a new server?
 Why after having launched the "repcreate.bat/sh" script when installing the Repository in Microsoft SQLServer, we see the error "Error detected during Repository Installation"?
 How is it possible to dynamically disable Microsoft SQLServer table constraints at ODI processing runtime?
 How do you reverse a table with NULL data types?
 How can you nest an SQL SELECT instruction within an initial SELECT statement?
 How can you use multi-byte characters with Microsoft SQLServer?
 How does ODI take into account specific Microsoft SQLServer collating settings on relational table fields and propagate them to the temporary collect and integration tables?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.