×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Getting information out of Interbase through BI-tool

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?

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

RE: Getting information out of Interbase through BI-tool

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

RE: Getting information out of Interbase through BI-tool

(OP)
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

RE: Getting information out of Interbase through BI-tool

Do you have an InterBase ODBC driver? If not, you can download a good one here:
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

(OP)
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

RE: Getting information out of Interbase through BI-tool

>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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close