Getting information out of Interbase through BI-tool
Getting information out of Interbase through BI-tool
(OP)
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?
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
RE: Getting information out of Interbase through BI-tool
Do you want to access the InterBase database directly?
Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird
http://www.upscene.com
RE: Getting information out of Interbase through BI-tool
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
RE: Getting information out of Interbase through BI-tool
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 "gdb" 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
RE: Getting information out of Interbase through BI-tool
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
RE: Getting information out of Interbase through BI-tool
Yes.
Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird
http://www.upscene.com