Re: SAP HANA to Oracle

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 25 Apr 2016 20:14:14 -0400
Message-ID: <571EB2D6.4_at_gmail.com>

Hi David,
Oracle has heterogeneous gateway which can query any ODBC compliant database. The documentation is here:

http://docs.oracle.com/database/121/HETER/toc.htm

Easysoft also has a pretty nice cheat sheet which can be found here:

http://www.easysoft.com/applications/oracle/hsodbc.html

SAP has a very decent ODBC driver which can be used to set up a HS connection.
Regards

On 4/25/2016 5:46 PM, David Barbour wrote:
> We are moving our SAP BW installation off Oracle to SAP HANA.
> Currently, to support a data warehouse that incorporates SAP as well
> as data from other sources, we are using PL/SQL to extract certain
> information from the SAP BW database that completely by-passed all the
> SAP connection layers/tools/etc.
>
> Is anyone querying SAP HANA directly from Oracle? If so, how? If
> not, what methodology might be in use to transfer data into Oracle
> from HANA.
>
>

-- 
--
Mladen Gogala
Oracle Consultant
http://mgogala.freehostia.com

DISCLAIMER: I am solely responsible for any opinion expressed in this email

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 26 2016 - 02:14:14 CEST