Q&A BY TAG 'DATA SOURCES'
Base View schema doesn't get updated automatically if the payload changes
answered
23-06-2022 10:09:14 -0400
Hello, With the JSON data source, if I have a base view created initially; which is created by Denodo based on the JSON response payload it receives at the time of view creation, the schema of the created view is decided at this point. Now in future,...
Answers:
4
Error in Data source creation in ADLS 2 container
answered
15-07-2021 05:27:29 -0400
Hi, I am trying to establish a connection to read and write back a csv file ADLS 2.0 container. I am trying in custom wrapper so I configured my core-site.xml with my ADLS account with keys. When I try to test connection the connection is succes...
Answers:
2
CSV Create Base View Data sources Azure Data Lake Storage Gen2
Query two data sources(May be sql server and DB2 ) using Denodo Testing tool.
answered
13-11-2019 13:04:34 -0500
Is it possible to query two different data sources Can i join them in one query and get output? without help of linked server how can i query two different data sources and get single output. Eg Sql and DB2 or salesforces Thank you for help!
Answers:
1
What is the right URL when configuring an SFTP (or FTPS) data route?
answered
29-10-2018 21:25:25 -0400
Hi! I'm trying to access a delimited file on a different server using SFTP, but I can't seem to get the URL right. What is the right URL when accessing files on other servers via: SFTP FTPS SSH Thank you~!
Answers:
8
Best Practice - data sources
answered
27-01-2017 08:25:47 -0500
What is best practice when creating data sources? We have a SQL server back-end with multiple databases that we may want to join across. Initially I set up data sources for each database but Denodo didn't recognize that fact that all the data sources p...
Answers:
2
Use Custom Stored Procedure to connect to a VDP Data Source
answered
06-07-2016 07:05:02 -0400
Hi, Is it possible to write a custom stored procedure in java, that uses the connection of one of the VDP data sources? For example, have the java stored procedure run a query on an object that doesnt exist as a base view in Denodo? Thanks!
Answers:
1
Scheduler job to automate the metadata testing process
answered
10-05-2016 11:44:17 -0400
Hi, I am trying to create a scheduler job to automate the metadata testing between two views which are in different databases. Now that, I created 4 different scheduler job for 4 different environment(dev,SIT,UAT and PROD). Each job has one parameteriz...
Answers:
1
How to rename a data source?
answered
11-04-2016 04:54:48 -0400
How do I rename a web service data source in VDP 5.5? I created one with a wrong name, built some views on top of it, and I see no way to go back and change the name. It seems like the same is true of jdbc sources. Is the only option to recreate every...
Answers:
1
How to map Source and destination data source fields using Job scheduler
answered
08-04-2016 08:05:14 -0400
I want to push the data from oracle database to Active directory using Denodo Job, I now these two databases are different, but I would like to map Oracle columns to LDAP attributes while syncing the database and would like to schedule this job on Deno...
Answers:
1
How to load PDF
answered
27-05-2015 05:56:48 -0400
Hi Team, Please direct us on steps how we can load data from PDF's using denodo.
Answers:
1