Cannot Fetch data from database

Hello All

This has been my biggest deadlock these days.

I am Using BIRT to fetch data from a DB2 databse and create report.

I am following the process as
1. create a blank BIRT Project
2. Add Report
3. Create a Datasource for the report by providing Driver information, driver url, user and password.
4. create a dataset and fetch the table data as a query

Now all the above steps are success. The only problem is that the datasource which is connecting to the database is not picking all the tables.

I have gone thru **** lot of blogs but getting the solution.

Can anybody guide me really fast.

i will be ever grateful
Thanks a lot
shantanu

Find more posts tagged with

Comments

bhanley

You said you had successfully grabbed data from the database, so what information is not being fetched? Are you able to run your query directly against the Data Source (outside BIRT) to guarantee it gives you exactly the results set you want?

Can you post your query so we can have a look?

Abdel

Hi,
When creating data sets.. after entering the Query click on "preview" and see if all the data you need is fetched properly? do you see the data you need in preview?

Regards,
Abdel Olakara

Senz79

Hi Thanks a lot for the reply

When i create the datasource connecting to a schema i should be able to see all the tables in that schema, but i am not able to see that. To cross verify i checked in the DB2 console but there i was able to see all the tables.

Is there any version problem between BIRT and DB2

bhanley

No, there is not a reason generic to BIRT that you should not be seeing something in your database. is the database secured in some way that could obscure your visibility?

Senz79

I feel there is some configuration setting for the datasource as i cross checked the same.

Now the Birt data source is picking first 100 rows in alphabetical order i executed the below query and it gave me the same result

db2 => select TABNAME , OWNER from syscat.tables where owner = 'ITMUSER' order by tabname fetch first 100 rows only

Kindly assist me in case i can change the setting