Accessing Data Directly from Databases and Data Servers

From a single environment, MathWorks data acquisition products let you connect directly to:

  • ODBC-compliant databases to analyze historical data
  • Financial data servers to access live and historical market data
  • OPC or OPC UA servers to access live and historical industrial plant data

Direct access to these data sources also enables automation of repetitive tasks.

Exchange Data between MATLAB and Databases Without Knowing SQL

Analyze information stored in ODBC- and JDBC-compliant databases using MATLAB and database connectivity tools. You can access and write data from and to popular databases such as Oracle®, Sybase®, Microsoft® SQL Server™, and Informix® using Structured Query Language (SQL) commands. If you are not familiar with SQL, you can interact with a database using the built-in Visual Query Builder.

Access Live and Historical Financial Market Data

Financial professionals building computational finance applications in MATLAB can use MathWorks data feed connectivity tools to access data directly from financial data service providers. This connection enables access to live and historical market data for use in complex financial and analytical models. You can use graphical interfaces to open a connection, specify search parameters, and retrieve data for visualization and analysis in MATLAB without writing code.

Read and Write OPC Data Directly from OPC Servers and Data Historians

When working with devices that conform to the OPC Foundation Data Access standard, such as distributed control systems, supervisory control and data acquisition systems, and programmable logic controllers, Industrial Communication Toolbox™ lets you exchange data with an OPC or OPC UA server. You can also read and analyze data from any data historian that conforms to the OPC Foundation Historical Data Access (HDA) standard.