Getting information out of Interbase through BI-tool 1

[blom0344]

I noticed very few active participants on this forum, so perhaps there is an expert to exchange info directly.

My problem (working with DB2/ORACLE) is that Interbase related data is so scarce. I want to use a BI-tool (Business Objects) to use directly on a P&O database that runs on an interbase database. We know nothing about it, though it runs for years without ever needing attention. (quite something I guess)

We are talking about a late 5 version of the database. We can only read info from it (through the bought application), we are not authorized to change or add to the database design. There must be ways to use ODBC to reach the database, but info is hard to get

Anyone of you any ideas?

T. Blom
Information analyst
tbl@shimano-eu.com

 

[MartijnTonies]

What is your exact question?

Do you want to access the InterBase database directly?

Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com

 

[blom0344]

Yes, We want to be able to directly extract data from the database using ODBC. (In this case we want to use Business Objects to draw data from the interbase database and combine it at report-level with other data)

We report on DB2/ORACLE/SQL Server on a daily basis with a variety of tools, but Interbase is something new to use. The application runs, apperently there is a database we should be able to get into.

But how?

Do you have any suggestions?


T. Blom
Information analyst
tbl@shimano-eu.com

 

[MartijnTonies]

Do you have an InterBase ODBC driver? If not, you can download a good one here:

http://www.easysoft.com

Next, you need to find out where the database resides - unlike MS SQL, Oracle or DB2, InterBase does not have a central repository with available databases, but expects the client application to know where the primary database file is.

A "connect string" (for TCP/IP) can look like this:

<server>:<path><primary_datafile>

eg:

my_server:d:\data\app\mydatabase.gdb

Notice that &quot;gdb&quot; can be anything, but this used to be the default extension for InterBase < v7.


Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com

 

[blom0344]

Hello Martijn,

I finally got authorization to access the interbase database using ODBC for read-only purposes.
I downloaded the easysoft driver: ib6-2_0_22-windows-x86.exe
, but when installing it gives an error-message about a dll that it cannot locate: gds32.dll

Is a interbase client required to get ODBC working?

T. Blom
Information analyst
tbl@shimano-eu.com

 

[MartijnTonies]

>Is a interbase client required to get ODBC working?

Yes.



Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com