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

Error in Data source creation in ADLS 2 container
answered 13-12-2020 19:08:21 -0500

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

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

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