New Source: Microsoft Access

dsanthosh16 commented 3 years ago

Tell us about the new integration you’d like to have

Which source and which destination?
Microsoft Access to Snowflake. ( Plan to move more than 500 acesss tables to Snowflake)
Do you need a specific version of the underlying data source e.g: you specifically need support for an older version of the API or DB? Latest MS Access version
Describe the context around this new integration
Which team in your company wants this integration, what for? This helps us understand the use case.
Integration Team.
How often do you want to run syncs?
Plan to sync the incremental/full refresh of tables data on daily basis.
If this is an API source connector, which entities/endpoints do you need supported?

What are you considering doing if you don’t have this integration through Airbyte? In Discussion

┆Issue is synchronized with this Asana task by Unito

sherifnada commented 3 years ago

@dsanthosh16 I'm not super familiar with access, can you help me answer a few questinos:

Where are you running Microsoft Access? Is it in the cloud somewhere, on-premise, or on your personal computer?
do you have any examples of accessing Access via code?

sherifnada commented 3 years ago

there are some available JDBC drivers like this one http://ucanaccess.sourceforge.net/site.html
there is no REST API