Looking for best practices to import data from SAP Business One (on-prem) into Zoho Analytics via Zoho DataPrep / Databridge — daily automated schedule

Looking for best practices to import data from SAP Business One (on-prem) into Zoho Analytics via Zoho DataPrep / Databridge — daily automated schedule

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!