• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 519
  • Last Modified:

Oracle / AS400 - Link

Can someone point me in the right direction.

is there a way to link oracle to query data on an AS400 via something like ODBC.

The conditions are that there is no need to make any program installations or changes to the as400, if there is some sort of middleware solution that can work for me.

I would only need access to do select statements as we will not be updating any data
0
gnivkor
Asked:
gnivkor
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
What is the data on the AS400 contained in?

Are you asking how to link a local Oracle database to an Oracle database on an AS400?

If so, database links:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_5005.htm

If not, please clarify.
0
 
Jon SnydermanCommented:
The AS400 native database fully supports ODBC.  What platform is Oracle running on?  There are ODBC drivers for windows and linux.

~ Jon Snyderman
0
 
gnivkorAuthor Commented:
Oracle is installed on a linux server

as400 db2, I want to be able to run queries from oracle using data on the as400

i am able to connect to the as400 with access using odbc, i am looking for a similar setup on the oracle side
0
 
slightwv (䄆 Netminder) Commented:
What you are after is Oracle Hetergenous Services:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/ds_concepts001.htm#i1007606

This allows you to connect Oracle to non-Oracle databases.
0
 
gnivkorAuthor Commented:
thank  you
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now