on 2022 Jun 14 5:55 PM
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
Request clarification before answering.
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.
Don't forget to up-vote and accept, if it helped. 🙂
Vijayeta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hi Remzi,
Please mark this question is closed as this will help others looking for an answer.
Regards
Afshin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
53 | |
10 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.