Skip to main content

Hi,

I have couple of questions from a prospect who is using SAP.

  1. C​an we connect to SAP S/4 HANA Databased as Data Source, if yes how
  2. Once we get the data and create MDW/Data Mart, can we have endpoint as SAP Analytics Cloud (SAC) which is SAP’s Visualisation Tool.

 

 

Hi @pkaustubha 

  1. Yes
  2. It is not possible to deploy directly to SAC endpoint via TimeXtender, since this is not currently a supported endpoint. We currently support the following endpoints, as well as CSV:
    However you should be able to connect SAC to a TimeXtender DW with SQL storage:
    https://community.sap.com/t5/technology-blogs-by-members/sap-analytics-cloud-connect-ms-sql-server-versions-workaround-setup-live/ba-p/13494770

Hi Christian,

Thanks for your positive revert. Correct my understanding, with SAP Theobald XU, I connect the SAP HANA Datasource to TX ODX Server where ODX and MDW is on SQL Server Database and once I set-up the entire Data Warehouse as per customer need and then deploy. Then I can connect SAC to SQL. Is it right understanding. 

Also is there any step-by-step guide to connect SAC to SQL Via TimeXtender

Please suggest.

 


Hi,

 

you can use Theobald Xtract IS + SAP Table connector (requires SSIS-enabled IaaS SQL Server instance) or use Theobald Universal + REST / JSON connector to extract from SAP.

SAP SAC can either import data from supported SQL Server versions (check if Azure SQL is supported if you are using that) or connect live through SAP SDA / SDI. I don't think there is any guide yet as this is not a particularly popular approach to take.


@pkaustubha as Rory mentions we do not have a step-by-step guide


Reply