Tag Archives: wedid-integration

We Did: WordPress WooCommerce and Netsuite

Challenges

Customer is hosting a website where visitor are allow to register and login. Visitor and existing users are allow to make purchase through the website too but the transactions and payment would need to be tracked through Netsuite.

Solution:

Purpose To sync product, website users and sales transaction between website (WordPress WooCommerce) and Netsuite
Applications WordPress (WooCommerce)
Netsuite
Versions WordPress
Netsuite
Tool Boomi
Information Netsuite Non-Inventory Sales Item > Woocommerce Product
Woocommerce User > Netsuite Customer
Netsuite Customer > Woocommerce User
Woocommerce Orders > Netsuite Sales Order
Netsuite Sales Order > Woocommerce Orders
Data Formats JSON and XML
Volumes ~100/day
Process When customer register a login through website, customer information needs to be stored in Netsuite as well. When a items are added and maintained in Netsuite, the product needs to be made available in the website for people to purchase. And when customer make a purchase through website, the transaction needs to be in returned tracked in Netsuite for shipping and reporting purposes.
Schedule Every 2 minutes
Complexity Medium

WEDID: ORACLE DATABASE & EQUELLA INTEGRATION

Challenges:

Client wants to sync Oracle database, which contains Active Directory records, to those in Equella so that the users will be granted access to their respective repositories. Client also requested where possible reduce the queries from Equella.

Solution:

db-equella

Purpose Query group members from Oracle and update groups in Equella.
Applications Oracle database
Equella
Tool Dell Boomi Atomsphere
Information DB > Equella
Data Formats XML
Volumes ~100/day
Process DB > Create > Equella
Schedule Every 5 minutes
Complexity Medium

Wedid: Teradata and Salesforce Integration

Challenges

Client is managing support cases and work orders through Salesforce. They would like all entries and its children records to be tracked in Teradata as well.

Solution:

sf2teradata

Purpose Sync any records updates from Salesforce into Teradata
Applications Salesforce.com CRM
Teradata
Versions Salesforce
Teradata
Tool Boomi
Information Salesforce Case > Teradata Tables
Salesforce Custom Object (Work Orders) > Teradata Tables
Data Formats XML
Volumes ~500/day
Process Salesforce Case (and its related record such as Account/Contact/Product) will be created or updated into Teradata respective tables.
Salesforce Work Orders (and its related record such as Customer/Product/Warranty) will be created or updated into Teradata respective tables.
Schedule Hourly
Complexity Medium

 

Wedid: Salesforce and InspectRealEstate (inspectrealestate.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 InspectRealEstate portal path for retrieval
Applications Salesforce
FTP – InspectRealEstate Portal (inspectrealestate.com.au)
Tool Dell Boomi Atomsphere
Information Salesforce Listing > InspectRealEstate FTP Server
Data Formats XML
Volumes ~100
Process Any listings that are created/updated will be synced to InspectRealEstate FTP server as zipped file containing listings in XML format.
Schedule Every 10 mins
Complexity Medium

 

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