Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Tuesday 6 May 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

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
 

No comments:

Post a Comment