Home / Q&A / Access to Derived Views from Mysql or Postgres
You can translate the question and the replies:

Access to Derived Views from Mysql or Postgres

I have created some derived views and I need to read the data from those views and process the data and save it in an external database (Mysql, postbres), in a custom table. How you could do that? Or is possible to publish the information that I get from a dereived view in an external database?
external Database MySQL PostgreSQL
user
01-04-2019 08:02:20 -0400

1 Answer

Hi, For your scenario, I would use the Denodo Scheduler to extract the base/derived view output by creating a VDP job and export the results to the external databases such as MySQL/PostgreSQL via a JDBC data source. You can refer [here](https://community.denodo.com/answers/question/details?questionId=9060g0000000AodAAE&title=Scheduler-how+to+load+the+result+of+the+job+into+a+table) for an existing community Q&A that talks about how to load data into an external database using a scheduler job. Hope this helps!
Denodo Team
02-04-2019 08:18:09 -0400
You must sign in to add an answer. If you do not have an account, you can register here