Latest Activity

code

Excel Datasource (Macro-enabled spreadsheet

Hi Team, one question, is it possible to add a .xlsm datasource. BR

Excel DataSource

code

Excel Data Source: Is it possible to create a view on a directory containing the excel files?

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?

Excel Data Source Mulitple Files

code

auto create base_view , auto union them

As I'm french speaking with I bad english, I write in french and include an english translation (by GGTranslate). Voici le scénario que je voudrais mettre en oeuvre. Partie 1 Je veux réaliser une union view qui reprend ce qui se trouve dans des base...

Automation Excel Sharepoint list Base View configuration UNION

code

Error creating share point excel data source connection

Getting the following error while creating a sharepoint excel data source connection in Denodo. Authentication is using OAuth 2.0 "Error while executing custom wrapper method 'getSchemaParameters': Cannot establish the connection"

Excel Data Source SharePoint

code

changing values and formats after saving denodo results to excel

Hi , I m trying to save the results from denodo to a csv or excel file . The problem is after saving the results to excel the format of certain values is changing . Like for example date in denodo results is of the format yyyy-mm-dd but when we save th...

Excel

code

Denodo 8.0 Update 8.0u20220815

We have upgraded to Denodo 8.0 Update 8.0u20220815 Wed design studio we could see "S3" listing under Data Route option while I am trying to add datasource as "excel" But the same is not listing on Virtual Dataport Administration Tool Thanks

S3 Excel excel data source

code

Automation of Metadata

Hi Is there a script that automates the reading of metadata into denodo VDP and not the catalog since all the data sources are from excel? Like the data type and the field description without having to copy and paste from the excel metadata file?

Excel Metadata

code

excel data source

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?

Excel DataSource

code

Excel text field is defined as double in base view

I am using Denodo 8.0. I have an Excel spreadsheet data source which contains multiple worksheets. I have created the data source for each worksheet. All of the data columns are defined as General or Text on the Excel spreadsheet. But when I create the...

Excel

code

Join Views with fields that have similar data, but not identical

Hello, I'm new to the Deonodo coummunity. I'm currently working on a poc using two Exel datasources I've created and built views on top of. I am trying to join two of these views together based on a field that contains a calendar quarter. In one field ...

Excel join