Has anyone used something like MS Power Automate to automate the ingestion of data into an Exasol instance ?
@DomAlbrecht we have an Exasol connector which also works with Power Automat Exasol - Connectors | Microsoft Learn . This connector was built for Power Apps to update /insert small number of rows, e.g. some control tables or editing smaller tables. It’s not built for bulk loading, however you can also send freeform SQL for e.g. trigger the IMPORT Statement.
1 Like
Thanks for the info @thomas_bestfleisch - I would probably only be looking to process around 10000 rows at a time so I hope that fits into the “small” category! Ill checkout your link
@DomAlbrecht Let us know how your experience are with the connector. Would be great to get feedback.