How do I open Oracle Lite ODB Files in Matlab

I have data provided by a 3rd Party that is an extract from an Oracle Database. The files are in Oracle Lite format as ODB, OBS files.

Is there a mechanism to open these files in Matlab ?

[Terry Snow]

Some more information, the version of Oracle Lite is 10.1

[Walter Roberson]

https://www.mathworks.com/help/database/ug/connecting-to-database.html#bt4snwh

There might also be ways to use java to talk to the database.

Answer 1

[Deepak Meena]

Hi Terry,

This is the list of File Format supported for Import and Export in MATLAB.

As we can see .odb and .obs are not mentioned in it. So directly we can not import or export those file extensions so if possible try to convert into a format which is readable by MATLAB .

Also I found something on File Exchange which can be useful for you: Abacus2Matlab.

Thanks

[Walter Roberson]

It is a database. The list of regular file formats is not relevant; the question becomes whether the database toolbox supports it.

Answer 2

[Terry Snow]

Some more information about this database. Oracle Lite has an ODBC Driver. So, I believe what is necessary is to set up an ODBC DNS for that database using the ODBC Driver.

I have been looking at the database in Visual Studio using OBDC dot net. Have also found that the data that I am interested in is in BLOB column. So I will also need to reverse engineer the binary format of the BLOB. I dont think that there is anything specific that Matlab can help me for this data.

Thanks in any case