Hudi

Import records using stored procedure

Discussion created by Hudi on Oct 29, 2012
Latest reply on Oct 30, 2012 by gdurniak

Is there a way to import records into FM by passing the SQL server a stored procedure?

 

exec...bunch of parameters

I tried to paste the stored procedure command with the parameters into the query builder so that it will return the data set that the stored procedure creates.

The dba does not want me importing directly from the tables and would rather have me use this method.

 

Anyone have any experince with this issue?

 

Thanks

 

Outcomes