You use this function to configure crystal reports to enable MII Connector which connects various MII queries through the Crystal Reports (Designer).
For more information on crystal reports, see the SAP Help Portal at http://help.sap.com at
You have installed SAP Crystal Reports 2011.
You have downloaded CRMIIConnector.jar to your local system from
.To configure the crystal report to MII Connector, do the following:
Copy CRMIIConnector.jar to <CR_Install_Dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external.
Goto <CR_Install_Dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java. Browse and open CRConfig.xml in a text editor.
Include the path <CR_Install_Dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external\CRMIIConnector.jar in the <Classpath> tag..
Choose
.Choose
.The Database Expert screen appears.
Choose
.The JDBC (JNDI) screen appears.
Enter the following:
Connection URL: jdbc:sapxmii://<MIIServername>:<standard http port>/
When the https connection is enabled, you must enter the https port of an MII server and include an additional parameter ?ssl=true. You must also import the server certificate available in your local system to jvm.
To download the server certificate to your local system do the following:
Open current MII instance in IE browser.
Choose
to start the wizard.From the Certificate Import Wizard screen, choose Next.
Choose Place all certificates in the following store and Browse.
The Select Certificate Store appears.
Select Other People from the list.
Choose Next and Finish.
On the IE, choose
Select the certificate and choose Export.
A Certificate Export Wizard appears.
Choose Next.
Select the default export file format (.cer).
Choose Next and browse to the location where you want to save.
Enter a name, choose Next and Finish.
To import the server certificate to JVM, call the following command in the windows command prompt:
<CR_install_Dir>\SAP BusinessObjects Enterprise XI 4.0\win32_x86\jdk\jre6\bin\keytool.exe -import -trustcacerts -file C:\\MII\\servercertificate.cer -keystore <CR_install_Dir>\SAP BusinessObjects Enterprise XI 4.0\win32_x86\jdk\jre6\lib\security\cacerts -alias aliasname
Database Classname: com.sap.xmii.bobj.crystal.jdbc.CRMIIConnector
Choose Next.
The Connection Information screen appears.
Enter the credentials in the following fields:
UserID
Password
For details on SSL connections, see
.Choose Finish.
The connection is added to MyConnections.
Note
<CR_Install_Dir> represents the directory where crystal reports are installed.