+1-888-319-3663

COMMUNITY FORUM

Stored procedure as a data SOURCE

bushman4 asked 10 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

0 Vote Up Vote Down

Best Answer

Ruaan Jonker answered 10 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.