Hi all,

I’m using SAP Business One on-prem (SQL Server / or HANA — depending on DB backend) as our ERP. I want to build a pipeline that, every morning at 9:00 AM IST:

1. pulls transactional data (invoices, customers, products, stock, etc.) from SAP B1,

2. loads the data into Zoho DataPrep (or directly into Zoho Analytics if feasible),

3. transforms / cleans / joins data as needed,

4. pushes the processed data into Zoho Analytics tables, and

5. updates dashboards automatically — no manual intervention.

Before I build this from scratch, I’d like to know if anyone has done something similar — ideally in a production environment. My questions are:

• Is the recommended approach using Zoho Databridge → DataPrep → Zoho Analytics, or is there a simpler/better alternative (e.g. direct DB → Analytics)?

• What are the biggest challenges you faced (DB connectivity, incrementally loading new data, scheduling reliability, data freshness)?

• How did you handle schema changes over time (e.g. new fields in SAP B1)?

• For on-prem SAP B1 instances, are there any performance / security considerations you’d advise before setting up the pipeline?

• Any sample SQL queries / config examples (or links to threads / docs) that worked well for you.

If you have a working implementation — on MS SQL Server or HANA — I’d appreciate you sharing your design or lessons learned.

Thanks in advance!