cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
From the Desktop ElastiCube Manager you can call a SQL Server Stored Procedure (with or without parameters)
 
Step One:
Configure for ad hoc distributed queries on the SQL Server Instance
exec sp_configure 'show advanced options', 1;

RECONFIGURE;

exec sp_configure 'Ad Hoc Distributed Queries', 1;

RECONFIGURE;

GO
Step Two:
 
Include a Linked Server to itself
EXEC sp_addlinkedserver @server=’localhost’, @srvproduct=’SQL Server’;

EXEC sp_addlinkedsrvlogin

@rmtsrvname=’localhost’,

@useself=’FALSE’,

@rmtuser = ‘admin’,

@rmtpassword = ‘admin’;
Step Three:
 
Enable remote connections and SQL browser
 
 
 
Now you should be able to use an OPENQUERY in the ElastiCube - for instance, I tested this against the AdventureWorks database...
 
SELECT * FROM OPENQUERY

(localhost,'SET FMTONLY OFF; exec [AdventureWorks2014].[dbo].[uspGetEmployeeManagers] "3";')
Version history
Last update:
‎03-02-2023 08:45 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email community@sisense.com