How to extract all order data to our data warehouse

steveDevine
New Member
1 0 0

Hoping someone can help with this basic question of the best method to create an ETL process to extract my client's Order data to a Data Warehouse. It feels like their are 2 options

- Orders API

- Reports API

But I'm not sure which is the right option.

Thanks

Steve

Replies 3 (3)
cpola
New Member
1 0 0

Hello Steve,

I'm curious to know, since posting this discussion question, if you have learnt anything around what API or other method is best to use when extracting data or creating an ETL process for Shopify to a data warehouse?

Cheers,

Chris

prasanthp
New Member
1 0 0

I've had success with Stitch Data from Talend. It costs $100 per month though.

Henryjs09
New Member
2 0 0

Hi Steve

 

I think orders API is a suitable option.