• Configure CA Business Intelligence for CA MDM

    To configure CA Business Intelligence for CA MDM, perform configuration steps on multiple components.

  • About CA Business Intelligence

    CA Business Intelligence is a set of reporting and analytics software used by CA MDM and various other CA Technologies products. CA MDM uses CA Business Intelligence to integrate, analyze, and present vital information required for effective mobile device management through various reporting options.

  • About CA MDM

    CA Mobile Device Management (MDM) is an enterprise solution for securing and managing mobile users, devices, applications, and content (data) with your enterprise policies.

  • Verify Prerequisites

    The first step in integrating CA Business Intelligence with CA Mobile Device Management is to verify the prerequisites.

  • Create ODBC Connection to CA MDM Database

    CA Business Intelligence requires an Open Database Connection (ODBC) connection to the CA MDM database (SQL Server) to create and view reports on CA Mobile Device Management.

  • Import BIAR File

    To import the CA MDM BIAR file, use the BIConfig utility. The BiConfig utility takes inputs from the command line and an XML file that describes the configuration updates to be performed on the Business Objects environment.

  • Index Information Spaces

    Index the Information Space to make the information spaces available to the Explorer users. The indexing process generates the metadata that is required for the Explorer Search engine and publishes the Information Space to the list of available Information Spaces on the Home Page.

  • Install and Configure Mobile Server

    The Mobile Server is a web application server and receives requests that are sent by the Mobile client and passes it to the CA BI platform server, and sends response to the Mobile client. The default installation location for the Mobile Server 3.1 SP6 is C:\Program Files (x86)\CA\SC\CommonReporting3.

  • Set Access Rights

    Provide access rights for controlling user access to the objects, users, applications, servers, and other features in your BusinessObjects environment. Use the Central Management Console (CMC) to provide the access rights to run the CA MDM reports.

  • Set Access Rights for Existing CA Business Intelligence Environments

    When you import the MDM BIAR file to an existing CA Business Intelligence environment, you need to assign appropriate Access Levels to the other CA Product user groups.
    Provide access rights for controlling user access to the objects, users, applications, servers, and other features in your BusinessObjects environment. Use the Central Management Console (CMC) to provide the access rights.
    Use the following as a guide to assign access rights that are based on user roles in an existing CA Business Intelligence environment:

    • Assign Folder Access to CA Reports and MDM Universe for the CA MDM BI Users group.
    • Assign No Access to the Everyone group for the top-level folder security.
    • Assign Folder Access to user groups who require CA Reports access.
  • Verify the following prerequisites:

    • CA Business Intelligence 3.3 SP1 has been installed. Verify that the CA Business Intelligence 3.3 SP1 Hot Fix has been applied.
      Important! When you restart CA Business Intelligence services, stop Tomcat 6 to avoid conflict with the default ports.
    • Microsoft SQL Server Native Client has been installed on the CA Business Intelligence Server.
    • BusinessObjects Explorer has been installed and configured to use Tomcat 7.
    • SAP BusinessObjects Mobile has been installed from the App Store.
    • SAP BusinessObjects Explorer has been installed from the App Store.
  • Follow these steps:

    1. Log in to the CA Business Intelligence Server.
    2. Open the ODBC 32-bit Data Source Administrator tool. Verify to use the 32-bit Odbcad32.exe, it is located by default at the systemdrive\Windows\SysWoW64 folder.
    3. On the System DSN tab, click Add to add a system data source.
    4. Click SQL Server to select the driver, and click Finish.

    The ODBC to the CA MDM database is completed

  • Follow these steps:

    1. Log in to the CA Business Intelligence Server.
    2. Create a BIConfig directory. Use the following example as a guide:
      C:\Program Files\CA\BIConfig
    3. Copy the BIConfig folder from the CA Business Intelligence installation media to the BIConfig directory created in Step 2.
    4. Verify the JAVA_HOME variable points to the proper JDK installation directory. Use the following example as a guide:
      CA_BI_Home\SC\CommonReporting\jre\
    5. Update the PATH environment variable. Use the following example as a guide:
      CA_BI_Home\SC\CommonReporting\jre\bin\
    6. Copy the xml_biar_import.xml file from the following location:
      biconfig\samples
    7. Place the xml_biar_import.xml file to the following location:
      biconfig
    8. Open the xml_biar_import.xml file with a text editor, and specify the configuration values.
    9. Open the command prompt and enter the following command to import the BIAR file:
      biconfig.bat -h “<CA_BI-hostname>“ –u “<CA_BI username>“ –p “<CA_BI pwd>“ -f xml_biar_import.xml

    You have completed importing the BIAR file using the BIConfig utility.

  • Note: To improve the indexing performance, schedule reports and index the information spaces during the off peak hours. Index and schedule the reports in parallel so that the data is consistent in the reports and in the information space.

  • Follow these steps:

    1. Open the following Explorer URL in a browser:
      http://<servername>:<portNumber>/polestar
    2. Use your credentials to log in.
      The Explorer home page appears.
    3. Click Manage Spaces.
    4. Browse the Universes and select CA MDM.
      Note: The CA MDM default Universe must not be changed except for any configuration changes related to a connection.
    5. Click Index Now to index the selected Information Space.
    6. Repeat Step 5 to index the other Information Spaces.
    7. (Optional) To schedule Information Spaces for indexing, click Schedule and then specify the appropriate details for the schedule, such as the frequency and the time, and then click OK.

    The information spaces are available to Explorer users.

  • Follow these steps:

    1. Copy the installation program from the Download location on the CA Support site.
    2. Right-click the following executable and select Run as administrator:
      setup.exe
      The installation program starts.
    3. Follow the instructions from the installation wizard.
    4. Restart your system after the installation finishes.

    The Mobile Server is installed, you can now proceed to configure the Mobile Server.

  • Deploy WAR Files

    Deploy the Mobile Server WAR files in the Tomcat application server to enable the Mobile Server features. Deploy the following WAR files to the Tomcat webapps location:
    ■ MobileBIService.war
    ■ MOBIServer.war
    ■ MobileOTA.war

    Follow these steps:

    1. Log in to the Mobile Server.
    2. Open the command prompt and run the following wdeploy commands:
      wdeploy tomcat7 -DAPP=MobileBIService deploy
      wdeploy tomcat7 -DAPP=MOBIServer deploy
      wdeploy tomcat7 -DAPP=MobileOTA deploy
    3. Restart the Tomcat web application server.

    The Mobile Server application is now deployed for the Tomcat application server.

  • Configure Mobile server.properties File

    Configure the server.properties file on the Mobile Server to allow mobile device users to directly import mobile server connections.
    Follow these steps:

    1. Log in to the Mobile Server.
    2. Stop the Tomcat Web application server.
    3. Make a backup copy of the following file:
      Tomcat_Home\webapps\MOBIServer\WEB-INF\server.properties
    4. Open the original server.properties file with a text editor.
    5. Configure the connection properties section. Use the following example as a guide:
      mobi.connections=connection1
      connection1.DisplayName=SAMPLE Connection
      connection1.BOBJ_MOBILE_URL=http://<Mobile_Server_Host_Name>:8080
      connection1.BOBJ_MOBILE_CMS=<CMS_Host_Name>:6400
      connection1.BOBJ_MOBILE_AUTH_METHOD:secEnterprise
      connection1.BOBJ_MOBILE_CONNECTION_TYPE:1
    6. Save the file and close the text editor.
    7. Start Tomcat.

    The server.properties file has been configured to allow users to directly import the mobile server connections.

  • Follow these steps:

    1. Open the following CMC URL in a browser:
      http://<ComputerName>:<PortNumber>/CmcApp
    2. Enter the CA_BI Administrator account and password.
    3. Go to the CMC Folders management area.
    4. Click Manage, Top-Level Security, All Folders.
      The dialog appears.
    5. Select Everyone and click Assign Security.
      The Assign Security dialog appears.
    6. Remove any Assigned Access Levels and click Close.
      The CMC management area appears.
    7. Click All Folders, right-click CA Reports, User Security.
      The Assign Security dialog appears.
    8. Select Everyone and click Assign Security.
    9. Verify that no Assigned Access Levels are present.
    10. Click Close.

    The access rights have been set to run CA MDM reports.

{"cards":[{"_id":"527cdd9e0fdd17e72500043c","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":1,"parentId":null,"content":"# Configure CA Business Intelligence for CA MDM\nTo configure CA Business Intelligence for CA MDM, perform configuration steps on multiple components."},{"_id":"38e0bcd27aec5c4011000009","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":1,"parentId":"527cdd9e0fdd17e72500043c","content":"![](http://i.imgur.com/aT0oB2Y.png)"},{"_id":"38e0cbdf7aec5c401100000a","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":2,"parentId":"527cdd9e0fdd17e72500043c","content":"##Verify Prerequisites\nThe first step in integrating CA Business Intelligence with CA Mobile Device Management is to verify the prerequisites."},{"_id":"38e0dac17aec5c401100000d","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":1,"parentId":"38e0cbdf7aec5c401100000a","content":"###Verify the following prerequisites:\n* CA Business Intelligence 3.3 SP1 has been installed. Verify that the CA Business Intelligence 3.3 SP1 Hot Fix has been applied.\n`Important! When you restart CA Business Intelligence services, stop Tomcat 6 to avoid conflict with the default ports.`\n* Microsoft SQL Server Native Client has been installed on the CA Business Intelligence Server.\n* BusinessObjects Explorer has been installed and configured to use Tomcat 7.\n* SAP BusinessObjects Mobile has been installed from the App Store.\n* SAP BusinessObjects Explorer has been installed from the App Store."},{"_id":"38e0d6fd7aec5c401100000b","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":3,"parentId":"527cdd9e0fdd17e72500043c","content":"##Create ODBC Connection to CA MDM Database\nCA Business Intelligence requires an Open Database Connection (ODBC) connection to the CA MDM database (SQL Server) to create and view reports on CA Mobile Device Management."},{"_id":"38e0dc427aec5c401100000e","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":1,"parentId":"38e0d6fd7aec5c401100000b","content":"Follow these steps:\n1. Log in to the CA Business Intelligence Server.\n2. Open the ODBC 32-bit Data Source Administrator tool. **Verify to use the 32-bit Odbcad32.exe, it is located by default at the systemdrive\\Windows\\SysWoW64 folder.**\n3. On the System DSN tab, click Add to add a system data source.\n4. Click SQL Server to select the driver, and click Finish.\n\nThe ODBC to the CA MDM database is completed"},{"_id":"38e0e3a87aec5c401100000f","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":4,"parentId":"527cdd9e0fdd17e72500043c","content":"##Import BIAR File\nTo import the CA MDM BIAR file, use the BIConfig utility. The BiConfig utility takes inputs from the command line and an XML file that describes the configuration updates to be performed on the Business Objects environment."},{"_id":"38e0f27d7aec5c4011000010","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":1,"parentId":"38e0e3a87aec5c401100000f","content":"Follow these steps:\n1. Log in to the CA Business Intelligence Server.\n2. Create a BIConfig directory. Use the following example as a guide:\n*C:\\Program Files\\CA\\BIConfig*\n3. Copy the BIConfig folder from the CA Business Intelligence installation media to the BIConfig directory created in Step 2.\n4. Verify the JAVA_HOME variable points to the proper JDK installation directory. Use the following example as a guide:\n*CA_BI_Home\\SC\\CommonReporting\\jre\\*\n5. Update the PATH environment variable. Use the following example as a guide:\n*CA_BI_Home\\SC\\CommonReporting\\jre\\bin\\*\n6. Copy the xml_biar_import.xml file from the following location:\n*biconfig\\samples*\n7. Place the xml_biar_import.xml file to the following location:\nbiconfig\n8. Open the xml_biar_import.xml file with a text editor, and specify the configuration values.\n9. Open the command prompt and enter the following command to import the BIAR file:\n*biconfig.bat -h \"<CA_BI-hostname>\" –u \"<CA_BI username>\" –p \"<CA_BI pwd>\" -f xml_biar_import.xml*\n\nYou have completed importing the BIAR file using the BIConfig utility."},{"_id":"38e0fb5f7aec5c4011000011","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":5,"parentId":"527cdd9e0fdd17e72500043c","content":"##Index Information Spaces\nIndex the Information Space to make the information spaces available to the Explorer users. The indexing process generates the metadata that is required for the Explorer Search engine and publishes the Information Space to the list of available Information Spaces on the Home Page."},{"_id":"38e103827aec5c4011000012","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":1,"parentId":"38e0fb5f7aec5c4011000011","content":"Note: To improve the indexing performance, schedule reports and index the information spaces during the off peak hours. Index and schedule the reports in parallel so that the data is consistent in the reports and in the information space."},{"_id":"38e103e37aec5c4011000013","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":2,"parentId":"38e0fb5f7aec5c4011000011","content":"Follow these steps:\n1. Open the following Explorer URL in a browser:\n*http://<servername>:<portNumber>/polestar*\n2. Use your credentials to log in.\nThe Explorer home page appears.\n3. Click Manage Spaces.\n4. Browse the Universes and select CA MDM.\n**Note: The CA MDM default Universe must not be changed except for any configuration changes related to a connection.**\n5. Click Index Now to index the selected Information Space.\n6. Repeat Step 5 to index the other Information Spaces.\n7. (Optional) To schedule Information Spaces for indexing, click Schedule and then specify the appropriate details for the schedule, such as the frequency and the time, and then click OK.\n\nThe information spaces are available to Explorer users."},{"_id":"3a412324580a6c7963000012","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":6,"parentId":"527cdd9e0fdd17e72500043c","content":"##Install and Configure Mobile Server\nThe Mobile Server is a web application server and receives requests that are sent by the Mobile client and passes it to the CA BI platform server, and sends response to the Mobile client. The default installation location for the Mobile Server 3.1 SP6 is C:\\Program Files (x86)\\CA\\SC\\CommonReporting3."},{"_id":"3a4124a7580a6c7963000013","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":1,"parentId":"3a412324580a6c7963000012","content":"Follow these steps:\n1. Copy the installation program from the Download location on the CA Support site.\n2. Right-click the following executable and select Run as administrator:\n*setup.exe*\nThe installation program starts.\n3. Follow the instructions from the installation wizard.\n4. Restart your system after the installation finishes.\n\nThe Mobile Server is installed, you can now proceed to configure the Mobile Server."},{"_id":"3a412d10580a6c7963000014","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":2,"parentId":"3a412324580a6c7963000012","content":"##Deploy WAR Files\nDeploy the Mobile Server WAR files in the Tomcat application server to enable the Mobile Server features. Deploy the following WAR files to the Tomcat webapps location:\n■ MobileBIService.war\n■ MOBIServer.war\n■ MobileOTA.war\n\nFollow these steps:\n1. Log in to the Mobile Server.\n2. Open the command prompt and run the following wdeploy commands:\n*wdeploy tomcat7 -DAPP=MobileBIService deploy\nwdeploy tomcat7 -DAPP=MOBIServer deploy\nwdeploy tomcat7 -DAPP=MobileOTA deploy*\n3. Restart the Tomcat web application server.\n\nThe Mobile Server application is now deployed for the Tomcat application server."},{"_id":"3a4131e7580a6c7963000015","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":3,"parentId":"3a412324580a6c7963000012","content":"##Configure Mobile server.properties File\nConfigure the server.properties file on the Mobile Server to allow mobile device users to directly import mobile server connections.\nFollow these steps:\n1. Log in to the Mobile Server.\n2. Stop the Tomcat Web application server.\n3. Make a backup copy of the following file:\n*Tomcat_Home\\webapps\\MOBIServer\\WEB-INF\\server.properties*\n4. Open the original server.properties file with a text editor.\n5. Configure the connection properties section. Use the following example as a guide:\n*mobi.connections=connection1\nconnection1.DisplayName=SAMPLE Connection\nconnection1.BOBJ_MOBILE_URL=http://<Mobile_Server_Host_Name>:8080\nconnection1.BOBJ_MOBILE_CMS=<CMS_Host_Name>:6400\nconnection1.BOBJ_MOBILE_AUTH_METHOD:secEnterprise\nconnection1.BOBJ_MOBILE_CONNECTION_TYPE:1*\n6. Save the file and close the text editor.\n7. Start Tomcat.\n\nThe server.properties file has been configured to allow users to directly import the mobile server connections."},{"_id":"3a4136e9580a6c7963000016","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":7,"parentId":"527cdd9e0fdd17e72500043c","content":"##Set Access Rights\nProvide access rights for controlling user access to the objects, users, applications, servers, and other features in your BusinessObjects environment. Use the Central Management Console (CMC) to provide the access rights to run the CA MDM reports."},{"_id":"3a413912580a6c7963000017","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":1,"parentId":"3a4136e9580a6c7963000016","content":"Follow these steps:\n1. Open the following CMC URL in a browser:\n*http://<ComputerName>:<PortNumber>/CmcApp*\n2. Enter the CA_BI Administrator account and password.\n3. Go to the CMC Folders management area.\n4. Click Manage, Top-Level Security, All Folders.\nThe dialog appears.\n5. Select Everyone and click Assign Security.\nThe Assign Security dialog appears.\n6. Remove any Assigned Access Levels and click Close.\nThe CMC management area appears.\n7. Click All Folders, right-click CA Reports, User Security.\nThe Assign Security dialog appears.\n8. Select Everyone and click Assign Security.\n9. Verify that no Assigned Access Levels are present.\n10. Click Close.\n\nThe access rights have been set to run CA MDM reports."},{"_id":"3a413af3580a6c7963000018","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":8,"parentId":"527cdd9e0fdd17e72500043c","content":"##Set Access Rights for Existing CA Business Intelligence Environments\nWhen you import the MDM BIAR file to an existing CA Business Intelligence environment, you need to assign appropriate Access Levels to the other CA Product user groups.\nProvide access rights for controlling user access to the objects, users, applications, servers, and other features in your BusinessObjects environment. Use the Central Management Console (CMC) to provide the access rights.\nUse the following as a guide to assign access rights that are based on user roles in an existing CA Business Intelligence environment:\n* Assign Folder Access to CA Reports and MDM Universe for the CA MDM BI Users group.\n* Assign No Access to the Everyone group for the top-level folder security.\n* Assign Folder Access to user groups who require CA Reports access."},{"_id":"3a40fab2580a6c7963000010","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":2,"parentId":null,"content":"##About CA Business Intelligence\nCA Business Intelligence is a set of reporting and analytics software used by CA MDM and various other CA Technologies products. CA MDM uses CA Business Intelligence to integrate, analyze, and present vital information required for effective mobile device management through various reporting options."},{"_id":"3a40fc58580a6c7963000011","treeId":"527cdd9e0fdd17e72500043b","seq":1,"position":3,"parentId":null,"content":"##About CA MDM\nCA Mobile Device Management (MDM) is an enterprise solution for securing and managing mobile users, devices, applications, and content (data) with your enterprise policies."}],"tree":{"_id":"527cdd9e0fdd17e72500043b","name":"CA Business Intelligence Integration for CA MDM","publicUrl":"ca-business-intelligence-integration-for-ca-mdm"}}