How to connect mssql database

Hi all,

I am new to BirtExchange.
I have installed iServer Express on my machine. Now i want to connect to SQl server 2005 database and create the reports in iServer express

how can i do this ? please help me..

Thanks,
Amol

Find more posts tagged with

Comments

averma

Hi Amol, 
I guess you want to create ad-hoc reports over the web using iServer Express? If that is the case you will need to first create and publish BIRT template to iServer Express. Here is the link to tutorial that can help you get started: 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/interactive-reporting/359-creating-and-publishing-businessreport-studio-templates/#description'>Creating and publishing BusinessReport Studio templates - Tutorials - BIRT Exchange</a> 
 
Ashwini

rmurphy

Hi Amol, 
I would also recommend going through the Getting Started Guide for iServer Express. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/wiki/GSG:Getting_Started_with_iServer_Express/'>Getting Started with iServer Express - BIRT Wiki - BIRT Exchange</a> 
 
Rob

amolwable

Thanks Ashwini, Rob

My problem is that.. is it possible to create data object like live examples under "server> Public > Information Objects Based Examples > Sample_Project > Data Sources > ClassicModels"

is it possible to connect mssql 2005 directly to iServer Express without using other product like report desinger?

Also in Birt Report studio when i want to create new report using data from my ms sql 2005 database.

Thanks,
Amol

rmurphy

Amol,
The iServer Express itself does not connect to data sources. The iServer Express is a platform responsible for managing all the various resources such as the BIRT Report Engine, Information Objects data engine, exposing web services, handling report/document storage and versioning, security, administration, etc.

Information Objects provide a meta data, or data abstraction, layer for Actuate based reports. In order to create Information Objects, you need to design them in either using the Information Object Designer, or the IO Design perspective in the Actuate BIRT Report Designer Professional. Designing Information Objects consists of the following steps:
1. Create Data Connection Definitions. A data connection definition defines the connection properties for a data source.

2. Creating maps. Maps represent one of the following: a database table, a database view, a query written in the database's native language, a result set from a stored procedure, or a result set from an ODA data source query.

3. Create Information Object. You build an information object from maps or other information objects.

Once an Information Object is created, it is published to the iServer Express (similar to designing a report and publishing it to the iServer Express).

Information Objects are not required by any product, but definitely make data access easier when designing reports. Information Objects also make data access in the BIRT Report Studio web-based designer much more flexible and ultimately provides a better end-user experience.

Does that help?

Rob