Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Use a data connector to import and archive financial services email data from the Bloomberg Message collaboration tool. After you set up and configure a connector, it connects to your organization's Bloomberg secure FTP (SFTP) site once every day, and imports email items to mailboxes in Microsoft 365.
After storing Bloomberg Message data in user mailboxes, you can apply Microsoft Purview features such as Litigation hold, content search, In-place archiving, auditing, Communication compliance, and Microsoft 365 retention policies to Bloomberg Message data. For example, you can search Bloomberg Message emails by using the content search tool or associate the mailbox that contains the Bloomberg Message data with a custodian in an eDiscovery (Premium) case. Using a Bloomberg Message connector to import and archive data in Microsoft 365 can help your organization stay compliant with government and regulatory policies.
Overview of archiving Bloomberg Message data
The following overview explains the process of using a connector to archive Bloomberg Message data in Microsoft 365.
Your organization works with Bloomberg to set up a Bloomberg SFTP site. You also work with Bloomberg to configure Bloomberg Message to copy email messages to the Bloomberg SFTP site.
Every 24 hours, Bloomberg Message copies email messages to the Bloomberg SFTP site.
The Bloomberg Message connector that you create in the Microsoft Purview portal connects to the Bloomberg SFTP site every day and transfers the email messages from the previous 24 hours to a secure Azure Storage area in the Microsoft Cloud.
The connector imports the email message items to the mailbox of a specific user. A new folder named BloombergMessage is created in the specific user's mailbox and the items are imported to it.
The connector uses the value of the CorporateEmailAddress property. Every email message contains this property, which is populated with the email address of every participant of the email message. In addition to automatic user mapping by using the value of the CorporateEmailAddress property, you can also define a custom mapping by uploading a CSV mapping file. This mapping file contains a Bloomberg UUID and the corresponding Microsoft 365 mailbox address for each user in your organization. If you enable automatic user mapping and provide a custom mapping, for every email item the connector first looks at the custom-mapping file. If it doesn't find a valid Microsoft 365 user that corresponds to a user's Bloomberg UUID, the connector uses the CorporateEmailAddress property of the email item. If the connector doesn't find a valid Microsoft 365 user in either the custom-mapping file or the CorporateEmailAddress property of the email item, the item won't be imported.
Before you set up a connector
Some of the implementation steps for archiving Bloomberg Message data are external to Microsoft 365. You must complete these steps before you create the connector in the compliance center.
To set up a Bloomberg Message connector, you need keys and key passphrases for Pretty Good Privacy (PGP) and Secure Shell (SSH). Use these keys to configure the Bloomberg SFTP site. The connector uses these keys to connect to the Bloomberg SFTP site and import data to Microsoft 365. Use the PGP key to configure the encryption of data that's transferred from the Bloomberg SFTP site to Microsoft 365. Use the SSH key to configure secure shell to enable a secure remote authentication when the connector connects to the Bloomberg SFTP site.
When setting up a connector, you can use public keys and key passphrases provided by Microsoft or use your own private keys and passphrases. We recommend that you use the public keys provided by Microsoft. However, if your organization already configured a Bloomberg SFTP site by using private keys, you can create a connector by using these same private keys.
Subscribe to Bloomberg Anywhere. This subscription is required so that you can sign in to Bloomberg Anywhere to access the Bloomberg SFTP site that you set up and configure.
Set up a Bloomberg SFTP (Secure file transfer protocol) site. After working with Bloomberg to set up the SFTP site, data from Bloomberg Message is uploaded to the SFTP site every day. The connector you create in Step 2 connects to this SFTP site and transfers the email data to Microsoft 365 mailboxes. SFTP also encrypts the Bloomberg Message data that is sent to mailboxes during the transfer process.
For information about Bloomberg SFTP (also called BB-SFTP):
See the "SFTP Connectivity Standards" document at Bloomberg Support.
Contact Bloomberg customer support.
After you work with Bloomberg to set up an SFTP site, Bloomberg provides some information to you after you respond to the Bloomberg implementation email message. Save a copy of the following information. You use it to set up a connector in Step 3.
Firm code, which is an ID for your organization and is used to sign in to the Bloomberg SFTP site.
Password for your Bloomberg SFTP site
URL for Bloomberg SFTP site (for example, sftp.bloomberg.com). In addition, Bloomberg might also provide a corresponding IP address for the Bloomberg SFTP site, which you can also use to set up the connector.
Port number for Bloomberg SFTP site
The Bloomberg Message connector can import a total of 200,000 items in a single day. If there are more than 200,000 items on the SFTP site, none of those items are imported to Microsoft 365.
The user who creates a Bloomberg Message connector in Step 3 (and who downloads the public keys and IP address in Step 1) must be assigned the Data Connector Admin role. This role is required to add connectors on the Data connectors page in the Microsoft Purview portal. This role is added by default to multiple role groups. For a list of these role groups, see Roles in Microsoft Defender for Office 365 and Microsoft Purview compliance. Alternatively, an admin in your organization can create a custom role group, assign the Data Connector Admin role, and then add the appropriate users as members. For instructions, see:
Set up a connector by using public keys
The following steps show you how to set up a Bloomberg Message connector by using the public keys for Pretty Good Privacy (PGP) and Secure Shell (SSH).
Step 1: Obtain PGP and SSH public keys
First, get a copy of the PGP and SSH public keys. You use these keys in Step 2 to set up the Bloomberg SFTP site so it allows the connector (that you create in Step 3) to connect to the SFTP site and transfer the Bloomberg Message email data to Microsoft 365 mailboxes. You also get an IP address in this step, which you use when configuring the Bloomberg SFTP site.
Sign in to the Microsoft Purview portal.
Select Settings > Data connectors.
Select My connectors, then select Add connector.
From the list, choose Bloomberg Message, select View.
On the Bloomberg Message product description page, select Add connector.
On the Terms of service page, select Accept.
On the Add credentials for content source page, select I want to use PGP and SSH public keys provided by Microsoft.
Under step 1, select the Download SSH key, Download PGP key, and Download IP address links to save a copy of each file to your local computer.
These files contain the following items that you use to configure the Bloomberg SFTP site in Step 2:
PGP public key: Use this key to configure the encryption of data that's transferred from the Bloomberg SFTP site to Microsoft 365.
SSH public key: Use this key to configure secure shell to enable a secure remote authentication when the connector connects to the Bloomberg SFTP site.
IP address: Configure the Bloomberg SFTP site to accept connection requests from this IP address. The same IP address is used by the Bloomberg Message connector to connect to the SFTP site and transfer Bloomberg Message data to Microsoft 365.
Select Cancel to close the workflow. You come back to this workflow in Step 3 to create the connector.
Step 2: Configure the Bloomberg SFTP site
Note
If your organization previously set up a Bloomberg SFTP site to archive Instant Bloomberg data by using public PGP and SSH keys, you don't need to set up another one. You can specify the same SFTP site when you create the connector in Step 3.
Use the PGP and SSH public keys and the IP address that you got in Step 1 to configure PGP encryption and SSH authentication for the Bloomberg SFTP site. This configuration lets the Bloomberg Message connector that you create in Step 3 connect to the Bloomberg SFTP site and transfer Bloomberg Message data to Microsoft 365. You need to work with Bloomberg customer support to set up your Bloomberg SFTP site. Contact Bloomberg customer support for assistance.
Important
Bloomberg recommends that you attach the three files that you download in Step 1 to an email message and send it to their customer support team when working with them to set up your Bloomberg SFTP site.
Step 3: Create a Bloomberg Message connector
In this step, you create a Bloomberg Message connector in the Microsoft Purview portal. The connector uses the information you provide to connect to the Bloomberg SFTP site and transfer email messages to the corresponding user mailboxes in Microsoft 365.
Sign in to the Microsoft Purview portal.
Select Settings > Data connectors.
Select My connectors, then select Add connector.
Choose Bloomberg Message from the list.
On the Terms of service page, select Accept.
On the Add credentials for content source page, select I want to use PGP and SSH public keys provided by Microsoft.
Under Step 3, enter the required information in the following boxes and then select Validate connection.
- Name: The name for the connector. It must be unique in your organization.
- Firm code: The ID for your organization that is used as the username for the Bloomberg SFTP site.
- Password: The password for your organization's Bloomberg SFTP site.
- SFTP URL: The URL for the Bloomberg SFTP site (for example,
sftp.bloomberg.com). You can also use an IP address for this value. - SFTP port: The port number for the Bloomberg SFTP site. The connector uses this port to connect to the SFTP site.
After the connection is successfully validated, select Next.
On the Define user page, specify the users to import data for.
- All users in your organization. Select this option to import data for all users.
- Only users on Litigation hold. Select this option to import data only for users whose mailboxes are placed on Litigation hold. This option imports data to user mailboxes that have the LitigationHoldEnabled property set to True. For more information, see Create a Litigation hold.
On the Map Bloomberg Message users to Microsoft 365 users page, enable automatic user mapping and provide custom user mapping as required.
Note
The connector imports message items to the mailbox of a specific user. A new folder named BloombergMessage is created in the specific user's mailbox and the items are imported to it. The connector uses the value of the CorporateEmailAddress property. Every chat message contains this property, and the property is populated with the email address of every participant of the chat message. In addition to automatic user mapping using the value of the CorporateEmailAddress property, you can also define custom mapping by uploading a CSV mapping file. The mapping file should contain the Bloomberg UUID and corresponding Microsoft 365 mailbox address for each user. If you enable automatic user mapping and provide a custom mapping, for every message item the connector will first look at custom mapping file. If it doesn't find a valid Microsoft 365 user that corresponds to a user's Bloomberg UUID, the connector will use the CorporateEmailAddress property of the chat item. If the connector doesn't find a valid Microsoft 365 user in either the custom mapping file or the CorporateEmailAddress property of the message item, the item won't be imported.
Select Next, review your settings, and then select Finish to create the connector.
Set up a connector by using private keys
The steps in this section show you how to set up a Bloomberg Message connector by using PGP and SSH private keys. Use this connector setup option if your organization already configured a Bloomberg SFTP site by using private keys.
Step 1: Obtain an IP address to configure the Bloomberg SFTP site
Note
If your organization previously configured a Bloomberg SFTP site to archive Instant Bloomberg data by using PGP and SSH private keys, you don't need to configure another one. You can specify the same SFTP site when you create the connector in Step 2.
If your organization used PGP and SSH private keys to set up a Bloomberg SFTP site, you need to obtain an IP address and provide it to Bloomberg customer support. The Bloomberg SFTP site must be configured to accept connection requests from this IP address. The same IP address is used by the Bloomberg Message connector to connect to the SFTP site and transfer Bloomberg Message data to Microsoft 365.
To obtain the IP address:
Sign in to the Microsoft Purview portal.
Select Settings > Data connectors.
Select My connectors, then select Add connector.
Choose Bloomberg Message from the list.
On the Terms of service page, select Accept.
On the Add credentials for content source page, select I want to use PGP and SSH private keys.
Under step 1, select Download IP address to save a copy of the IP address file to your local computer.
Select Cancel to close the workflow. You come back to this workflow in Step 4 to create the connector.
You need to work with Bloomberg customer support to configure your Bloomberg SFTP site to accept connection requests from this IP address. Contact Bloomberg customer support for assistance.
Step 2: Create a Bloomberg Message connector
After configuring your Bloomberg SFTP site, create a Bloomberg Message connector in the Microsoft Purview portal. The connector uses the information you provide to connect to the Bloomberg SFTP site and transfer email messages to the corresponding user mailboxes in Microsoft 365. To complete this step, have copies of the same private keys and key passphrases that you used to set up your Bloomberg SFTP site.
Sign in to the Microsoft Purview portal.
Select Settings > Data connectors.
Select My connectors, then select Add connector.
Choose Bloomberg Message from the list.
On the Terms of service page, select Accept.
On the Add credentials for content source page, select I want to use PGP and SSH private keys.
Under Step 3, enter the required information in the following boxes and then select Validate connection.
- Name: The name for the connector. It must be unique in your organization.
- Firm code: The ID for your organization that is used as the username for the Bloomberg SFTP site.
- Password: The password for your organization's Bloomberg SFTP site.
- SFTP URL: The URL for the Bloomberg SFTP site (for example,
sftp.bloomberg.com). You can also use an IP address for this value. - SFTP port: The port number for the Bloomberg SFTP site. The connector uses this port to connect to the SFTP site.
- PGP private key: The PGP private key for the Bloomberg SFTP site. Include the entire private key value, including the beginning and ending lines of the key block.
- PGP key passphrase: The passphrase for the PGP private key.
- SSH private key: The SSH private key for the Bloomberg SFTP site. Include the entire private key value, including the beginning and ending lines of the key block.
- SSH key passphrase: The passphrase for the SSH private key.
After the connection is successfully validated, select Next.
On the Define user page, specify the users to import data for.
- All users in your organization. Select this option to import data for all users.
- Only users on Litigation hold. Select this option to import data only for users whose mailboxes are placed on Litigation hold. This option imports data to user mailboxes that have the LitigationHoldEnabled property set to True. For more information, see Create a Litigation hold.
On the Map Bloomberg Message users to Microsoft 365 users page, enable automatic user mapping and provide custom user mapping as required.
Note
The connector imports message items to the mailbox of a specific user. A new folder named BloombergMessage is created in the specific user's mailbox and the items are imported to it. The connector uses the value of the CorporateEmailAddress property. Every chat message contains this property, and the property is populated with the email address of every participant of the chat message. In addition to automatic user mapping using the value of the CorporateEmailAddress property, you can also define custom mapping by uploading a CSV mapping file. The mapping file should contain the Bloomberg UUID and corresponding Microsoft 365 mailbox address for each user. If you enable automatic user mapping and provide a custom mapping, for every message item the connector will first look at custom mapping file. If it doesn't find a valid Microsoft 365 user that corresponds to a user's Bloomberg UUID, the connector will use the CorporateEmailAddress property of the chat item. If the connector doesn't find a valid Microsoft 365 user in either the custom mapping file or the CorporateEmailAddress property of the message item, the item won't be imported.
Select Next, review your settings, and then select Finish to create the connector.
Limits
- Microsoft 365 doesn't support threading for Bloomberg Message email. The system imports individual messages sent to a person, but it doesn't show them in a threaded conversation.