connect oracle database to mysql server

Em Andamento Postado há 7 anos Pago na entrega
Em Andamento Pago na entrega

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

Administração de Bancos de Dados MySQL Oracle UNIX

ID do Projeto: #12284074

Sobre o projeto

6 propostas Projeto remoto Ativo em há 7 anos

6 freelancers estão ofertando em média $139 nesse trabalho

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 Mais

$100 USD in 3 dias
(154 Comentários)
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 , Mais

$155 USD in 3 dias
(15 Comentários)
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 dias
(7 Comentários)
4.4