connect oracle database to mysql server

In Progress Posted 7 years ago Paid on delivery
In Progress Paid on delivery

connect oracle database to mysql server

Installing MYSQL ODBC Driver on RedHAt

Installing Oracle Database Gateway for ODBC

i need to query mysql data base from oracle database on other machine.

my machine RHEL linux

#grep MemTotal /proc/meminfo

MemTotal: 16199476 kB

#grep SwapTotal /proc/meminfo

SwapTotal: 16382972 kB

#df -k /tmp

Filesystem 1K-blocks Used Available Use% Mounted on

/dev/sda3 3965120 8348 3752024 1% /tmp

#cat /etc/issue

Linux Server release 6.7

Kernel \r on an \m

#cat /proc/version

Linux version 2.6.32-573.3.1.el6.x86_64

#uname -i

x86_64

#uname -a

Linux lucky 2.6.32-573.3.1.el6.x86_64 #1 SMP Thu Aug 13 10:38:46 PDT 2015 x86_64 x86_64 x86_64 GNU/Linux

i done some steps myself but now i preferd that somebody who has experionce and knowledg aill do this job.

I have done myself but it not working

# yum localinstall [login to view URL]

# yum install mysql-connector-odbc

# yum install unixODBC

# Create [login to view URL]

# fill /etc/[login to view URL]

# fill /etc/[login to view URL]

# Installing Oracle Database Gateway for ODBC

# fill /###/app/oracle/product/[login to view URL]

odbcinst –j

unixODBC 2.2.14

DRIVERS............: /etc/[login to view URL]

SYSTEM DATA SOURCES: /etc/[login to view URL]

FILE DATA SOURCES..: /etc/ODBCDataSources

USER DATA SOURCES..: /root/.[login to view URL]

SQLULEN Size.......: 8

SQLLEN Size........: 8

SQLSETPOSIROW Size.: 8

must be someone who make this job before and know all stages
i forgot to add that the job include oracle data base link to sql query the mysql db

some links:
https://www.pythian.com/blog/how-to-access-mysql-from-oracle-with-odbc-and-sql/
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-walkthrough.html
http://docs.oracle.com/cd/B28359_01/gateways.111/e10311/toc.htm
https://docs.oracle.com/cd/B28359_01/gateways.111/b31042/installodbc.htm#BHCCEAHD

In my opinion those who already know and did this project make the project take half an hour to an hour.
So do not go overboard with price

you should connect my system via team viewer

Database Administration MySQL Oracle UNIX

Project ID: #12284074

About the project

6 proposals Remote project Active 7 years ago

6 freelancers are bidding on average $139 for this job

bindmission

Hello I have an experience of 5 year in Linux platform and MYSQL ODBC setup.I will setup oracle data base link to sql query the mysql db PROFILE : Am a Redhat certified Engineer ( Cert ID : 120-202-320 More

$100 USD in 3 days
(154 Reviews)
6.2
shahzaib121

Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. I have done many work in Requirements analysis , More

$155 USD in 3 days
(15 Reviews)
4.2
scorpioangry55

I'm certified Oracle dba and Oracle developer since 2000. You can contact with me at any moment to discuss your task.

$100 USD in 3 days
(7 Reviews)
4.4