Q&A BY TAG 'DataSource'

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

List of All DataSource
answered 26-01-2023 06:50:38 -0500

Hi team, I am using Denodo 8.0 version where I want to see details of all the DataSource created in my server.For which I tried this option 'DESC DATASOURCE <datasource_type> <datasource_name>‘, but in this I have to give one datasource na...

Answers: 2

DataSource

REST Webservice as DataSource with optional parameters
answered 28-09-2022 08:31:00 -0400

I am using a REST Webservice as a Datasource. To get the data, the Webservice GET function takes three Parameters "accountingClientId", "customerId" and "invoiceId". The first two are mandatory, the third is optional. I managed to do this by using ^Exe...

Answers: 1

REST Parameter REST Webservice JSON Datasource DataSource

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 Excel OneDrive 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