Connecting ma access db from Matillion

Matillion ETL
1

Hi, Can someone help me what is the best approach to connect MS Access db from Matillion and load data to Snowflake on daily basis.

thanks

C

 

2

Hi, have you tried components Database Query? It is for connecting on-prem databases to Snowflake and stage the files in S3. Not sure if it has an option for MS Access DB.

3

The other method would be to use Python (specifically the pandas module). This would be a last resort though. As @CP872896​ and @Michael​ mentioned, the database query component is a great universal component for situations like yours.

4

Anyone have any thoughts on a specific JDBC Driver for MS Access? I have not been able to find one.

5

This would be my first suggestion as well. You can install custom drivers for the Database Query Component. If there is a JDBC driver for MS Access available, you should be able to use it with this component.