Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC)

MOSC Banner

Move data from one table in SQL server DB to Oracle DB

in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 1 comment

Hi All

Kindly, I need to move data from one table in SQL server DB to Oracle DB same table every hour.

My DB 11.2.0.4 on linux

SQL server I do not know the version but it's on windows

I was trying to create DB link in Oracle DB but I end that it's must to have license for "oracle database gateway for SQL server", and purchasing that license rejected in My company


is there is any way that I can have that DB link without "oracle database gateway to SQL server"?

is there is any other way to schedule a job to copy the data from SQL server to Oracle DB? such as using MS Power BI, MS Power Automate, ... so I can learn & study

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center