Skip to content
+1-888-319-3663

COMMUNITY FORUM

Stored procedure as a data SOURCE

bushman4 asked 9 years ago
Anyone have any advice on how to get SmartConnect to use a Stored Procedure as a data source?  This would be from a SQL 2008 R2 server.

Thanks in advance.

Glenn
Answers
Best Answer
Ruaan Jonker answered 9 years ago
Hi Glen

You will create a Bulk Data Source "ODBC connection".
Once you have the connection setup you can write normal SQL code in the Query Field.

Declare @field1 char(255)
set @field1 = 'AARONFIT0001'
exec RUAAN_TEST  @field1

Regards,
Ruaan

If you would like to submit an answer or comment, please sign in to the eOne portal.