Can DatabaseDatastore work with Oracle, for example?

According to the doc here DatabaseDatastore object supports only Microsoft® SQL Server® 2012 and later versions. However I can create an object of this class with, say, an Oracle connection, and apply methods such as readall etc. It would appear to work with Oracle... Is the documentation wrong? Or will the ReadSize parameter be ignored when you invoke a big query?

Answer 1

[MathWorks Computational Finance Team]

Hi Julian,

You are correct, we need to update the documentation to reflect this information more accurately. DatabaseDatastore supports following databases:

• Microsoft® SQL Server® 2012 and later
• Oracle ®
• MySQL®
• PostgreSQL
• SQLite
• Amazon Redshift®
• Amazon Aurora®
• Google® Cloud SQL that runs an instance of MySQL or PostgreSQL
• MariaDB®

Hope this answers your question.