Impossible to generate metamodel in spagoBI studio with Firebird

Question

In SpagoBI Studio, after saving a connection that was ok with the result firebird database, showed no table in the schema. It is possible to connect with Squirrel.

Data of the local connection:

url: jdbc: FirebirdSQL: //localhost//var/lib/firebird/2.5/data/database.fdb defaultHoldable = true
user: sysdba
pass: xxxxxxxxx

also does not return for remote connection:

jdbc: FirebirdSQL: 10.114.0.130/3050: /data/samdb/database.fdb

Could someone help me solve this problem?

Answer 1

Well I've got the same problem here.

After some searching I've found that Spago Studio doesn't allow you to install any software.

But this is not necessary in fact.

The solution: Download Firebird DTP package from Firebird DTP on GitHub then unzip the content into your SpagoBI (or any Eclipse plataform) /plugins/ directory and Firebird will be available in database's list for creating a new database connection.

Answer 2

Probably you need to install the Firebird DTP Plugin first, because Eclipse DTP doesn't support Firebird natively. You can download the plugin from Firebird DTP on GitHub.