How to link Essbase in SQL Server 2014

I need to join SQL Server data with some data from Essbase cube. Result will be in SQL Server. Is it possible to create linked essbase cubu in SQL Server 2014 to query data? Or any other way how to get data physically from essbase to SQL Server not using export files? Something like direct connect.

Thanks,

Solution

There aren't any native ways to implement what your want. Setting this up will typically require some sort of automation to extract the data in the cube to a CSV file, then loading that data using SSIS or your preferred ETL tool. The automation to extract data will frequently be a combination of batch file, MaxL and report script or a calc script with a data export command.

Audit table update trigger does not work using a stored procedure
Entity Framework | Sequence contains more than one matching element
How can I alter column name in Sql server
How to partition into batch of records with max batch size limit
LOAD DATA INFILE error in MySQL
Cannot perform an aggregate function on an expression containing an aggregate or a subquery with STRING_AGG
Perform a row count of each table in my list of tables
Entity Framework Core 3.1.6 Item With Same Key Has Already Been Added
Split a string with no delimiters into columns
Each GROUP BY expression must contain at least one column that is not an outer reference
Add custom columns to pivot table
Parameterized raw sql query much slower than query with actual values
SQL Server database backup restore on lower version
Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions
How can I create a unique constraint on my column (SQL Server 2008 R2)?
Summation of a column using certain conditions
Natural join in SQL Server
How to concatenate text from multiple rows into a single text string in SQL Server
How to Renumber Set/Subset of Table Based on Numbering of A Second Table
Using Azure Devops deploy release to multiple repos
SQL Server Cursor vs WHILE loop
SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
SQL-How to Insert Row Without Auto incrementing a ID Column?
Why can't I use an alias in a DELETE statement?
Can ransomware encrypt a mounted SQL database? Hypothetical
Grant user DDL permissions on specific schema
How do I perform a GROUP BY on an aliased column in SQL Server?
Collecting data from a joined table based on condition(s) in the joined table
Stored procedure for auto generating roll no?