Skip to main content
Solved

SAP Analytics Cloud (SAC) as Endpoint for Visualization


Forum|alt.badge.img

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.

 

 

Best answer by rory.smith

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.

View original
Did this topic help you find an answer to your question?

4 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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

Forum|alt.badge.img
  • Author
  • Participant
  • 17 replies
  • August 20, 2024

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.

 


rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 649 replies
  • Answer
  • August 20, 2024

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.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings