Is there a way to communicate these Platforms effieciently? I'm saying, something like exporting (SQL Server)and load (Matlab) but in an efficient way?
Asked
Active
Viewed 3,741 times
1
-
1Have you looked at the [Database Toolbox](http://www.mathworks.com/help/toolbox/database/)? – b3. Feb 24 '11 at 22:18
3 Answers
2
I've found adodb_tools on File Exchange to work the best so far. It's much faster than the database toolbox or any prior wrapping solutions.
Doesn't require additional toolboxes but in all likelihood will require you're on Windows for the ADO OLEDB ActiveX support.
Marc
- 56
- 2
1
Use MATLAB's capability to run Java code in order to access any database that provides a JDBC driver. If you mind using Java, buy the Database Toolbox as mentioned by @b3.
zellus
- 9,617
- 5
- 39
- 56
-
I've always found it easier (and cheaper) to write a fairly simple wrapper class around the JDBC calls, so you only have to deal with all of that complexity once. The key is if you're deploying your code in multiple places, a robust solution for keeping track of the required jar file requires some careful thought. – Marc Feb 25 '11 at 20:29
0
As mentioned use Java and the JDBC driver for your chosen database.
If you look through Stackoverflow there are a few posting about connecting MATLAB and MySQL.
and
How can i remotely connect ODBC using Java in Windows XP?
These solutions should work with a little tweaking for your database driver.
