cancel
Showing results for 
Search instead for 
Did you mean: 

Build SAP Analytics Cloud Models on MS Azure Data

  1. How do we connect SAC to consume MS Azure Data??
  2. Not needing APOS, iotray, HANA, S4 etc. Only using what is provided with SAC and MS Azure product suite as the focus is not having a need to procure any additional products/systems.
  3. Can it be connected via SAP Cloud Connector? If yes where can we find the documentation.
  4. Can it be connected via native SAP or MS Azure built-in Connector? If yes where can we find the documentation.

Accepted Solutions (0)

Answers (5)

Answers (5)

DebjitSingha
Active Contributor

Hello bhsule,

There are no direct options available at this moment. HANA SDA/SDI, SAP CPI based connection is not what you are looking for. If you are ok with import connection then, your options are-

  1. Use file server (local) - You can setup file (csv/ txt/ excel) export job from Azure (inbuilt functionally); with target as File server > Setup SAP Cloud Connector & Agent > Setup file server connection in SAC and periodically process local files from file server. Please note that SAP Cloud Connector setup do not require any additional cost. This helps connecting on-premise environments to SAC
  2. Direct Import Connection To SQL Server : If your SQL server is hosted on Azure, then you use SAC SQL server connection to connect and import data. SQL Connection from SAC is intended for on-premise environment. Although in your case SQL (hosted on Azure) can be consumed similar to on-premise SQL system. You need to install Cloud connect and agent, on-premise host. Then use SAC connection type SQL to create a connection. SQL (Azure) > SAP Cloud Agent > SAP Cloud Connector > SAC SQL Connection

Hope this helps. Let us know if you have any query around this topic.

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

Thanks,

Debjit

ravikumargarre
Explorer
0 Kudos

hope this is possible by now, where SAP Analytics Cloud got a built-in connector to build models using data from Azure Data Lake...

asmita_mh
Member
0 Kudos

Hi Ravi,

Do you any details on this connection. SAC - > Azure Data Lake

For Analytics reporting i want to extract data models from Azure data lake to SAC and build the dashboards.

Any reference doc/videos/step would be helpful.

Thanks

Asmita

wpranjal
Explorer
0 Kudos

Hi Debjit Singha,

Thank you for the information , your last update for the question is Apr 05, 2021, please could you help us if there are any changes in answers to questions below ?re there any updates regarding Azure connetivity with SAC

How do we connect SAC to consume MS Azure Data??

Not needing APOS, iotray, HANA, S4 etc. Only using what is provided with SAC and MS Azure product suite as the focus is not having a need to procure any additional products/systems.

Can it be connected via SAP Cloud Connector? If yes where can we find the documentation.

Can it be connected via native SAP or MS Azure built-in Connector? If yes where can we find the documentation.

Thanks alot

Regards,

former_member744860
Discoverer
0 Kudos

Hi,

I find myself in a similar situation and i'd be very interested in your return bhsule, did you manage to connect SAC to azure SQL through the on premise connector (SAC CC and SAC agent)?

I think this use case isn't that complex but greatly lacks documentation (if it works).

Thanks,

Best regards.

0 Kudos

@debjit.singha Thank you. let me explore more on this and connect back.

regards.