Latest Activity

code

role privileges for data movement

I'm trying to use a datasource (JDBC connection to Teradata) that has data movement enabled, currently in a Denodo database where all our datasources are kept (Admin). I have a user that is in a role that has connect/metadata/execute privleges grante...

Data Movement

code

Data Movement Temporary Tables not deleting from SQL Server data source

I have configured one of my views to use Data Movement and create temporary tables on one of my SQL Data Sources (using jdbc drivers). The view executes correctly, but the tables created on the data source are not being cleaned up after the view compl...

Data Movement

code

How does Data Movement work dynamically?

My question is regarding data movement without using the CONTEXT (DATAMOVEMENT) clause. I've been working with data movement to improve performance in a query using a view with a large amount of data joined to a view with a much smaller amount of data...

Data Movement

code

Data Movement & Cache

Hi , I have Denodo version 7.0.20181011. I have problems with the data movement and with the cache. once the cache is enabled on a DV everything runs correctly but the record is not in a validated state? how come? I also wanted to know if with the da...

Data Movement Cache

code

Data Movement

Hi, what is the difference between data movement to source vs data movement to view ? I found that my execution time reduced in case of data movement to view. Is it situational or is it always more performance efficient compared to data movement to ...

Data Movement

code

Error handling for Data Movement failure

Good Morning Team, I'm working on a project where we had to enable data movement for optimizing the performance. There are times, the data movement is failing for some reason. The issue is that the front-end users do not have an idea if the data movem...

Data Movement Error Handling Data Movement Failure

code

Error with data movements using Excel files

Hello, I have a Derived View which contains multiple joins to other Derived and Base Views. The Base Views are sourced from individual Excel files. The Derived Views are derivations and joins on those Excel files. I wanted to turn on the Data Movement...

Data Movement

code

PostgreSQL Data Movement Error

At present, I’m consuming data from a PostgresDB and looking to write to another PostgresDB using the below statement, however it returns an error stating the ‘Virtual Data Port does not support data movements to data source’ and lists a number of supp...

Data Destination Data Source PostgreSQL Data Movement