BusinessObjects Board

Is it possible to run and export a Free Hand SQL source Webi

sdk development
#1

Is it possible to run and export a Free Hand SQL source Webi with Report Engine ?

I am trying to run a webi document and export the result to CSV etc using BO Java Report Engine SDK
The webi is created using Free-hand SQL as the datasource

        IEnterpriseSession enterpriseSession = getSessionFactory().getSessionInstance();
        ReportEngine wiRepEngine = getReportEngine(enterpriseSession);
        DocumentInstance inst = wiRepEngine.openDocument(Integer.parseInt(instance));
        Report report = inst.getReports().getItem(0);
        DataProvider dp = inst.getDataProviders().getItem(0);

When I try to get the DataProvider I get the following error message

Caused by: com.sap.sl.sdk.datasource.strategy.DataSourceStrategyException$DataSourceStrategyNotRegisteredException: No concrete data source strategy registered for data source type “FHSQL” and data source sub type"".

alexuyus (BOB member since 2014-07-24)

#2

Report Engine is deprecated in BI4. Some of the functionality still works, but I’m not surprised that support for FHSQL isn’t there. You’ll need to use the REST API.

joepeters :us: (BOB member since 2002-08-29)