How can we access a stored procedure and import its result in Elasticube

Comments

1 comment

  • Avatar
    Adam Bender

    Your stored procedure will have to insert records somewhere into a table in SQL Server.  You can't access a stored procedure directly as it is not a set of records, but rather it is an instruction set.

     

    Have your stored procedure insert the records into a table using "insert into" or "select into" (or similar method) and then pull those results into the elasticube from the table.

    0
    Comment actions Permalink

Please sign in to leave a comment.