cancel
Showing results for 
Search instead for 
Did you mean: 

Parameters in SQL Queries when importing data

Former Member
0 Kudos

Hi,

When importing data from a SQL Database (Microsoft SQL for example). Is it possible to pass a SQL Query with parameters, for example pass a date value?, or, is it possiblel to run a stored procedure (and pass parameters as well)?.

Best...

igor_wagner
Explorer
0 Kudos

Hello experts,

I’m trying to figure out the same thing. While importing data into SAC through SQL connection, can I make some selection conditions dynamic? E.g. select “current date”?

Where can I find some examples or information regarding syntax for freehand SQL?

Thanks in advance,

Igor

Former Member
0 Kudos
I saw your posted comment. Please raise your question again as a new question and follow our rules of engagement: https://community.sap.com/resources/rules-of-engagement. The author of the original question is no longer active in the community and won't receive your query. Feel free to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. With these tips you'll be able to prepare questions that draw responses from our members.

Accepted Solutions (1)

Accepted Solutions (1)

JohnL
Product and Topic Expert
Product and Topic Expert

Hi Ricardo,

Only freehand SQL is supported at this time.

See Importing SQL Data to a New or Existing Model

Answers (1)

Answers (1)

jonel_rienton
Participant
0 Kudos

Hi, the answer is "it depends". How are you importing your data from a SQL database?