New Source: Microsoft Access

[dsanthosh16]

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?

Describe the alternative you are considering or using

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]

@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]

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