connecting using tnsname.ora

mjohnsoDRG

How do I connect to the database using Tnsname? I'm currently able to connect using these parameters (see attached jpeg).

johnw

BIRT is not going to use the native Oracle connections in the tnsname.ora in the way that SQLPlus does unless you write a custom ODA to do so. It uses JDBC for database connections.

With that said, you could write some script in the property binding for the JDBC URL to parse the tnsnames.ora file and fill in the appropriate JDBC values from there.