Acumatica Odata connector
AnsweredWhich application or service?: Acumatica, Snowflake
What type of connector? SaaS
Additional details: We are trying to create a CDC pipeline between Acumatica ERP and our Snowflake DW. I understand that you already have an Acumatica connector (Acumatica Lite) however this does not support custom tables where most of our business data is stored so this will not be suitable. There are workarounds using Python scripts in Snowflake but we would prefer to use Fivetran for easier pipeline management. We also don't have direct access to the Acumatica db so we must use their API/ OData tool. Can you please advise if there is another Fivetran connector that would work or a plan to introduce a new connector in the future.
-
Official comment
Hi Daniel,
Thank you for submitting your feature request for the Acumatica connector.
We will be starting our analysis to evaluate your requirements around custom tables. As we move forward, we may reach out with additional questions or clarifications to ensure the solution aligns with your requirements and expectations.
To help us understand your needs better, could you share a few more details:
- Missing data: Could you let us know which data you’re not able to fetch with our current Acumatica connector schema? Specific tables, fields, or examples of the custom data you need would help us understand the gap.
- CDC pipeline: Could you explain a bit more about what you’re looking for here? Our understanding is that you’d like all changes in Acumatica (new records, updates) to be captured and reflected in Snowflake. Please let us know if that’s correct, or if you have something else in mind.
- Python scripts: You mentioned there are workarounds using Python scripts in Snowflake. If you have a script you’re using or have tried, would you be able to share it with us (with any credentials or sensitive values removed)? It would help us understand the API flow, the endpoints and tables involved, and how the data is retrieved, so we can explore and evaluate the best approach.
We appreciate your feedback and continued support - it plays a key role in shaping our roadmap.
Best regards,
Sahu
Please sign in to leave a comment.
Comments
1 comment