Connecting Iserver to SQL server

HI all,

How can we connect Actuate Iserver version 10 with SQL server.

Thanks

Find more posts tagged with

Comments

Just use (http://msdn.microsoft.com/en-us/sqlserver/aa937724) for your JDBC connection.

On the iserver put the jar in the driver folder of the plugins.

As stated in http://www.birt-exchange.com/be/documentation/R11/mc/help/admin/wwhelp/wwhimpl/common/html/wwhelp.htm#context=iServer&file=dbconn.16.28.html

And I sugest next time asking in:

http://www.birt-exchange.org/org/forum/index.php/forum/11-deploying-birt-reports-in-deployment-kit-or-birt-iserver/

ahsiang

Hi, if you are Actuate BIRT Designer Pro, there is already an existing JDBC for MSSQL. At the datasource creation screen, choose JDBC Data Source and on the following screen, the first drop down box will have MSSQL by the name of com.actuate.jdbc.sqlserver.SQLServerDrive. It will automatically show the syntax on the Database URL. Just replace the SERVER, PORT and databasename. Then enter your user name and password on the 3rd and 4th box.