Home » Other » Training & Certification » What are ways to transfer tables from Oracle to SQL Server
What are ways to transfer tables from Oracle to SQL Server [message #676764] Sat, 13 July 2019 05:08 Go to next message
priyankamakke
Messages: 1
Registered: May 2019
Junior Member
I've been searching the internet for this question:

What are ways to transfer data and tables on a daily basis from an Oracle's Hyperion to SQL Server 2000?

I am an intern at a company and trying to figure out possible ways to do this. Any help or point in the right direction is greatly appreciated.
Re: What are ways to transfer tables from Oracle to SQL Server [message #676765 is a reply to message #676764] Sat, 13 July 2019 07:32 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
priyankamakke wrote on Sat, 13 July 2019 03:08
I've been searching the internet for this question:

What are ways to transfer data and tables on a daily basis from an Oracle's Hyperion to SQL Server 2000?

I am an intern at a company and trying to figure out possible ways to do this. Any help or point in the right direction is greatly appreciated.

At the highest level, you create a database link in Oracle database that allow you to push data from Oracle DB into SQL Server
You create a daily batch job that SELECTS and moves the data from source DB into target DB
Re: What are ways to transfer tables from Oracle to SQL Server [message #676766 is a reply to message #676764] Sat, 13 July 2019 11:47 Go to previous message
John Watson
Messages: 8077
Registered: January 2010
Location: Global Village
Senior Member
Hyperion may be owned by Oracle but it does not use an Oracle database. This causes a bit of confusion (as is shown by the previous response). You may need to search for Essbase rather than Oracle.
Previous Topic: Best institute for oracle DBA in Pune?
Next Topic: Oracle Eloqua Integration With Salesforce
Goto Forum:
  


Current Time: Wed Dec 11 00:28:56 CST 2019