5 Nisan 2016 Salı

ODI 12c - creating MySQL master repository

Hi

In this entry i will show how to create a master repository over MySQL db.


Version :  MySQL Server 5.6


At first , logging into Master repository creation wizard and i have following menu






















I am gonna create my master repository over  test database so

JDBC URL :    jdbc:mysql://127.0.0.1:3306/test

*If you are using MySQL (release 5.5.14 or higher) to setup a repository, and the database charset is set to utf8, you will need to add the following parameters to the repository's jdbc URL to operate non-ASCII data correctly in Oracle Data Integrator Studio
( Source : http://docs.oracle.com/cd/E28280_01/install.1111/e16453/manual.htm#ODING492  )

JDBC URL :   jdbc:mysql://127.0.0.1:3306/test?useUnicode=yes&characterEncoding=utf8


Registry Database Name : test   ( Db  i am gonna use for master )


User:    Any user you create with admin privileges over MySQL
( root user cant work here bcoz ODI makes it uppercase automatically so it raise a connection error )


DBA User :  You can use root user  in here or the user you create above.




Result  will be look like this :
















ODI 12c might raise warning for some of the parameters in MySQL.In order to avoid this ,you can set following parameters in your my.ini file (located under your mysql  installation folder) .

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
innodb_file_format=Barracuda
innodb_large_prefix=1
log_bin_trust_function_creators=1







1 yorum: