JDBC Extraction Section

The databases containing the required data will be accessed using the JDBC standard (Java Database Connectivity). Appendix JDBC Drivers lists the JDBC drivers included and/or normally used by Denodo Scheduler. It is also possible to easily incorporate other JDBC drivers into the system (see section Drivers).

The JDBC job extraction section is configured in the same way as the VDP jobs (see section VDP Extraction Section). The only difference is that, instead of selecting a VDP data source, you have to select a JDBC data source, and instead of specifying a parameterized statement in VQL language, it has to be specified in SQL.