MATLAB Answers

How do I open Oracle Lite ODB Files in Matlab

조회 수: 35(최근 30일)
Terry Snow
Terry Snow 21 Jan 2021
답변: Terry Snow 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 ?
  댓글 수: 2
Walter Roberson
Walter Roberson 27 Jan 2021
There might also be ways to use java to talk to the database.

댓글을 달려면 로그인하십시오.

답변(2개)

Deepak Meena
Deepak Meena 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
Walter Roberson
Walter Roberson 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.

댓글을 달려면 로그인하십시오.


Terry Snow
Terry Snow 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

태그

제품


릴리스

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by