Prerequisites for importing data to BMC Remedyforce

Registering at the BMC Communities website

All

You must register at the BMC Communities website to download the job files that are uploaded for you to use for importing data from various data sources.

1. Open https://communities.bmc.com.
2. Click Register.
3. Enter your email address. A confirmation email message from BMC Communities, containing a link to the registration page, is sent to your email address.
4. From the email message that you received from BMC Communities, click the link to validate your email address. You can also copy and paste the link to your browser. The Email Validation Successful page is displayed.
5. On the Create your account page, enter the required information.
6. Select the I agree to these terms and conditions check box, and click Create Account.
7. On the BMC Communities home page, from the Products list, select BMC Remedyforce.
8. On the BMC Remedyforce page, click the Content tab and then click Technical Documentation.
9. Download the BMC Remedyforce Pentaho support ZIP files to your local computer.

Installing the JRE

All

You must install the Oracle Java Runtime Environment (JRE) to run the Pentaho Data Integration tool. You must perform the following steps to install the JRE on a Windows computer.

For Pentaho 6.1, the supported JRE versions are Oracle Java 7 and 8.

1. Open http://www.oracle.com/technetwork/java/index.html.
2. In the Software Downloads section, click Java SE.
3. In the Java Platform, Java Downloads section, click Download JRE.
4. In the Java SE Downloads section, select Accept License Agreement, and in the Download column, click the required .exe file.
5. In the File Download window, click Run.
6. Click Install.

Downloading the Pentaho Data Integration tool

All

The Pentaho Data Integration tool is an open source integration tool that can be used to import data from various data sources to BMC Remedyforce. For more information about using the Pentaho Data Integration tool, see http://wiki.pentaho.com/display/EAI/Spoon+User+Guide.

1. Open http://sourceforge.net/projects/pentaho/files/latest/download?source=files.

2. In the File Download window, click Save.
   The pdi-ce-5.0.1.A-stable.zip file is saved in the location you have specified.

3. Unzip the saved file.
4. In the unzipped pdi-ce-5.0.1.A-stable folder, double-click the data-integration folder.

5. To open the Pentaho Data Integration tool, double-click the Spoon.bat file.

Note: To enable you to use the Pentaho Data Integration tool, you must have the latest version of Java installed on your computer.

• Microsoft System Center Configuration Manager
  
• BMC BladeLogic Client Automation

To enable communication between Pentaho Data Integration tool and Windows authenticated Microsoft SQL server, you must connect both.

1. Log on to Microsoft SQL Server Management Studio.
2. Beside the Security folder, click the plus sign .
3. In the Security folder, right-click the Logins folder, and select New Login.
4. In the Login - New wizard, in the Login name text box, enter your Windows user name.
   The format is <domain name >\<user name >. Enter the logon ID of the domain user of the computer on which the Pentaho Data Integration tool is running.
5. Click the Server Roles option and ensure that the public check box is selected.
6. Click the User Mapping option, select the row that has your SCCM or BMC BladeLogic Client Automation database name, and select the Map check box.
   The Database role membership for <database name > section is displayed.
7. Select the db_datareader check box and ensure that the public check box is selected.
8. Click OK.

Note: By default, SCCM 2007 is installed in Windows authenticated mode. You must configure the steps mentioned in this section to enable communication between Pentaho Data Integration tool and SCCM 2007.

 While importing data from an external source, BMC Remedyforce generates a dateTimeStamp and appends it to the Instance Name value of each CI. The dateTimeStamp ensures that CIs imported to BMC Remedyforce CMDB are unique. However, you can choose not to append the dateTimeStamp to the Instance Name values of CIs by configuring the Staging_SkipInstanceIDSuffix custom setting value. This custom setting is not available by default; you must create it and set its value to True.

Important: If you configure Staging_SkipInstanceIDSuffix custom setting to True, and the Instance Name values of CIs being imported from an external source to BMC Remedyforce CMDB are not unique, the import job does not complete successfully. 

1. Click the Remedyforce Administration tab.

2. On the Home page, click the Application Settings tile, and from the menu, select Custom Settings.
   Alternatively, navigate to Setup > Develop > Custom Settings.

3. In the Action column for Remedyforce Settings, click Manage.
4. On the Custom Setting Remedyforce Settings page, click New.
5. In the Name field, type Staging_SkipInstanceIDSuffix.
6. Skip the Sequence Id field, leaving it blank.

7. In the value field, enter True

8. Click Save.

You must first create KETTLE_HOME environment variable to store the location of the Kitchen.bat file. The Kitchen.bat file is available in the \pdi-ce-4.x.0-stable\data-integration or \pdi-ce-5.0.1.A-stable\data-integration folder.

1. On your desktop, right-click My Computer and select Properties.
2. In the System Properties window, click the Advanced tab.
3. Click Environment Variables.
4. In the System variables section, click New.
5. In the Variable name field, enter KETTLE_HOME.
6. In the Variable value field, enter the complete path of the Kitchen.bat file in your computer, and click OK.
   The Kitchen.bat file is available in the \pdi-ce-4.x.0-stable\data-integration or \pdi-ce-5.0.1.A-stable\data-integration folder.

You need the mysql-connector-java-5.1.23-bin.jar file to establish a connection between Dell KACE Pentaho packages and the Dell KACE server. This file is provided in the Dell KACE package that is available on the BMC Communities website.

 To add the mysql-connector-java-5.1.23-bin.jar file

1. To download the job files from the BMC Communities website, perform one of the following actions:
   • If you are using CMDB 1.0, click https://communities.bmc.com/docs/DOC-21752.
   • If you are using CMDB 2.0, click https://communities.bmc.com/docs/DOC-28433.
2. Unzip the downloaded ZIP file.
3. Copy the mysql-connector-java-5.1.23-bin.jar file to \pdi-ce-5.x.1-stable\data-integration\lib folder.
   

   If you are using Pentaho 4.3 or 4.4, copy the mysql-connectorjava-5.1.23-bin.jar file to the \pdi-ce-4.x.0-stable\dataintegration\libext\JDBC folder.

BMC Atrium Discovery

ADDM 9.0

ADDM 9.0 CMDB 2.0

BMC BladeLogic Client Automation

BBCA

BBCA CMDB 2.0

Dell KACE

DELL KACE

DELL KACE CMDB 2.0

BMC FootPrints Asset Core

FootPrints Asset Core Integration Package

FootPrints Asset Core Integration Package CMDB 2.0

System Center Configuration Manager

SCCM

SCCM CMDB 2.0

BMC Atrium Configuration Management Database (BMC Atrium CMDB)

None

Atrium