You can translate the document:

Goal

This document explains how to connect MatLab to Denodo as a data source. MatLab is a licensed software, which combines a desktop environment tuned for iterative analysis and design processes with a programming language that expresses matrix and array mathematics directly. It includes the Live Editor for creating scripts that combine code, output, and formatted text in an executable notebook.

Prerequisite

You must have MatLab Database Explorer App installed with your MatLab distribution.

Setting up a Denodo Data Source in MatLab

  • Start MatLab
  • In the Apps tab click on “Database Explorer”


  • Click on “Configure Data Source
  • Select Configuration JDBC data source

  • Name: <Name>
  • Driver Location: <Path of your Denodo JDBC Driver> <DENODO_HOME>/tools/client-drivers/jdbc/denodo-vdp-jdbcdriver.jar
  • Driver: com.denodo.vdp.jdbc.Driver
  • URL: jdbc:vdb://<denodo_host>:<port>/<database>
  • Login: <Denodo user>
  • Password: *******
  • Click “Test

  • Enter Username & Password

  • Save the data source
  • In Database Explorer click “Connect” > your data source
  • Select the Catalog you want to connect to


Importing Data

Once connected to Denodo in the Database Explorer tool, you can click on “Import Data” and have the choice to:

  • Import the Data
  • Generate an SQL query
  • Generate a MatLab Script

Import Data imports the data in a variable name that you can then use in MatLab.


Generate SQL query creates a SQL file that is saved in your MatLab project.

Generate MatLab Script will generate the appropriate MatLab script using the Denodo data source to load the data in a variable.

Disclaimer
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.

Questions

Ask a question

You must sign in to ask a question. If you do not have an account, you can register here