Q&A

Sourec refresh
answered 29-06-2022 15:03:16 -0400

We have created JDBC data source and base views and derived views on top it it. But there has come a need to update the server details and database name for which data source needs to be modified. after modifying the data source and trying to source re...

Answers: 1

Issue with source refresh in base views
answered 29-06-2022 13:21:47 -0400

Hi I had a source which was then updated with the connection details and credentials. After updating the connection details when i am trying to refresh base views i am getting the following error: ERROR WHILE REFRESHING BASE VIEW Unable to load informa...

Answers: 1

Connecting MS SQL Server through Denodo Testing tool throws error.
answered 29-06-2022 07:32:33 -0400

I'm trying to establish a connection to SQL Server using the below properties through config file. mssql.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName...

Answers: 3

SQL Server SQL

Refreshing remote tables using Scheduler
answered 28-06-2022 18:17:06 -0400

Hi Team I want to know that how to refresh remote tables from scheduler. I have tried vdp job option but not able to get the output. Also, how to call stored procedure for create remote table in parameterized query option in scheduler. Thanks

Answers: 1

Scheduler Jobs Remote Tables

Returning data with a max date (minus 1) for weekdays only
answered 28-06-2022 12:59:47 -0400

Hi, How do i amend the following code to execute daily but exclude weekends as the load_date will never have a weekend date. table.load_date = (SELECT addday(max(load_date), -1) AS addday FROM table) This code executes fine, but each Monday it will...

Answers: 1

Table name at the runtime
answered 28-06-2022 12:57:21 -0400

Hi We have requirement to dynamically query a table , whose name is stored in another table.. E.g. View 1 has - Table,Date View01012022, 01/01/2022 View02012022,02/01/2022 View03012022,03/01/2022 First query View1 to get Table name .e.g View01012022...

Answers: 1

Base view issue with MongoDB custom datsource
answered 27-06-2022 11:58:39 -0400

HI Team, I'm using Denodo 7.0. Created a MongoDB connection with custom datasource. Had a requirement to create a base view by selecting few fields from MongoDB collection. suppose collection 'abc' having 10 fields in it and we need to create base vi...

Answers: 3

mongodb

Read only access in Scheduler
answered 24-06-2022 09:55:42 -0400

Hi In Scheduler is it possible to only provide view permission without execute access to users on particular project. The "Read access" current allows user to execute every job in the project Thanks

Answers: 3

privileges Denodo Scheduler 8.0

Split function in Denodo does not work! (second way) Regex for complex string in Denodo
answered 24-06-2022 09:23:14 -0400

I am basically trying to split the following string in Denodo and trying to create new columns in the database for each value. my_string = ABLMNC_154342_O_UW_UA-UCOU_SMC The problem i am facing is when i split the string, Denodo creates an arra...

Answers: 4

Regex Split

scheduler job dependency set without adding cron expression in trigger section.
answered 23-06-2022 11:40:45 -0400

we need to set the job dependecy without adding cron expression in scheduler as the job is going to start with dependency via scheduler api using other tools.

Answers: 1

cron Job scheduler triggers