astronomer / astro-sdk

Astro SDK allows rapid and clean development of {Extract, Load, Transform} workflows using Python and SQL, powered by Apache Airflow.
https://astro-sdk-python.rtfd.io/
Apache License 2.0
354 stars 45 forks source link

Sharepoint integration #1553

Open sridharpaladugu opened 1 year ago

sridharpaladugu commented 1 year ago

Please describe the feature you'd like to see Seeking an integration into sharepoint with astro SDK.

Describe the solution you'd like I have a request from a customer to have a native integration to transfer files from sharepoint to destinations such as SFTP, etc. Basically an ability to download/upload files with sharepoint from ASTRO SDK.

Are there any alternatives to this feature? There are commercially available driver from cdata as an external component and have to implement the code.

Additional context Add any other context about the feature request here.

Acceptance Criteria

sridharpaladugu commented 1 year ago

Looked at the reference implementation using https://github.com/vgrem/Office365-REST-Python-Client.

Currently CDATA driver has a sample -> https://www.cdata.com/kb/tech/sharepoint-jdbc-apache-airflow.rst

Lee-W commented 1 year ago

I'll work on this one