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?

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.

This was last published in May 2002

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

Changing all SAP user account passwords from one location

An SAP user needs information on how to change the password on several SAP user accounts from a central location. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

SearchERP

Workday to acquire Adaptive Insights for $1.55 billion

Workday says its acquisition of Adaptive Insights, a financial planning and modeling system, will save it two years of ...

Oracle claims it can cut ERP system migration costs by 30%

A migration can cost millions, but Oracle believes its new automation and integration tools can significantly reduce the cost of ...

Key enterprise accounting software features and benefits

To find the best enterprise accounting software, businesses must outline specific criteria and compare those criteria against ...

SearchOracle

AI-for-IT-operations tools map Vegas systems to Oracle ERP

Mapping IoT activity and other IT data to Oracle ERP is the task Las Vegas set for FixStream's AIOps platform in an effort to ...

Oracle 18c features give DBAs incremental database capabilities

Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but ...

Cloud workloads see gradual uptake, but miles to go for databases

A picture of steady but not rapid migration to the cloud by Oracle users emerged at Collaborate 18, with database vets saying ...

SearchDataManagement

Hortonworks cloud options grow via Google, Microsoft, IBM

Hortonworks now supports Google Cloud Storage and has also broadened cloud deals with Microsoft and IBM, aiming to increase cloud...

Evolving data integration strategies target new analytics needs

Most companies don't have a shortage of data, but it's often stored in siloed systems or inconsistent formats -- problems that ...

What goes into a customer analytics data integration framework

Customer data integration is a minefield for IT teams to navigate. But incorporating a set of core technical functions into an ...

SearchAWS

AWS termination protection acts as resource safety belt

In the push to get applications to production quickly, mistakes can happen. But you can avoid potentially disastrous AWS resource...

How AWS Fargate reduces container management burdens

Enterprises face a number of management challenges when they adopt containers. While AWS Fargate eliminates some of these hurdles...

Pave a lasting AWS career path

While cloud certifications might help you land an AWS job, most employers look for IT pros with a mix of training and hands-on ...

SearchBusinessAnalytics

Data-driven strategy grooms dog care franchise for growth

Camp Bow Wow is growing its day care and boarding business for dogs with the help of a data-driven approach that's powered by a ...

Tableau acquisition of MIT AI startup aims at smarter BI software

Tableau acquires AI startup Empirical Systems in a plan to provide users with automated data modeling capabilities and enable ...

Choosing the right data discovery platform for the enterprise

Obviously, cost and scalability factor into data discovery platform buying decisions, but other features, like visualizations and...

SearchCRM

Data migration software coming for SAP CRM

At Sapphire Now, SAP unveiled C/4HANA, a suite of applications that brings together ERP and CRM. To make it easier to switch, ...

Separating customer service chatbot hype from reality

Vendors claim consumers want self-service chatbots. Turns out they'd rather scrub toilets or go to the dentist than converse with...

Tips and tricks for interacting with customers on social media

To customers, all channels are equal: phone, email, voice, video, chat, text messaging and social media. But managing social ...

SearchContentManagement

Cloud DAM platforms vs. on premises for digital asset management

Learn about digital asset management and how cloud DAM democratizes media management and delivery across the enterprise while ...

Box workflow gets upgrade with Progressly purchase

Box is hoping to upgrade its workflow capabilities by adding the startup Progressly to its team, while also still partnering with...

ECM gets a show of support from Zendesk Guide Enterprise

Guide Enterprise captures insights and curates knowledge bases for customer service representatives and customers while helping ...

SearchHRSoftware

AI can reduce workplace bias, says CEO of leading HR group

AI technology may help HR reduce workplace bias, according to Johnny Taylor, president and CEO of the Society for Human Resource ...

How to create an effective employee retention plan

The unemployment rate is low, and your workers are likely being courted by other companies. Here's how to create retention ...

Recruiting with social media: Tips, tools and challenges

Using social media in your company's recruiting efforts can help you find hidden talent pools and both active and passive ...

Join the conversation

1 comment

Send me notifications when other members comment.

Oldest

[-]

tfpearce - 21 Oct 2016 12:51 PM

This is a pretty generic reply...

I am interested in using MS SQL Server, to pass data back to SAP via a WebService that exposes/calls specific rfc/bapi functions.

What does the SQL config look like? How do I pass UserID and PWD? or is there another way.

What specifics/special settings are needed on the SAP webservice side?

Related Resources

Dig Deeper on SAP ABAP

Related Q&A from Matthew Billingham

Have a question for an expert?

Join the conversation

1 comment

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.