cancel
Showing results for 
Search instead for 
Did you mean: 

How to create an import connection to MongoDB in SAC?

0 Kudos
875

Hello guys,

i´m looking for a solution to create an import connection from SAC to MongoDB. I found out, that there is the opportunity to append SAP Cloud Platform Open Connectors in the SAC Administration but i´m not sure if this is the right way.

I can´t find a list of all supported 3rd party tools, which SAP Cloud Platform Open Connectors provides.

Does someone have experience with that? Shall i go by configuring the SAP Cloud Platform Open Connectos or is there an alternative solution?

Best regards

Remzi

Accepted Solutions (0)

Answers (3)

Answers (3)

VijayetaSharma
Active Contributor

Hello yigir,

Options are limited when it comes to exporting data out of SAC. Couple of options available out of the box (target system version matters). Some examples are S/4HANA, BW/4HANA, Export to file server (supports scheduled export) and DWC (soon). As you can see the export options is all limited to SAP applications only (exception file server). Non SAP DB's are not part of this. In-fact a limited set of non SAP DB's are supported for import as well.


Alternate option would be to use SAP DI or SAP open API. SAP Open API can be integrated with 3rd party tools and DB's.
Export Data with the Data Export Service Open API

Or simply use File server as staging layer.

  • SAC > File Server > MongoDB

Don't forget to up-vote and accept, if it helped. 🙂

Vijayeta

Thank you for your response.

I may have expressed myself wrong.

My goal is to get the data from MongoDB into SAC via Import Connection. I want to create Models in SAC based on the MongoDB data to create dashboards with it.

Best regards

Remzi

VijayetaSharma
Active Contributor

then the simplest option is to go with file system based import option. If you choose this option you can schedule import in SAC.


thanks,

Vijayeta

former_member6443
Contributor
0 Kudos

Hi Remzi,

Please mark this question is closed as this will help others looking for an answer.

Regards

Afshin

former_member6443
Contributor
0 Kudos

Hi Remzi,

I have looked at this in the past and struggled given MongoDB is a NoSQL and any deep nested JSON (collection) will prove very problematic ( rather impossible ) to load in SAC.

I suggest you export a MongoDB Collection to CSV to a shared directory and then import the same into SAC.

More information here

Good luck

Afshin

0 Kudos

Hey Afshin,

thank you for your response. Yeah i think i will go this way by creating CSV on our file server.

Best regards

Remzi