+8We have a team using Azure Data Bricks to do processing and modelling on all sorts of sensors in office buildings, and they will store output in Azure Data Lake. We want to be able to ingest this data (at least the output) and make it available in DH.
Currently this is not natively possible in TX and would require something like Azure Data Factory to move files to a place accessible from TX. Could this be added?
Hi Rory,
Yes, I have that use-case on my list of future additions. We most likely have most of the codebase in place through our ODX Data Lake store functionality.
I assume you are aware that DataBricks can push data directly into SQL Server tables, which would be my suggested workaround - or if it is a matter of few tables, build a Custom SSIS package on the MDW Layer to extract the output into Tables.
Don't know if it helps you, but the with the CData connectors, you're able to read data from an Azure blob (ADLSGen2)
(Tested it with the CData CSV)
This is weird, tried it again today and the options shown above are gone wjen you create a new datasource, but not when you add the source via the environment settings....????? It's the same version ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
