ODI 11g connect to Firebird SQL
ODI installation includes a set of Data Direct drivers for the following technologies: Oracle, Hypersonic SQL, SQL Server, Sybase ASE, and DB2 UDB. If additional drivers and open tools are needed, they must be added to the Standalone Agent and the ODI Studio.
Even though this post explains how we can connect to Firebird SQL but same steps can be used to any JDBC supported database.
Create a new physical architecture
Create a new Data Server.
Driver Class : org.firebirdsql.jdbc.FBDriver
Sample JDBC URL: jdbc:firebirdsql://hostname:port/F:/RESPAKDB/respak.gdb
On Windows operating systems, go to the following directory (not created until after ODI Studio is launched for the first time)
%APPDATA%\odi\oracledi\userlib
This folder contains the additional_path.txt file that allows you to declare additional files or folders outside of the /userlib directory from which the ODI Studio acquires its libraries and drivers.
Sample
; Additional paths file; You can add here paths to additional libraries
; Examples:
; C:\ java\libs\myjar.jar
; C:\ java\libs\myzip.zip
; C:\java\libs\*.jar will add all jars contained in the C:\java\libs\ directory
; C:\java\libs\**\*.jar will add all jars contained in the C:\java\libs\ directory and subdirectories
C:\Users\xxxxxxx\AppData\Roaming\odi\oracledi\userlib\jaybird-full-2.1.6.jar
Now click on the Test Connection and you should be able to see the success message as below.
Now you can proceed to create the logical schema and use it in the models and reverse engineer and use in projects.
No comments:
Post a Comment