Category Archives: Company Update

Wedid: Salesforce and Rent.com.au Portal

Challenges

All real estate listings reside in Salesforce. However, these listings need to be consistently updated to the website portal to truly reflect the availability and pricing information (to name a few). The major challenges are:

  • too many listings to keep track of the status and update to the portal
  • listings get updated too frequently causing timing issue

Solution:

Purpose Synchronise listing information from Salesforce to designated Rent.com.au portal path for retrieval
Applications Salesforce
FTP – Rent.com.au Portal
Tool Dell Boomi Atomsphere
Information Salesforce Listing > Rent.com.au FTP Server
Data Formats XML
Volumes ~100
Process Any listings that are created/updated will be synced to Rent.com.au FTP server as zipped file containing listings in XML format.
Schedule Every 10 mins
Complexity Medium

 

Wedid: Salesforce and allhomes (allhomes.com.au) Portal

Challenges

All real estate listings reside in Salesforce. However, these listings need to be consistently updated to the website portal to truly reflect the availability and pricing information (to name a few). The major challenges are:

  • too many listings to keep track of the status and update to the portal
  • listings get updated too frequently causing timing issue

Solution:

Purpose Synchronise listing information from Salesforce to designated allhomes portal path for retrieval
Applications Salesforce
FTP – allhomes Portal (allhomes.com.au)
Tool Dell Boomi Atomsphere
Information Salesforce Listing > allhomes FTP Server
Data Formats XML
Volumes ~100
Process Any listings that are created/updated will be synced to allhomes FTP server as zipped file containing listings in XML format.
Schedule Every 10 mins
Complexity Medium

 

Wedid: Salesforce and Homehound (homehound.com.au) Portal

Challenges

All real estate listings reside in Salesforce. However, these listings need to be consistently updated to the website portal to truly reflect the availability and pricing information (to name a few). The major challenges are:

  • too many listings to keep track of the status and update to the portal
  • listings get updated too frequently causing timing issue

Solution:

Purpose Synchronise listing information from Salesforce to designated Homehound portal path for retrieval
Applications Salesforce
FTP – Homehound Portal (homehound.com.au)
Tool Dell Boomi Atomsphere
Information Salesforce Listing > Homehound FTP Server
Data Formats XML
Volumes ~100
Process Any listings that are created/updated will be synced to Homehound FTP server as zipped file containing listings in XML format.
Schedule Every 10 mins
Complexity Medium

 

Wedid: Salesforce and REA (realestate.com.au) Portal

Challenges

All real estate listings reside in Salesforce. However, these listings need to be consistently updated to the website portal to truly reflect the availability and pricing information (to name a few). The major challenges are:

  • too many listings to keep track of the status and update to the portal
  • listings get updated too frequently causing timing issue

Solution:

Purpose Synchronise listing information from Salesforce to designated REA portal path for retrieval
Applications Salesforce
FTP – REA Portal (realestate.com.au)
Tool Dell Boomi Atomsphere
Information Salesforce Listing > REA FTP Server
Data Formats XML
Volumes ~100
Process Any listings that are created/updated will be synced to REA FTP server as zipped file containing listings in XML format.
Schedule Every 10 mins
Complexity Medium

 

Wedid: Salesforce and CampaignTrack (Agent, Listing)

Challenges

The customer uses Salesforce contact to track office staff information whereas CampaignTrack for all marketing information. Any information in Salesforce relating to the staff and opportunity will need to be created to CampaignTrack in real time. This proves difficult for manual handling, hence, a process automation needs to be in place.

Solution:

 

Purpose Synchronise information from Salesforce Contact and Opportunity to CampaignTrack as Agent and Listing in real time.
Applications Salesforce
CampaignTrack
Tool Dell Boomi Atomsphere
Information Salesforce Contact > CampaignTrack Agent
Salesforce Opportunity > CampaignTrack Listing
Data Formats XML
Volumes ~30
Process Any contacts that are created/updated will be synced to Campaign Track in real time.
Any opportunities that are created/updated will be synced to Campaign Track in real time.
Schedule Real-time
Complexity Medium

 

Wedid: Salesforce and RentalPoint

Challenges

Customer is facing a challenge to incorporate company data between the applications they use. Client data and sales are managed in Salesforce while rental bookings reside in RentalPoint. Repetitive manual data entries need to be done to keep client and sales data aligned between the applications. For every bookings done in RentalPoint, it needs to relate to the sales in Salesforce.

Solution:

Purpose Automatically synchronise Salesforce Account/Contact to RentalPoint as Customer/Contact and also RentalPoint Bookings to Salesforce Opportunity.
Applications Salesforce
RentalPoint v10
Tool Talend
Information Salesforce Account > RentalPoint Customer
Salesforce Contact > RentalPoint Contact
RentalPoint Booking > Salesforce Opportunity
Data Formats XML
Volumes ~50
Process Newly created account/contact will be synced to RentalPoint as customer/contact.
Any bookings with Heavy Pencil/Confirmed/Cancelled with a given type will be created to Salesforce as opportunity.
Schedule Every 30 mins
Complexity Simple

 

Integrating to RentalPoint

 

URL http://www.rentp.com
Description Software for event driven rental business
API SQL Server Management Studio
Trial Version with API Access No
Data Format Database MSSQL
Authentication RentalPoint user and password authentication
API Limits No limit
Sample Use Case Salesforce Account/Contact > Create/Update > RentalPoint Customer/Contact
RentalPoint Booking > Create/Update > Salesforce Opportunity
F2I 3/5
Objects/Operations

rentalPoint-table

 

Boomi Basic 101: The SQL Lookup

When transforming data through map, there may be situation where you need to query some information from a specific record (i.e. from source) and to map it for the destination.

If you need to perform query from a specific instance (i.e. Salesforce), you can do so by utilizing the Connector Call function.

connector_call

If you are trying to retrieve information from a  database instead, you may not be able to see the Database option available in the connector list!

Don’t be panic, as you can still query database table information via the SQL lookup function available in the lookup category:

sql_lookupl

Boomi – System Command Shape Tips

Last time, we discussed about the usage of Program Command shape in Boomi. The shape is very useful especially it allows us to invoke a system command/shell script from a Boomi process. However, did you know that the shape will use the system command exit code to determine the status?

0 – success
1 – fail

This will not work correctly if you want to execute a system command that has different exit code than the standard one.

For example, the Robocopy in Windows uses different exit code (e.g, 1) other than 0 to indicate a success copy operation. This will cause an error execution in Boomi. To overcome this, you can write a system command script to alter the exit code to make it compatible with Boomi Program Command shape:

ehco off
robocopy D:from D:to filetocopy.txt /is
IF %ERRORLEVEL% EQU 1 (
exit 0
) ELSE IF %ERRORLEVEL% EQU 0 (
exit 0
) ELSE (
exit 1
)