Q&A BY TAG 'datasource'

You must sign in to ask a question. If you do not have an account, you can register here

excel data source
answered 20-06-2022 07:52:05 -0400

Is there any way to create a excel data source of the file stored in the local system of the user not in the local system of virtual dataport server? or is there any way to move the file from local system to local system of virtual dataport server?

Answers: 1

Excel DataSource

GET_JDBC_DATASOURCE_TABLES equivalent to get Stored Procedures
answered 10-06-2022 16:57:56 -0400

We automated our base view creation from a SQL Server using Denodo GET_JDBC_DATASOURCETABLES stored procedure. Unfortunatly, this process ignores the few SQL Server custom stored procedures that we would also like to import in Denodo. Is there a way ar...

Answers: 1

Stored Procedures DataSource

Getting Source Tables and Columns of a Datasource through Query
answered 17-11-2021 01:37:07 -0500

Hi Denodo team, Are there any queries to get all the tables in the datasource and also columns in a datasource for a specified table. I have seen that GET_SOURCE_TABLE() procedure is giving table but it takes view name as a parameter,but I don't want t...

Answers: 5

JDBC query Database JDBC DataSource

Getting the Source Tables and columns for non-JDBC datasources
answered 08-06-2021 09:36:53 -0400

Hi Denodo Team, For the views created from JDBC datasource in denodo I am able to get the source tables by using the default procedure GET_SOURCE_TABLES(). But when I use the same procedure to get the underlying source table information for the datasou...

Answers: 1

source tables SAP CSV Denodo8 JDBC Data Sources source columns DataSource underlying tables

How to delegate full join to Dremio source
answered 01-09-2020 08:06:38 -0400

Hi Team, I have 2 views which from same Dremio datasource. and these 2 views is FULL OUTER Join. But the full out join can't delegate to dremio. could you please help this case? Test1, inner join can deletgate, but outer join not; Test2, change the so...

Answers: 1

VDP 7.0 DataSource

Sharepoint/OneDrive directory access to get CSV or Excel Files
answered 18-06-2020 06:58:01 -0400

Hello Denodo! We've been trying to get all the instructions in the following links to work with no success: https://community.denodo.com/answers/question/details?questionId=9060g000000Xf4oAAC&title=OneDrive+Connetion https://community.denodo...

Answers: 4

Datasource OneDrive Excel CSV Sharepoint

Can Denodo connect to Azure SSAS?
answered 09-06-2020 08:07:57 -0400

Can Denodo connect to Azure SSAS? If yes, Do we have in-built drivers for the same or need any external drivers? Is there any documentation on steps to connect Denodo to Azure SSAS?

Answers: 1

Azure SSAS DataSource

Creating a Multidimentional Datasource | SQL Server analysis Services
answered 13-05-2020 02:16:57 -0400

Hello, We have created a Multidimentional Datasource of SQL Server analysis Services. I have followed the Denodo article - https://community.denodo.com/kb/view/document/SSAS%20as%20data%20source?category=Data+Sources (have also followed all the Previ...

Answers: 5

Multidimensional Data Source Denodo_SQL_Server DataSource

OpenOffice Data Source Classeur ODS SXC
answered 06-05-2020 08:01:30 -0400

Hello, Can DENODO connect to a DataSource of OpenOffice likeCalc File with extension ODS or SXC ? tnx

Answers: 1

OpenOffice Classeur ODS DataSource

Custom Driver stored procedure's not listed
answered 22-04-2020 17:30:01 -0400

Hi, I am writing a Generic JDBC driver to load inside denodo. The driver loads fine but I dont see my stored procedures returned by DatabaseMetaData. They do show up in my other DB tools like dbever. Any insight is really appreciated. Thanks Anish

Answers: 1

driver datasource procedure