Data movement
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello I'm AK form India and had question if anyone can help me to guide further - My question is I'm planning to move data form DB to Data Lake using Alteryx workflow . But struggling how should i move further and how to configure workflow to get updated data form DB to Data lake and in future if nay changes are done in data base then how workflow will manage to bring those changes to Data lake . Can someone can explain me how to perform entire process if steps are available probably it would be helpful for me to configure further .
How to move data first time from selected date and what should be the process for further to pull updated data form DB to Data lake ?
Thanks Ak
Solved! Go to Solution.
- Labels:
- Documentation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @indakath ,
This is really a connectivity question. This depends on the platform and format of your datalake. If you are using Azure Datalake, for example then you can use the Azure connector which will allow you to pull and post data to and from tables. If you have Snowflake, use the Snowflake connector.
If you have your own internal datalake, then your DB admins will provide connectivity, either via ODBC or API.
If you are using a simple ODBC connection to an in-house DB then you can simply set up the ODBC connection on your machine and use this in the input and output tools in Alteryx to connect to your database.
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @indakath - This is a very broad question that may go far beyond just Alteryx platform. I suggest you to speak with an Alteryx Solutions Engineer or Partner.
You may also benefit from reading use cases: https://community.alteryx.com/t5/Alteryx-Use-Cases/tkb-p/use-cases
Just search for "migration".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Many many Thanks for your suggestion its really helpful ..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @mceleavey, I want to seek for your expert advice here too - if I need to pick up a file that's not currently support with the Azure Data Lake Connector - can i try to establish the connection using this - "then your DB admins will provide connectivity, either via ODBC or API" and get the file / data from there?
I try to check online, but is there any way we can establish this ODBC driver for ADLS?
Thanks for the advices in advance.
