Execute SQL Command Plugin

Comments

10 comments

  • Avatar
    Ramon Lopez

    very cool! This would be useful in the case where you have a stored procedure that is populating another table - and you would like to load that other table into the elasticube during the build.

    Thanks for bringing it to the table!! looking forward to more Mitch!

    0
    Comment actions Permalink
  • Avatar
    Bobbie Peterson

    I've never done a pre plugin for an Elasticube. Could you please provide more through instructions? What an I supposed to do with the zip file attached?

    0
    Comment actions Permalink
  • Avatar
    Oxana Noa Umansky

    Hi Bobbie, you can find more information on Elasticube plugins here: https://developer.sisense.com/display/API2/ElastiCube+Plugins

    0
    Comment actions Permalink
  • Avatar
    sean o'farrell

    Hi Oxana 

     

    2 things - link above prodices 404 error.

    Second question. Is there a return code expected from SP or is there another mechnism that will ensure that cube BUILD does NOT start before the SP finished execution ? We have a fairly complex rebuild SP that prepares tables for reporting that may take as long as 30 mins to execute.

     

    Thanx

     

    0
    Comment actions Permalink
  • Avatar
    Oxana Noa Umansky

    Hi Sean,

    The URL appears to be wrong. The page is here: https://developer.sisense.com/display/API2/ElastiCube+Plugins

    @Mitch might be more suited to help you with the second question, as he is the one who developed this plugin :)

    Thanks,

    Oxana

    0
    Comment actions Permalink
  • Avatar
    Mitch Galehouse

    The cube build is terminated and failed immediately when a SQL error of an severity level is raised.

    0
    Comment actions Permalink
  • Avatar
    Simon Tuson

    I am running into an issue where the elasticube manager report an error at build time in the pre-plugin phase.

    Plugin Execution Failed: Plugin Name: ExecuteSqlCommand keyword not supported" 'database'

    My Pre Execute Plugin parameters are as follows

    <Attributes connectionString="server=xxxxx.com;database=xxxx;User ID=xxxx;Password=xxxx;" commandText="Exec pimviewapipck.setviewcontext('Global', 'Main')" commandTimeout="300" providerName="System.Data.OracleClient" />

    Any thoughts?

    Version: 7.3.0.10434

    0
    Comment actions Permalink
  • Avatar
    Simon Tuson (Edited )

    Any idea why my post yesterday is pending approval?

    I am running into an issue where the elasticube manager report an error at build time in the pre-plugin phase.

    Plugin Execution Failed: Plugin Name: ExecuteSqlCommand keyword not supported" 'database'

    My Pre Execute Plugin parameters are as follows

    <Attributes connectionString="server=abc.com;database=abc;User ID=abc;Password=abcd;" commandText="Exec pimviewapipck.setviewcontext('Global', 'Main')" commandTimeout="300" providerName="System.Data.OracleClient" />

    Any thoughts?

    Version: 7.3.0.10434

    1
    Comment actions Permalink
  • Avatar
    Katie Garrison

    Hi Simon, I just approved your post. It was inadvertently flagged for approval as the comment included 'xxx'.
    You should see it now.

    Katie Garrison | Technical Solutions Consultant

    0
    Comment actions Permalink
  • Avatar
    Laurence Henderson

    Has anyone been able to get a common sql stored procedure to return data into a cube as if its a table?

    0
    Comment actions Permalink

Please sign in to leave a comment.