How to connect to a database

CloverDX Platform
1

Hi

i dont know how to connect to a database. I read the tutorial and everything, but i still haven’t been able to do it.

i am using SQL express 2005 , and for that, I’ve downloaded jdbc drivers. When i load them (from database connection wizard), the next time i go into the database connetion wizard, they are not there. Is that suppose to happend, or am I doing something wrong?
Also, i am new to sql express, so , can somebody please tell me , what is the form of the URL for the data base, and what do i have to put for username and password in the database connection window.

thanks in advance

2

Hello,
is your database prepared for connecting through jdbc (see Preparing the Microsoft SQL Server 2005 Express Edition database)? If yes, add the proper jdbc driver and set connection properties:

  • url to database (jdbc:sqlserver://host:port\SQLEXPRESS;databaseName=database)

  • user ID

  • password

  • select MS SQL Server 2000-2005 in JDBC specific combo

After clicking OK, the driver you have added should be available in driver’s panel in the future.

3

Check CloverDesigner documentation - Section DB Connections http://www.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/creating-internal-database-connections.html

There is a section on adding new JDBC drivers to the list.

You may download MS SQL JDBC driver from here:

4

Thanks Avackova

Your post really helped me. The link you provided was extremely helpful. For thous of you who have the same problem, follow that link.
Also the URL to the database (now the driver is installed with in cloverETL) by selecting the ms sql from the list, you will get some default link where you only have to change hostname and database.
In contrast to the link that Avackova provided, mine was different in that way that it did not had the “'\SQLEXPRESS” part.

thanks again