How do I open Oracle Lite ODB Files in Matlab

13 visualizaciones (últimos 30 días)
Terry Snow
Terry Snow el 21 de En. de 2021
Respondida: Terry Snow el 27 de En. de 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 ?
  2 comentarios
Terry Snow
Terry Snow el 22 de En. de 2021
Some more information, the version of Oracle Lite is 10.1
Walter Roberson
Walter Roberson el 27 de En. de 2021
Editada: Walter Roberson el 27 de En. de 2021
There might also be ways to use java to talk to the database.

Iniciar sesión para comentar.

Respuestas (2)

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

Iniciar sesión para comentar.


Terry Snow
Terry Snow el 27 de En. de 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

Etiquetas

Productos


Versión

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by