How configure datasource to use csv file with a report runs on iServer

This question may seem simple but I have not found a clear answer. 
How to publish a csv flat file type on the iServer? 
In other words: 
How to use a flat file in a report from iPortal execute? 
 
Do you have a tutorial? 
Clear explanations? 
 
Thank you in advance.

Find more posts tagged with

Comments

averma

Hi fm_expand,
The flat file must reside locally on the file system where your iServer is running. Now use your BIRT Designer to create BIRT report. In this report, create a data source (using flat file data source connector). Now you can create data set using the above defined data source. This data set can be used in your report. When you are finished designing the report, you can simply publish the report to BIRT iServer. The report can be run from Information Console as long as the flat file location does not change.
The process of using flat file data source is not any different than using any other connector. Take a look at BIRT Designer Overview video to learn how to create data sources and data sets and use them in your report.
http://www.birt-exchange.com/be/products/birt-design/birt-designer-pro/demo/
Hope this helps!

fm_expand

Hi,
Thanks for your quickly answer :-).

If I understood well your answer, I must create a new datasource and selected a folder on my iServer like that :
\\myServer\flat_dir\

I tested it with another server and it works but I have no right to connect me by FTP or in direct on iServer, I have just right to access iportal and acadmin therefore I would like use a resource of csv file and linked my datasource with this file or something like that.

For information, I use BIRT on Windows System and my iServer runs on Linux System

Could you tell me if I understood well ?
Have you got another solution ?

Thank you

averma

Hi fm_expand,
I am not sure if I understood your question. If your file exists on a remote server, you may consider using a URI in your flat file data source definition, depending on your architecture this might involve setting up an internal web server that can facilitate file transfer.

Ashwini