• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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