Q&A BY TAG 'Data Source'

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

Error saving datasource: SourceTypes (arn, custom, df, gs, itp, jdbc, json, odbc, ws, xml, excel, saperp, sapbw, olap, essbase, sapbwbapi, salesforce) are limited to 0 but 1 are found
answered 08-09-2021 15:03:03 -0400

Hello denodo developers, while creating a jdbc data source I came across this error. I can test the connection successfully but when I want to save it this error pops up. I am using the SOL license.

Answers: 2

Data Source JDBC DENODO EVALUATION LICENSE Connecting to remote databases

Excel Data Source: Is it possible to create a view on a directory containing the excel files?
answered 22-06-2021 10:21:15 -0400

Is it possible to create an excel data source based on a directory of files versus an individual file? If so, how would you configure this?

Answers: 3

Excel Data Source Mulitple Files

REST service data source for large amount of data
answered 29-01-2021 04:31:48 -0500

I have a REST service data source containing a few million product items. How are VSQL query parameters such as ItemId converted to the query parameter on that source REST service? Does Denodo have to pull all 3 million items and then filter the resul...

Answers: 3

REST Data Source

Data Source creation in Denodo 7.0
answered 25-11-2020 05:35:09 -0500

Hi Team, I am getting error while saving the data source created for MYSQL using Denodo 7.0. I am able to connect with data source successfully. But when I am saving the data Source a window popup with ysntax error message saying "Syntax error: Unknow...

Answers: 2

MYSQL Data Source

Refresh the Data Source completely
answered 18-06-2020 08:07:59 -0400

Can I Refresh the Data Source completely not base view by base view if I altered the schema at the source?

Answers: 1

Data Source Source refresh

Oracle Set Role
answered 17-06-2020 02:26:20 -0400

Is there a way to have Denodo set the role for the user connecting to an Oracle database through a Denodo view? e.g. "set role <role_name>"

Answers: 1

Data Source Access to Oralce JDBC

Adding a data source
answered 21-11-2019 05:37:54 -0500

I am following along the Denodo tutorial but have encountered issues when attempting to add a new data source. I followed the download instructions but they are not very clear so i am obviously missing something. I am from a non-technical background so...

Answers: 2

Tutorial Data Source

Data source connection change history
answered 11-11-2019 18:18:21 -0500

Hi Team, Denodo 6.0 | JDBC Data Sources If data source URI is changed, in which file is this information logged ? Can this file be read in Denodo, and possibly to trigger an alert when data source connection is updated. Does the file has histo...

Answers: 1

data source

How to use Microsoft SQL Server 2016 (MS Driver) to connect to SQL Server with Windows Authentication (not SQL Server Authentication)
answered 12-06-2019 12:04:53 -0400

I am unable to configure SQL Server as a Data Source using the "Microsoft SQL Server 2016 (MS Driver)" as the Database Adapater where the user is a Windows Authenticated user (i.e., not a SQL Server Authenticated user) but without having to setup Kerbe...

Answers: 2

Data Source SQL Server MS Driver

Can Denodo use Email as a Data Source?
answered 28-03-2019 11:52:55 -0400

Hi, I would like to know if it is possible to use an email as a data source? Thanks in advance for your help. Best Regards,

Answers: 1

Data Source email