Q&A

Connecting denodo and C# application
answered 20-06-2022 07:55:38 -0400

I have changed the port to 9996 , and used denodo username and password in connection string , and database name is same in both denodo and postgresql . string connectionString = “Server=localhost;Port=9996;Username=admin;Password=admin;Database=test”...

Answers: 1

C#

excel data source
answered 20-06-2022 07:52:05 -0400

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

Excel DataSource

Connection JDBC Denodo AWS Free Trail to MYSQL Database dosent work
answered 20-06-2022 06:19:24 -0400

Hi, i am working with the Denodo Free Trail Version on AWS ( access to Web Design Studio ) and with the Denodo Express Version. The Tutorial https://community.denodo.com/tutorials/browse/basics/1install1denodo i start working with is doing good on ...

Answers: 1

Denodo_MySQL JDBC tutorial free-trial

LISTAGG QUERY SAMPLE
answered 17-06-2022 06:35:04 -0400

Hi, please provide a query sample example to show the function listagg. Currently i am not able to produce syntactically correct query even though i follow the syntax. Also please do not provide the listagg function link in ur community as i already...

Answers: 3

listagg

Reports generations in Denodo Job schedualr
answered 16-06-2022 19:51:50 -0400

Hi team, While generating csv file report via denodo job schedular it generating the header bydeafult in Upper case like "ACCTOUNT NUMBER" ... is there any way to get it generated in lowe case header like" account number." please guide. please let ...

Answers: 1

Column name change in Interface View or Integration View?
answered 16-06-2022 11:10:43 -0400

What is best practice with regards to renaming columns? Should column names be renamed in the Interface layer or Integration layer. My thought is to change column names in the Interface layer only and leave real names in integration view, however, wh...

Answers: 2

How do I connect postgres DB in denodo?
answered 16-06-2022 07:50:42 -0400

How do I connect postgres DB in denodo? Could you please help on this,?

Answers: 1

PostgreSQL

Unable to establish connection: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
answered 15-06-2022 19:01:55 -0400

I am trying to do the tutorial for starters. I work with the denodo free trail on aws and using the design studio https://community.denodo.com/tutorials/browse/basics/2fs5jdbc I installed all what i need to. the sql server is running and java, pyth...

Answers: 1

JDBC

Denodo Scheduler 8 Screen Flow
answered 15-06-2022 08:03:46 -0400

I noticed the Denodo 8 Scheduler does not function like the Denodo 7 Scheduler. When I click on Projects in Denodo Scheduler 7, it displays all the projects. I can then click on a project and it displays the jobs in the selected project and the selecte...

Answers: 1

Denodo Scheduler 8.0

Filtering out duplicate values
answered 14-06-2022 10:56:08 -0400

I am using ITPilot Wrapper Tool to grab clients report numbers, navigate to a URL to get their data (name and email), and input it in a website that then sends them an email requesting them to do a certain task for us. My problem is we have clients wit...

Answers: 1

Wrapper ITPILOT