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
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...
Answers:
5
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 ...
Answers:
1
Hi , i have aan excel as a source file which would be uaed in Denodo.The data is a cube. please help to find a way out to load the data in Denodo through this file. Thanks & regards, sajeda
Answers:
1
Hello Team, When we try to create a Excel datasource from Sharepoint using OAuth2.0 with Authorization grant as Authorization code we are able to generate the code and create the datasource but it is not feasible process as we have to open the Authori...
Answers:
1
Hello I have a file excel present on the same machine where denodo is installed. I need to import it to be able to query it via denodo. I tried to create a new excel datasource via FTP / SFTP / FTPS Path but I don't risk it as it doesn't recognize the ...
Answers:
2
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
Hi, I need some help trying to connect to a remote Excel file as a data source. I have two servers (A & B), server A has Denodo Express installed on it, how, do I go about connecting to a Excel file on Server B? Using the FTP or HTTP options does...
Answers:
6
All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo. <Error Description when retrieving data from De...
Answers:
1
Hii, I have a question related to Excel data dource wherein I am trying to create a scenario where I have multiple sheets in one single excel..say demo1.xsls. When I tick (a) Extract Sheet name as column name (b) extract data from all sheets. Then...
Answers:
1