4
This file is shown below, including a sample update for a DB2 Database:
#<DataSourceName>.<propertyName>=value
# driver for ORACLE
# oracle.jdbc.driver.OracleDriver
# sample url for ORACLE
# jdbc:oracle:thin:@<HOST>:<PORT>:<SID>
# driver for SQLServer
# com.inet.tds.TdsDriver
# sample url for SQLServer
# jdbc:inetdae7a:hostname:port?database=dbname&language=us_english&nowarnings=true
# driver for DB2
# com.ibm.db2.jcc.DB2Driver
# sample url for DB2
# jdbc:db2://localhost:50000/dbalias
maximoDataSource.url=jdbc:db2://HARRIERDB2:50000/HARRIER
maximoDataSource.driver=com.ibm.db2.jcc.DB2Driver
maximoDataSource.username=maximo
maximoDataSource.password=maximo
The values in
red point to a sample local database. You can check yours and other available for
you to choose from Start Menu\Programs\IBM DB2\Set-up Tools\Configuration Assistant.
The key name in
green is the default set for all reports, you have to use exactly this text.
Note:
The mxdatasources.properties file is only used by a report developer when he is creating
reports within the BIRT Report Designer. When V7 Reports are executed from within the V7
Applications, their connection information will be passed dynamically from V7.
Separate database username and passwords can be set up for each individual report developer
to restrict their database access if required.s