Q&A BY TAG 'Data sources'

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

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

Denodo Testing Tool Database Data sources

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

data sources sftp

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

data sources

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

data sources Stored Procedures connection

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

scheduler data sources

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

data sources Web Service

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

data sources

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

data sources

Relative Driver Class Path for new data sources
answered 10-04-2015 03:44:06 -0400

Dear Denodo, Can we put a relative path in the "Driver Class Path" field when creating data sources? If so, what is the root of the relative path? Is it $DENODO_HOME? (so I could put a driver in $DENODO_HOME/extensions/thirdparty/lib/my_special_fol...

Answers: 1

data sources classpath

Base View schema doesn't get updated automatically if the payload changes
answered 19-02-2015 09:26:13 -0500

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: 1

data sources view