What are the parameters of the Data Sources for Jazz Reporting Service (JRS) 5.0.1?
1. On the Admin page of JRS, if I click on 'connect to data sources', I'm requested to 'Enter the password for the database user of the data warehouse' ... What is the default password ?
2. On the 'Data Sources' page of JRS, if I want to create new data sources, what are the parameters values I need to enter :
- for Generic SPARQL Endpoint, SPARQL data source URL ?Thanks for your help
- for SQL Database or DW SQL connection, Data Source Location ?
Vincent
One answer
1. Which database is the data warehouse configured for? If it is Derby, then a password is not required. (It shouldn't be prompting for a password if the data warehouse is on Derby, but there were fixes made to this in the 5.0.1 timeframe.) Otherwise, the password is the database password that would have been used when the data warehouse was likely setup during CLM setup. You can see how the data warehouse is configured from the jts/admin > Reports > Data Warehouse Connection (or ask your administrator for the data warehouse password).
2. For Data Warehouse SQL Connection, the fields correspond to fields in the Data Warehouse Connection section mentioned previously.
Data Source location/password = JDBC location/password and if you cycle through the database vendor types it will give an example of what the location string looks like.
The other data source types aren't really supported yet in 5.0.1.
- Cherie
Comments
There is still an issue in 5.0.1 where the "Add Data Sources" task might prompt for a password for a Derby data warehouse. If this happens, that data source can be created manually from the data sources page using the following parameters:
Data Source Type: Data Warehouse SQL Connection
Database Vendor: Derby
Datasource Location: //localhost:1527/conf/jts/derby/warehouseDB
* The Datasource Location string should appear exactly as it does above (including the localhost) if the defaults were taken when setting up Derby as the Data Warehouse during CLM setup. Otherwise, the JDBC location and Database Network Server Port properties can be retrieved from the jts/admin page (see Reporting > Data Warehouse Connection).
The other properties can be left as their defaults.
1 vote
This is the correct answer that works for me to create the data source on a derby DW.
Thanks Cherie.