How do I open Oracle Lite ODB Files in Matlab

11 views (last 30 days)
Terry Snow
Terry Snow on 21 Jan 2021
Answered: Terry Snow on 27 Jan 2021
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 ?

Answers (2)

Deepak Meena
Deepak Meena on 27 Jan 2021
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
  1 Comment
Walter Roberson
Walter Roberson on 27 Jan 2021
It is a database. The list of regular file formats is not relevant; the question becomes whether the database toolbox supports it.

Sign in to comment.


Terry Snow
Terry Snow on 27 Jan 2021
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

Tags

Products


Release

R2020b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by