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 E-mail 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

ERP alternatives poised to take the stage in 2021

The momentum for companies to adopt cloud-first and industry-specific ERP systems has created an opening for alternative ERP ...

IFS Field Service Management software: Overview, pros, cons

IFS FSM software is meant to manage field staff and assets. Learn about its advantages and disadvantages and whether your company...

Salesforce Slack buy biggest step yet outside the CRM realm

Salesforce has tried to buy its way into the rest of the enterprise before. Is Slack the golden ticket that will take it beyond ...

SearchOracle

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 ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

Enterprise data lakes hold the key to actionable insights

Technological pillars of sound business decisions, AI, machine learning and advanced analytics depend on the quantity, quality ...

Data fabrics help data lakes seek the truth

Data fabrics can play a key role in aligning business goals with the integration, governance, reliability and democratization of ...

Kyligence builds out data cloud for OLAP and big data

Kyligence is advancing the Apache Kylin project with a cloud-native offering that can help organizations more efficiently execute...

SearchAWS

Amazon's impact on publishing transforms the book industry

Amazon changed the way we publish, purchase and read books. Publishing experts said they expect more industry disruption to come.

How Amazon and COVID-19 influence 2020 seasonal hiring trends

Retail and logistics companies must adapt their hiring strategies to compete with Amazon and respond to the pandemic's effect on ...

New Amazon grocery stores run on computer vision, apps

Amazon dives deeper into the grocery business with its first 'new concept' grocery store, driven by automation, computer vision ...

SearchBusinessAnalytics

Why using graph analytics for big data is on the rise

Graph analytics is being used across industries for different reasons. Read on to see how they can improve organizational ...

Data governance framework key to analytics success

Successful data-driven decision-making relies on good data at its core, and it's a strong governance plan that ensures the ...

Looker, Google planning plenty of analytics collaborations

While collaboration with its parent company is prominent in Looker's plans, so are investments in analytics capabilities ...

SearchContentManagement

Best enterprise content management software of 2021

When it comes to ECM, there are myriad vendors to choose from. Delve into 10 tools on the market to understand their capabilities...

What is the future of ECM?

ECM isn't dead; it has evolved from a technology into an approach. Learn about the history of the ECM and look forward into the ...

5 steps to a successful ECM implementation

Implementing an ECM system is a major undertaking. Check out these steps to get on the right track before you jump into the ...

SearchHRSoftware

Diversity, equity and inclusion are hot, but tools need vetting

The diversity, equity and inclusion tools market is going mainstream, giving HR buyers more options than ever before. But due ...

Biden revokes Trump's contested DEI training order

President Joe Biden has revoked an executive order from former President Donald Trump that discouraged federal agencies and ...

How HR can help promote a caring culture

HR's role has become increasingly strategic and part of that requires focusing on truly supporting employees. Here's some advice ...

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