We´re using Visual Composer to build bpm analytics reports. Acessing Visual Composer from browser (/VC) works perfectly, we can see tables from CE, on BI Data Source option.
But when using Visual Composer directly on Developer Studio. On select provider, when I click on BI Data Sources, there´s an error message:
"Check the BW systems. Check the BW configuration in the System Landscape. Make sure the user mapping is set correctly and all connection properties are correct".
But I´m not trying to connect to any BW system, I want to view CE Bpm tables.
Consuming BMP data sources is not supported by in VC@NWDS.
Possible workaround: start developing the models and consume BMP data sources in Visual Composer browser version and afterwards, having VC configured to work with DTR, you can check the models in to DTR, sync them in NWDS, check out and continue modeling.
We are trying to get process and task datasource directly from CE instead of getting data form BW system.
In order to get process and task data source information, do we need to configure communication between BPM and BW? Becasuse, if I am not wrong, in the scenario of Real Time Reporting Analysis, data should be accessed directly from CE instead of getting data from BW...
Which are the steps you followed to configure system in order to make "BI Data Source" provider available? if we try to discover data sources (without BPM-BW communication configuration) we receive the message:
"Could not retrieve systems, Check the BW systems configuration in the system landscape. Make sure the user mapping is set correctly and all connection properties are correct"
@Vitor, you cannot access BPM datasource from VC@NWDS, as Talia has already mentioned it, This datasource won't be listed in NWDS with no exceptions in respect of configuration you did. The only way to access BPM tables from NWDS is not a VC-way, it's a JDBC-way of datasource definition but it's not recommended at all.
@Fabrizio, you have not to do any additional configuration if you want just to consume BPM datasource. It is available in VC' online mode only at the moment so you can access it via link host:port/VC then select portal local datasource and search for predefined BPM datasources. The only thing you have to keep in mind there should be all required BI Java components installed on your CE instance. Voila
Edited by: Roman Gumenyuk on Mar 7, 2012 12:34 PM
I have a scenario, in which I have to access the BPM data (related to Task/Process). Could you please suggest me how I can access these data?
Is it possible to access these data directly from BPM table (as you explained above JDBC-way of datasource definition)? Could you please explain me how I can do it.
BPM data is stored in the application server schema so establishing a JDBC connection.. Hugh, that's a simple task (deploy JDBC driver according to your dbms, create a datasource to your app. server db schema and use it every time you wanna to access table' data) but the format of these tables is closed so it's highly recommended to avoid such way - it's kinda tricky way
On the other hand it can be approached using integrated capabilities of VC. Read about it in the blog (also do not forget to look into the documentation at help.sap.com) download the samples, play with them and have fun There you may find how the data related to Task/Process will look like in VC http://scn.sap.com/people/radostina.kasova/blog/2010/03/16/6-sample-sap-netweaver-bpm-720-dashboards-implemented-with-visual-composer