Execute SQL Command Plugin
Elasticube.Plugin.ExecuteSqlCommand.dll (plugin DLL)
Elasticube.Plugin.ExecuteSqlCommand.zip (source code)
Introduction
This plugin allows you to run a command against a SQL database before or after an ElastiCube build. This is useful for invoking ETL routines in a SQL data warehouse that extract and transform data to prepare it for loading into Sisense.
Installation Steps
- Copy the DLL to “%ProgramFiles%\Sisense\Prism\Server\Plugins”. (Create the “Plugins” folder if it doesn’t exist.)
- Ensure the DLL can run by opening its file properties and clicking the “Unblock” button from the “General” tab of file properties, if it exists.
- Restart ElastiCubeManagementService using services.msc to ensure the DLL is loaded by Sisense.
Configuration Steps
- Open ElastiCube Manager
- Open the “Pre & Post Execution Plugins” dialog from the “ElasiCube” menu
- Add a plugin and name it “ExecuteSqlCommand”
- Configure arguments for the plugin like this: <Attributes connectionString="Server=X;Database=X;User ID=X;Password=X;" commandText="exec [dbo].[ExtractAndTransform]" commandTimeout="300" />
Plugin Arguments
- connectionString
- commandText
- commandTimeout - Optional, defaults to 30, units in seconds.
- providerName - Optional, defaults to “System.Data.SqlClient”, options include “System.Data.Odbc”, “System.Data.OracleClient”, and others.
~-~
-
Hi Bobbie, you can find more information on Elasticube plugins here: https://developer.sisense.com/display/API2/ElastiCube+Plugins
-
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
-
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
-
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
-
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
Please sign in to leave a comment.
Comments
10 comments