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	http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html

PostgreSQL

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

MySQL

Driver class	com.mysql.jdbc.Driver
URL	jdbc:mysql://localhost:3306/foodmart
User Name/password	root/password
Download driver at	http://dev.mysql.com/downloads/connector/j/

MS-SQL Server
Refer : http://razorsql.com/docs/help_sqlserver.html

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	http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

Open source database client Tools

DB Visulizer	Download at : https://www.dbvis.com/download/
Squerriel	Download at : http://www.squirrelsql.org/#installation

Thank you.

Sadakar

BI developer