connect oracle database to mysql server
$30-250 USD
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
Project ID: #12284074
About the project
6 freelancers are bidding on average $139 for this job
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
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
I'm certified Oracle dba and Oracle developer since 2000. You can contact with me at any moment to discuss your task.