Please help to understand the functionality of JCO (java connector ) and how to use it to make a connection between any reporting tool and sap database.
Creating a project, connection, and package for an SAP BW data source
To use an SAP BW data source with the dynamic query mode in IBM® Cognos® Business Intelligence, you must first create a project, connection, and package in IBM Cognos Framework Manager. You then publish the package, which makes it available in Cognos BI and uses the dynamic query mode for reports.
You can publish an SAP BW package directly from IBM Cognos Connection or through Cognos Framework Manager. However, importing SAP BW metadata into Cognos Framework Manager allows for additional modeling and testing before the package is published. For information about publishing SAP BW packages directly in IBM Cognos Connection, see the IBM Cognos BIAdministration and Security Guide.
Before you begin
Ensure that the SAP BW client is installed on your IBM Cognos BI servers and configured for connectivity to SAP BW.
To use the compatible query mode in your model, you must install and configure SAP GUI software on the computer running Cognos Framework Manager.
Procedure
Open Cognos Framework Manager, then click Create a new project.
Enter a name and location for the new project.
Select Use Dynamic Query Mode, then click OK.
Choose a design language and click OK.
Ensure that Data Sources is selected, then click Next.
Click New to create a data source connection.
Click Next. In the Name field, enter a name for your new connection, then click Next.
From the Type list, select SAP BW, then click Next.
Based on the connection information provided by your SAP BW administrator, select the SAP logon type, enter the application server name, system number, and client number, and provide the security signon configuration.
Click Test the connection, then click Test. On the View the results page of the connection test, the status of the connection tests for both the compatible query mode and dynamic query mode should be Succeeded.
Click Close, click Close again, then click Finish.
Click Close. The new data source appears in the list.
Ensure that the SAP BW data source that you created is selected. Click Next, then select the reporting objects (InfoQuery or InfoCube) that you want to import.
Click Next, then select the language for the cube and how to present attribute dimensions.
Click Next, then, on the Generate Dimensions page, select how you want to display object names and organize the dimensions.
Click Next to import the metadata, then click Finish.
In the Project Viewer, expand the new namespace created for the SAP BW metadata and notice that all the dimensions and key figures have been imported.
If the Query Mode property of the project is set to Dynamic when testing these SAP BW objects, the test queries will run with in the dynamic query mode. Otherwise, there is an option to use the dynamic query mode instead of the compatible query mode on the Test tab.
For more information about working with SAP BW metadata, see the IBM Cognos Framework Manager User Guide.
In the Project Viewer, right-click Packages, point to Create, then click Package
Enter a name for the package. Click Next.
Select the objects to include in the package.
Click Next, click Finish, then click Next to open the Publish wizard.
Follow the wizard instructions, responding as required. Click Next until you reach the Options page.
Select Use Dynamic Query Mode.
Tip: This option is available only when the Query Mode property of the project is set to Compatible and the package contains only supported data sources. If this option is not available and the Query Mode property of the project is set to Dynamic and the package contains only supported data sources, proceed to the next step.
Click Publish, then click Finish. The package is now available in Cognos BI and uses the dynamic query mode for reports.
Tip: In IBM Cognos Connection, you can verify the type of query mode used by the package by viewing the package properties
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.