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
Perfect! Thank you!
YanıtlaSilwhy i am getting this error:
YanıtlaSilODI-26178: Unable to connect to the Repository user.
Access denied for user 'ODIMASTER1'@'localhost' (using password: YES
please help me to reolve this