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.
Explore Products for Data Acquisition
Exchange Data between MATLAB and Databases Without Knowing SQL
Analyze information stored in ODBC- and JDBC-compliant databases using MATLAB anddatabase 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 buildingcomputational financeapplications in MATLAB can use MathWorksdata feed connectivity toolsto 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,OPC 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.
