Best way to import/export data between an SQL server and SAP

What is the best way to import/export data between an SQL server and SAP?

Matthew Billingham

Published: 23 May 2002

What is the best way to import/export data between an SQL server and SAP?

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate Email Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

You can use EXEC SQL to issue SQL to the SQL server. Once you have read the data, you can bring it into SAP using BAPIs, IDOCs or BDC. For Oracle databases, SAP suggest the procedure outline in OSS note 25383 - Database links, synonyms, remote DB.

Dig Deeper on SAP ABAP

Related Q&A from Matthew Billingham

Getting data to show in an SAP ALV Grid

An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading

Transferring data to new sales orders in SAP VA01

An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading

How to write an SAP ABAP program to read source code and create a new SAP ABAP function module

A SearchSAP.com reader wants to know if it's possible to write an SAP ABAP program that will read source code and then create an SAP ABAP function ... Continue Reading

SearchERP

Top 8 warehouse management systems to research

Efficient warehouses are key to customer satisfaction. Learn about some of the top warehouse management systems, including some ...

Overview of 4 types of warehouse management systems

Modern companies need to create efficient warehouses, and understanding which type of warehouse system to choose is key to that. ...

AI adoption in the supply chain requires a strategic approach

AI's future in the supply chain seems assured as the pandemic accelerates AI adoption in various industries. Here's why some ...

SearchOracle

Supreme Court sides with Google in Oracle API copyright suit

The Supreme Court ruled 6-2 that Java APIs used in Android phones are not subject to American copyright law, ending a ...

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

SearchDataManagement

Oracle brings GoldenGate data integration service to cloud

Oracle is making its GoldenGate real time data technology available on its second-generation Oracle Cloud Infrastructure platform...

Era Software raises $15.25M for enterprise data management

The startup that began as the EraDB time series database is advancing its efforts with new funding and a cloud service for its ...

Dgraph GraphQL database users detail graph use cases

Graph DB vendor Dgraph Labs is expanding its AWS cloud footprint with new regions and adding change data capture capabilities in ...

SearchAWS

Experts raise privacy concerns over Amazon fleet surveillance

Amazon said its van monitoring system is designed solely for driver safety. But many industry experts have concerns regarding the...

Here's why Amazon's global expansion won't come easy

Amazon would like to strengthen its global footprint, but the e-commerce giant faces roadblocks and challenges today that did not...

How Amazon became a force in SMB lending

Amazon has upped its game with small business lending and credit options for its top merchants, showing more willingness to ...

SearchBusinessAnalytics

TigerGraph unveils support for GCP, adds new connectors

Graph database vendor TigerGraph unveiled support for Google Cloud and new connectors to Snowflake and Tableau on April 21 during...

Startup Veezoo emerges from stealth with NLQ-based platform

Aiming to be 'Siri for enterprises,' an analytics startup emerged from stealth with a platform that enables users to interact ...

15 data science tools to consider using in 2021

Numerous tools are available for data science applications. Read about 15, including their features, capabilities and uses, to ...

SearchContentManagement

Hyland gets digital asset management tech with Nuxeo buy

By acquiring a smaller competitor's digital asset management platform, Hyland looks to build on its 2020 purchase of Alfresco, ...

OpenText releases Cloud Editions content services updates

OpenText CE 21.2 includes federated document compliance that extends to Microsoft Office 365, along with a revamped content ...

Adobe courts small businesses with Acrobat Pro package

As the pandemic disrupts paper workflows, Adobe courts small business users with simple webforms, digital signatures and payments...

SearchHRSoftware

Shift to HR shared services could save Connecticut millions

By consolidating 17 separate HR operations into one shared service, Connecticut expects to save significantly on costs, most of ...

10 steps to support your HCM system post go-live

To ensure a new system's success, HR leaders need to develop a plan for how they will support their new HCM system post go-live. ...

Face mask detection a newcomer to employee surveillance

Face mask detection has emerged as another form of employee surveillance technology, and its adoption may be helped indirectly by...

Hasso Plattner discusses the state of the SAP HANA database

Overview of SAP HANA features and how it's being used today

ABAP (Advanced Business Application Programming)

Rubrik backup focus moves to enterprise apps