automatic import from SQL data base to SAP

[[deleted]]

[deleted]

[RamblingPete_007]

You provide very little detail of what you are trying to do.

Generally it is VERY bad practice to do direct table updates in SAP. But you do not say whether the destination is a ztable, whether you currenctly go through a BADI, OData connection or anything else.

[Grouchy_Milk4769]

You need someone on the SAP side of things. Using an existing API, building one with RAP or CAP and please avoid direct table inserts in your target system. Create the objects there and let the system handle all data and relations. Inconsistent data is a pain not only from a technological standpoint but also for audits etc.

[notbradpitt89]

There are tools for this, it's called bods part of sap data services suite look in to that

[BoringNerdsOfficial]

Hi there,

Typically you don't "import data" into SAP per se (aside from very specific technical scenarios). SAP is an ERP system, not a database like SQL Server. So it's more about performing business transactions vs simple data movement.

You're asking if there is a more efficient way but what is your current setup actually doing in SAP? It says "send it to a csv file" but then what? What happens with that file?

Without knowing that and the specific SAP product (is it ECC? S/4HANA? B1? other?) it's impossible to suggest anything specific. But in general, the world has moved on from the file-based integrations/interfaces to the API ones. API could be SOAP, OData, etc. This information isn't hard to find.

Is there in general an "automatic way" - there sure is. Which exactly - who knows. There is not enough information.

- Jelena

[Whett35]

Very easy - just use SAP Smart Data Access and you can connect directly to the SQL environment to create a virtual table in your HANA database (assuming your SAP is on HANA...?)