Matallion ETL (on AWS) connectivity to On premise MS SQL Server and Oracle Database

Matillion ETL
1

Hi Team,

I would like to know , what are the options for Matallion ETL hosted on AWS to connect to the On Premise Ms SQL server or on premise Oracle database ? What infrastructure is required to setup or any additional components or gateway required to connect.

Our use case is , we are using Matallion Hub and Matallion ETL and we want to extract full tables (30+) from SQL server/Oracle on premise database and want load / ingest it into Snowflake dataware house ,what are options or setup needed from architecture perspective

Regards,

Mangesh

2

Hi @mangesh7632​ and thanks for the question! I would suggest checking out our documentation site to start with if you've not already done so. Let us know how you get on!

Many thanks, Claire