Search the wiki


itrezzo Technical Support Wiki

BPE - BlackBerry PIN Extraction

BlackBerry PIN Extraction (BPE)

BlackBerry PIN Extraction (BPE) is an itrezzo feature which reads the BlackBerry Enterprise Server database to extract critical contact information. The information gathered will be used by the itrezzoAgent EPS process to allow an organization to automatically push out updates when a handheld device is added, modified, or removed from the BES server.

The BlackBerry handheld is definitely an indispensable business gadget, as it allows the exchange of instant information among thousands of people -- sending e-mails and communicating with business partners, customers, colleagues, and other business stakeholders in the most efficient way. Gadgets that provide such great benefits are widely-used and very much valued by business people. For BlackBerry users, these facilities are available in almost all BlackBerry handhelds regardless of their underlying wireless network layer.

PIN-to-PIN messaging does not require an email server or a BlackBerry server. Instead, messages are relayed through the available wireless infrastructure and then directly delivered to another handheld. This design allows messages to be delivered with fewer dependencies and reduced latency. A confirmation to the sender that the message has been delivered to the recipient's handheld is also sent.

The challenge of effective PIN-to-PIN messaging is to ensure that co-worker PINs are kept current in each BlackBerry address book. For instance, if a contact is not part of a list, itrezzo EPS will still update the correct PIN for the respective user. In the event that a user transfers his/her BlackBerry to another staff member for example, it can be very distressing when a PIN message is accidentally delivered to the wrong person. The itrezzoAgent EPS contact process will clear PINs for users who no longer have a BlackBerry.

BES Connector Configuration

  1. Open the itrezzoAgent Administrator
  2. Right-click the BES Configuration Folder
  3. Select 'Add Connector' and then choose your version of BES. (Options are SQL BES 4.0 and up; Mailbox BES 3.6)
  4. Enter the Server Name or IP of the server where the BES database is stored
  5. Enter the Database Name (Default is BESmgmt)
  6. Choose your Security logon. This can utilize the integrated itrezzo logon (itrezzo service account) or you may use an SQL Server Authentication logon.
  7. Use the 'Test' button to confirm that the information provided is accurate and connects to the database.
  8. Click on the Push Server tab
  9. A push server may already be present; if it is not then hit 'Refresh List'. This should populate a push server for you. If it does not then your BES server may not be configured as a push server. If this is the case then please refer to the Mandatory Browser Channel portion of the Wiki.
  10. Select 'OK'

Note: You can verify your Server Name, Database name, and type of authentication to use by opening the Blackberry Server Configuration Panel located on the BES server.

You may view screenshots of this process here.

itrezzoAgent Server Configuration

  1. Select the 'Servers' folder within the itrezzoAgent Administrator
  2. Right-click or double click on your server shown on the right hand side of the itrezzoAgent Admin
  3. Select the BPE tab
  4. Uncheck Retrieve PIN data from BES
  5. Select 'OK'

Running BPE and Confirming Successful Run

  1. Right-click your server found on the right side of the itrezzoAgent Admin
  2. Select 'Run BPE Now'
  3. Active tasks should show activity
  4. When BPE completes, the technical contact for itrezzo will receive a notification that BPE has completed.
  5. Select and expand the 'Asset Management – BPE' folder
  6. Select 'Handheld Inventory'

When the user selects 'Handheld Inventory', all devices which were found in the BES database will be listed. On the bottom right hand corner of the itrezzoAgent Administrator, the user will see the total number of Blackberry devices found. Please confirm that this number matches what is to be expected.

Sending Handheld Inventory Records to Public Folder

The user can send handheld inventory records to a Public Folder. There are two ways to doing this:

  • It is possible to send the output of an MCL to a Public Folder.
  • The user can also re-home the BPE asset handheld inventory to appear in a Handhelds Public Folder.

The last one is the ideal method because the content and views are very complete.

For next steps, see Handhelds Public folder setup and Installation of HHPF View in Outlook.


If the 'failed to connect' message appears when testing the BPE connection, several troubleshooting steps can be used: 

Failed SQL Connection

Failed SQL Connection

  1. Verify the Server Name, Database Name and Authentication type found on the BES Server under Blackberry Server Configuration
  2. Verify itrezzo service account permissions to the BES Database.
    • If for some reason you think this may be a permissions issue and would want to test, it would be easiest to add the itrezzo service account as a local administrator to the server which is home to the BES SQL Database. This will allow for full permissions and you may then re-test your connection.
  3. Verify that the BES Server is TCP/IP enabled
    • On the server which contains the BES SQL Database, go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
    • Run the SQL Server Network Utility (SVRNETCN)
    • Select the dropdown menu for instances on the server to be certain you are on the correct instance.
      • If TCP/IP is in the enabled category then you are all set
      • If TCP/IP is NOT enabled then please enable it and select 'OK'
    • Restart SQL Server if a change has been made
    • Retest SQL Connector on the itrezzoAgent Administrator

itrezzo Support Wiki version See the itrezzo web site or the itrezzo blog site to learn about contact management on your smartphone.

The Trademark RIM® BlackBerry® Smartphone and BlackBerry® Enterprise Solution is owned by Research In Motion Limited and is registered in the United States and may be pending or registered in other countries. The owner of this wiki site is not endorsed, sponsored, affiliated with or otherwise authorized by Research In Motion Limited.

Microsoft Outlook, Microsoft Exchange Server, Microsoft Active Directory, Microsoft Windows Mobile are trademarks of Microsoft.