SAP Business One with HANA Database Connection with TimeXtender

Hi @pkaustubha 

For Xtract IS + TimeXtender SAP data source please see the following guide:

https://legacysupport.timextender.com/hc/en-us/articles/360029528932-ODX-SAP-Tables-Data-Source-Guide

For Xtract Universal + REST data source please see the following guide:

• Theobald Xtract Universal Tutorial

Our existing customers on SAP BusinessOne are utilising the OData API to extract data.
This can be achieved with the TimeXtender REST data source.

At implementation, OData was the only supported way by SAP to get data out of SAP BusinessOne.

Hi Frank,

Do we have any specific step-by-step guide to complete the same as I have a prospect in Mumbai with 3 Data Sources

1. Dynamices 365 F&O on Cloud
2. SAP B1 with HANA Database
3. SAP ECC with SQL Database 

They want to connect all and generate ETL

Hi,

1. is covered in your other thread
2. is covered here
3. no guide as there are many options: CData has a SAP connector, but only useful for small dimensional tables as it is dead slow. Theobald delivers Xtract IS (SSIS-based) and Universal (produces its own webservice server, use JSON / REST to consume) which each have their own complexity and cost associated also depending on the SAP setup. If you can touch the SQL Server, you can load directly until 2028 when you will be forced to migrate to HANA. I would advise against the last, as that comes with its own can of worms.