Can I use RTC4.0.2 and BIRT2.6.2 to fetch data from csv file
Hi,
I am using RTC4.0.2 client version and BIRT2.6.2version. I wanted to fetch data from csv file. Can I use data source as flat file with this configuration? If yes, where should i place the csv file? Any help on flat file data source is much appreciated. Thanks,
Regards, Tojan. |
One answer
Yes, you should be able to use data source as flat file for csv. When creating data source, you can browse to csv file hence it should be ok to place csv file anywhere locally, for example, in your Eclipse client Workspace.
Have you tried that? Do you see any specific problem? Comments Hi Don,
Yes, I tried and getting below error:
Cannot open the connection for the driver: org.eclipse.datatools.connectivity.oda.flatfile.
org.eclipse.datatools.connectivity.oda.OdaException: Cannot open flat file database under directory C:\test\xxx.csv
If you get this problem after deploying the report, i.e. the report runs on a machine different to the one on which it is designed, the URI to the file "C:\test\xxx.csv" can be invalid. If possible, put the file on the other machine exactly the same as defined in the report. Otherwise, you may need to use parameters to point to the actual file.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.