QuickBooks to Azure Data Lake
Connect QuickBooks Online to Azure Data Lake Storage with managed syncs. No Azure subscription required to start — then bring the data into your own environment when ready.
DataToLake loads each customer's QuickBooks data into a specific, secure folder in the DataToLake ADLS account.
Selected QBO entities are stored as JSON files for repeatable downstream use.
Customers do not need their own Azure subscription to get started.
Bring the folder into your own Azure tenant or ADLS account with Fabric pipelines, Dataflows, or similar Microsoft data tools.
Customer-specific data folder
DataToLake handles the QuickBooks connection, entity selection, scheduled sync, and storage location. Your selected QuickBooks Online data is written to a customer-specific folder in DataToLake's Azure Data Lake Storage account.
Easy path into your own Azure tenant
When your team wants to own the next layer, the DataToLake folder can be used as a source for a Fabric pipeline, Dataflow, or similar process that copies or transforms the JSON files into your own Azure tenant, ADLS account, warehouse, lakehouse, or semantic model.
DataToLake setup path
DataToLake is built so customers can get QuickBooks data accessible for reporting without standing up their own data pipeline.
Create a DataToLake account, choose a subscription, and complete payment.
Connect QuickBooks Online, choose the company or companies, and select the entities to refresh.
DataToLake stores the selected data securely and makes it available for reporting.
Sign up, connect your first QuickBooks company, and your data is typically available within 15 minutes.
Use the DataToLake Power BI template or your own report to connect to your data and start analyzing.
Azure Data Lake Storage (ADLS) is used behind the scenes; customers do not need their own Azure subscription.