Jaspersoft BI Tools

iReport,Jaspersoft Design Studio,Jaspersoft Server, Schema Workbench,Analysis,Dashboards, Self Service BI, Domains,Topics,Ad-Hoc Reports, Jaspersoft ETL, Embedding BI,HTML-5 charts, Fusion Charts,JFree Charts,Drill down reports , Drill down Dashboards,Visualize.js, Performance Tuning, D3 Charts, Jaspersoft Customization

Tuesday, May 06, 2014

Do you work with multiple databases in BI - Quick info of drivers details of leading databases & client tools info


Hi guys,

Not a big effort but keeping all info together for quick check of driver details in blog site...

Oracle 10g
Driver class
oracle.jdbc.driver.OracleDriver
URL
jdbc:oracle:thin:@localhost:1521:orcl where orcl is SID
User Name/password
system/manager
Download driver at

PostgreSQL
Driver class
org.postgresql.Driver
URL
jdbc:postgresql://localhost:5432/foodmart
User Name/password
postgres/postgres
Download driver at

MySQL
Driver class
com.mysql.jdbc.Driver
URL
jdbc:mysql://localhost:3306/foodmart 
User Name/password
root/password
Download driver at

MS-SQL Server
Driver class
com.microsoft.sqlserver.jdbc.SQLServerDriver
or
MSSQLServer (com.merant.datadirect.jdbc.sqlserver.SQLServerDriver)
URL
jdbc:sqlserver://localhost:1433/DatabaseName
User Name/password
Username/password for ms-sql server

net.sourceforge.jtds.jdbc.Driver

Syntax:
jdbc:jtds:sqlserver://<host>:<port>/<database_name>
Eg:
jdbc:jtds:sqlserver://127.0.0.1:1433/test
Download driver at


Open source database client Tools
DB Visulizer
Squerriel

Thank you
Sadakar
BI developer