Solved

Can I use StreamSets to ingest data to an on-premise Oracle DB? (Looking to move to the cloud)

  • 10 February 2022
  • 2 replies
  • 81 views

Userlevel 5
Badge

Can I use StreamSets to ingest data to an on-premise Oracle DB? (Looking to move to the cloud)

icon

Best answer by Drew Kreiger 10 February 2022, 19:04

View original

2 replies

Userlevel 5
Badge

Yes. You can connect to Oracle via the JDBC Origins whether on-prem or in the cloud as long as the DataCollector machine can access the on-prem Oracle using JDBC.

I will try this product for the first time.
We cannot access the internet where there is critical data.
How should I go about making a cdc copy from oracle to postgres in an environment where there is no internet.
Is this possible with streamsets?
Can you share a document that I can follow?

Reply