Abount Us > Customers

Customers

AAPT

AAPT

Accord Alliance

AccordAlliance

Adesa

adesa

Advaliant

Advaliant
  • Business Intelligence
  • Integration of Salesforce with Clarify
  • Daily feed of automobile resale availability data to Salesforce
  • Integration of Salesforce and SAP

AlarmPoint Systems

AlarmPointSystems

Align Technology

AlignTechnology

American Advisors Group

AmericanAdvisorsGroup

American Civil Liberties Union

AmericanCivilLibertiesUnion
  • Data Migration from GoldMine to Salesforce
  • Salesforce Business Intelligence Data Warehouse
  • Daily load of sales data from JD Edwards to Salesforce for sales visibility

American Medical Systems

AmericanMedicalSystems

Anthony Robbins

anthonyrobbins

Aritas

aritas

Banco Cetelem

BancoCetelem
  • GoldMine Data Migration to Salesforce

Barrie + Hibbert

barriehibbert

Bay Fireworks

BayFireworks

BazzaarVoice

Bazaarvoice

BetterWorld Books

betterworldbooks
  • QuickBooks integration with Salesforce

BioMarin Pharmaceutical

biomarin

BlackHawk Network

BlackHawk

BlueCoat Systems

BlueCoat

Bottomline Technologies

bottomline
  • Customer service portal integration with Salesforce

Bridgewater Associates

BridgeWaterAssociates

BTI

bti

Burgundy Asset Management

BurgundyAssetMngmt

Business Objects

BusinessObjectsLogo
  • Bidirectional integration with Salesforce and legacy systems
  • Salesforce Business Intelligence Data Warehouse
  • Customer Service Portal Integration with Salesforce
  • Legacy Data Migration to Salesforce
  • Data Cleansing
  • Lead Management + Assignment
  • Data Integration
  • Business Intelligence Warehouse

CaloryCoach

calorycoach
carlzeiss

Carl Zeiss Vision

Causeworx

Causeworx

CenterMotivationChange

Center for Motivation and Change

  • Ecommerce web site integration with Salesforce

CHG Healthcare Services

chghealthcare

Cisco Systems

cisco

ClaimVantage

ClaimVantage

Clarcor

ClarcorIndustrialAir
  • Salesforce Integration
  • Salesforce Business Intelligence Data Warehouse

Control Group

ControlGroup

Covenant Theological Seminary

CovenantTheologicalSeminary

Coyote Systems

CoyoteLogistics

Crushpad

crushpad
  • CRUSHNET Web Site Integration with Salesforce

DecisionView

DecisionView

Deutsche Bank

DeutscheBank

Digium

digium

DiscoveryCommunications

DiscoveryCommunications
  • ETL Data Integration with Clinical Trials vendor application
  • Salesforce Data Integration
  • Salesforce Backup and Recovery

DreamBuilder

DreamBuilder

DRB Capital

DrbCapital

Drexel University

Drexel

Duquesne Light

DuquesneLightCo
  • Salesforce Data Integration with Real Estate Lending service
  • Salesforce Business Intelligence Data Warehouse
  • NetSuite Compliance Backup
  • NetSuite Reporting

Deutsche Asset & Wealth Management

DWS

ebrary

ebrary

Élogos

elogos

EMC Backup and Recovery Systems

emc
  • Salesforce Data Integration with Web Site

Gen-I

gen-i

GLG Research

glgroup

Global Exchange

GlobalExchange

goAuPair

GoAuiPair
  • Salesforce Business Intelligence Data Warehouse
  • Salesforce Data Migration
  • Salesforce & QuickBooks integration
  • Ecommerce Web Site Integration with Salesforce

Employers Direct Insurance

EmployersDirect

Enernoc

enernoc

ERT

eResearchTechnology

E-Source

ESource
  • QuickBooks Integration with Salesforce

Fresenius Medical Care

FreseniusMedicalCare

Freshnails

freshnails

Finance Authority of Maine

FinanceAuthorityofMaine

General Electric

ge
  • Ecommerce Web Site Integration with Salesforce

Goodwill of San Francisco, San Mateo, and Marin

goodwill

Greenlight Marketing

greenlight

Hacker Group

HackerGroup

HomeAway

HomeAway

iconectiv

iconenctiv

illumina

illumina

Imperial Finance & Trading

imperialfinance

InfoJobs

InfoJobs
  • NetSuite Compliance Backup
  • NetSuite Reporting
  • Corporate Data Warehouse Business Intelligence Reporting
  • Daily load of sales data from JD Edwards to Salesforce for sales visibility

Informa

Informa

Infusionsoft

Infusionsoft

InsightSoftware.com

InsightSoftware

Insulet

insulet
  • GoldMine Data Migration to Salesforce
  • Salesforce Business Intelligence Data Warehouse
  • NetSuite Compliance Backup
  • NetSuite Reporting
  • Salesforce Business Intelligence Data Warehouse
  • Saleforce Business Intelligence Data Warehouse
  • Salesforce Compliance backup

Junior States of America

Junior States of America

Kaiser Permanente

KaiserPermanente

Kareo

Kareo

King Systems

kingsystems
  • Ecommerce Site Integration with Salesforce
  • Salesforce & QuickBooks integration
  • Salesforce Business Intelligence Data Warehouse
  • Data Integration with Salesforce

Klarna

Klarna

Lava Trading

LavaTrading

MarkaVIP

MarkaVIP

Matrix Medical Network

MatrixMedicalNetwork
  • NetSuite Data Migration
  • NetSuite Compliance Backup
  • NetSuite Reporting

MD7

MD7

Medical Audit & Review Solutions

MedicalAuditReveiwSolutions

Medrisk

MedRisk

Medtronic

medtronic
  • Salesforce Compliance Backup

Millennium Trust

MillenniumTrust

MoldFlow

MoldFlow

Monumental Sports & Entertainment

MonumentalSports&Entertainment

Morehead

morehead

Morrison Utility Service

morrisonutility

NCS Technology

NCS Technologies

NEC Financial Services

NECFinancialServices

Network Appliance

NetworkAppliance
  • Salesforce Business Intelligence Data Warehouse
  • Excel integration with Salesforce
  • Salesforce Integration with SAP
  • ACT Data Migration to Salesforce

Neverblue

Neverblue

Nutanix

Nutanix

NorthWest Evaluation Association

NorthWest Evaluation Association

Oracle

oraclesml
  • NetSuite Data Archive

Otterbox

otterbox

Overby-Seawell

Overby-SeawellCompany

Oxfam Canada

OxfamCanada

Paychex

paychex
  • NetSuite Data Archive

Pernod Ricard

PernodRicard

Procter & Gamble

pg

PRA International

PRAInternational

Precept Ministries

PreceptMinistries

Quantcast

quantcast

Rackspace

Rackspace

RedHat / JBoss

RedHat

Regent Exhibitions

RegentExhibitions
  • Customer Service Portal Integration with Salesforce

Regent Seven Seas Cruises

RegentLuxuryGroup

Ritchie Bros.

RitchieBros.Auctioneers

Anthony Robbins

RobinsResearchInternational

Rocket Software

RocketSoftware

RoundCorner

RoundCorner

SAI Global

SaiGlobal

Saint Leo University

SaintLeoUniversity

Santia

santia
  • GoldMine Data Migration to Salesforce

Securities and Exchange Commission

sec

Severstal

SeverstalNorthAmerica

Sociedad Digital de Autores y Editores

SGAE

Sirsi Synix

sirsidynix
  • Customer Service Portal Integration with Salesforce

Sitech Norcal

sitech

J.M. Smucker

smuckers

Solar City

solarcity

Solar Winds

SolarWinds
  • NetSuite Integration

Sony Pictures

SonyPIctures

Sovereign

Sovereign

Standard Life

standardlife

The Star Ledger

StarLedger
  • ETL Data Integration with Corporate Data Warehouse

Starmount Life Insurance

StarmountLifeInsurance

The Student Conservation Association

studentconservation

Summit Business Media

SummitProfessionalNetworks

Sun Trust

SunTrust

Symantec

Symantec

Target-X

targetsml

Teneros

Teneros

Taylor-Wharton International

taylorwharton
  • College Student Recruiting Application Integration with Salesforce
  • ETL Data Integration with Salesforce
  • Salesforce Integration with NetSuite

Tintri

Tintri

TouchTunes

touchtunes

Travel Acquisition Group

TravelAcquisitionGroup

Travelex

Travelex
  • Salesforce org clone
  • GoldMine Data Migration to Salesforce

Trip Advisor

TripAdvisor

Triple P International

TriplePINternational

UltraLife

UltraLifeCorporation

Union Rescue Mission

unionrescuemission
  • NetSuite Compliance Backup
  • NetSuite Reporting

Unlimited Technology Solutions

UnlimitedTechnologySolutions

Universidad de Navarra

unversidaddenavarra

UPC NL

upc

ultimatemarket

InnorosOy
  • Salesforce Data Integration
  • Ecommerce Web Site Integration with Salesforce

USA Cares

usacares

Van Eck Global

VanEckGlobal

Greenway Health

Greenway

VoiceWare

voiceware

Cisco WebEx

webex

Watchfire

Watchfire

WGBH

WGBHEducationalFoundation

Wired Triangle

WiredTriangle
  • Data Migration from one Salesforce instance to another

World Economic Forum

WorldEconomicForum

eBay

ebay

amazon.com

amazon
  • Salesforce org split due to divestiture.

ETL Data Integration & Data Replication Projects

Financial Reporting – ETL Data Integration & Replication – Database to Database

Business Objects – Reporting and Complex Integration

business-objects-reference

Challenge

  • Reporting system developed using internal resources was unreliable, lacked internal technical support, and used obsolete API version
  • This vendor wanted to use their own BI tools on Salesforce.com data
  • Integrations with legacy SFA systems developed using internal resources were unreliable, lost data, and jeopardized lead generation. Leads routinely lost or misrouted to wrong sales reps.
  • Conversion of massive amounts of legacy data for new Salesforce.com rollout had to be done in one weekend, reliably and accurately, with no data loss.
  • Multiple integrations with PeopleSoft and marketing databases required
  • Territory realignment and data cleansing
  • Powerful lead routing required that was far beyond what Salesforce.com lead assignment offered

Solution

  • Relational Junction
  • Salesforce.com data replication to Oracle database with Relational Junction for Salesforce
  • ETL from web lead system to feed 5,000 new leads a day into Salesforce.com
  • ETL from PeopleSoft into Relational Junction database for lead assignment metadata
  • ETL from PeopleSoft HR system to create all Salesforce.com users
  • Integration with OneSource marketing database to add demographic fields to new leads
  • Back-end database programming for bolt-on functionality, including lead assignment, lead scoring, territory management

Results

  • 2,000 Salesforce.com users up and running in two rollouts (Americas in 2005, EMEA in 2007)
  • Consistent view of Salesforce data in a reporting database that is current within 5 minutes
  • Able to use their own reporting products
  • Entire company uses Salesforce.com data in an integrated, seamless manner
  • Sophisticated lead management capabilities developed in days, including matching to existing accounts, territory and sales rep assignments

Financial Reporting – ETL Data Integration & Replication – Database to Database

Cisco Systems – Reporting & Integration

cisco-refernce

Challenge

  • Was using Salesforce.com DB Replicator tool for mission critical reporting warehouse. DB Rep does not support current API and was discontinued in Jan 2006. DBRep also will not handle tables with millions of rows, since it is subject to timeouts with large datasets on the initial load.
  • Internal development and integration teams needed multiple sand box environments with monthly refresh.

Solution

  • Relational Junction
  • Salesforce.com data replication to Oracle database for reporting and various integration projects.
  • Relational Junction used to build a second Salesforce.com org for integration team. Sesame developed new features in the product to support an org clone process that will copy 10 GB in 2 days.

Results

  • Consistent and current view of Salesforce data for reporting
  • Integration developers have their own Salesforce.com site
  • Stable, supported, scalable solution

Financial Reporting – ETL Data Integration & Replication – Database to Database

General Electric – Compliance & Reporting

Challenge

  • Compliance issues include
  • Backup of Salesforce to local database
  • Auditing
  • Disaster recovery
  • Recovery of lost Salesforce data
general-electric

Solution

  • Using Relational Junction for Salesforce specifically for data replication/auditing and disaster recovery.
  • In case SFDC has catastrophic failure
  • ETL tool for Data warehousing
  • Robust History tracking

Results

  • Consistent view of Salesforce data in a reporting database.
  • Satisfies disaster recovery needs
  • Can recover lost data records if deleted from Salesforce
  • Full audit trail of all changes to all records in the database
  • Able to use current reporting tool set

Financial Reporting – ETL Data Integration & Replication – Database to Database

Deutsche Bank – Integration

bankofgermany-reference

Challenge

  • Integrate Customer information contained within Salesforce.com and deposit

Solution

  • Relational Junction
  • Salesforce.com data replication to a Sybase operational data store
  • Relational Junction ETL integration with back-office systems

Results

  • Relational Junction provides an interface to the deposit accounting system, enabling customer service representatives to see important customer data in the Salesforce.com user interface.
  • Included other operational system’s data into Salesforce by sourcing from custom built data warehouse.
  • Backup and restore capability of Salesforce data, which has already proven invaluable in recovering lost data
  • Two divisions have adopted Relational Junction , one in New York, the other in Germany.

Financial Reporting – ETL Data Integration & Replication – Database to Database

Paychex – Reporting & Integration

paychex-reference

Challenge

  • The Salesforce.com API used to generate reports is slow and cumbersome, especially with our data volumes
  • Difficulty in finding people with technical abilities in SOAP, Web Services, and knowledge of Salesforce API, which are all required to write applications directly against Salesforce.com
  • CRM integration of different platforms continues, and the volume of data increases over time
  • Bi-directional functionality required to support future migrations of data to Salesforce
  • A strategic replacement of home-grown application needed to replace daily feeds to Salesforce
  • Need ability to support drill-downs or merging with data warehouse relational data stores
    Salesforce reporting not adequate

Solution

  • Relational Junction for Salesforce for Salesforce.com replication
  • Relational Junction ETL Manager for Salesforce.com replication
  • Salesforce.com data replication to a relational database
  • Custom integration using Relational ETL with existing custom and package solutions., using the Relational schema as a bridge.

Results

  • Consistent view of customer data in internal systems an in Salesforce.com
  • Flexibility to plug in best of breed applications as well as home-grown systems
  • Minimal investment in resources
  • Rock-stable and reliable integrated systems.

Salesforce ETL Data Integration & Replication

CrushPad Wine – CRUSHNET Web Site Integration

enernoc-new

Challenge

  • Crushpad is a San Francisco wine company that uses Salesforce.com for its CRUSHNET online community for winemaking web site. Needed web site integration with Salesforce.com to provide a Customer facing experience and an operational capability on the same data for internal support and sales staff
  • Salesforce API was complex, slow, and not 100% available for the volume and performance required.
  • Development costs and operational considerations made it impossible to interface the web site to Salesforce.com directly.

Solution

  • Relational Junction
  • Bi-directional replication of Salesforce.com data between the web site’s MySQL database and Salesforce.com
  • Using Salesforce.com as a data modeling tool as well as an operational interface
  • Customer-facing web site uses php programs, completely vendor-neutral solution

Results

  • Consistent view of Salesforce data with the customer web site
  • Development time and complexity drastically reduced
  • 100% reliability
  • Very high performance
  • Full integration with Salesforce.com without operational dependencies

Salesforce ETL Data Integration & Replication

EnerNOC – Reporting and Integration

enernoc-new (1)

Challenge

  • EnerNOC, Inc. is a leading developer and provider of clean and intelligent power solutions to commercial, institutional, and industrial customers, as well as electric power grid operators and utilities. Technology-enabled demand response and energy management solutions help optimize the balance of electric supply and demand.
  • Provide integration of Customer information contained within Salesforce.com and various internal systems to support real-time customer service and alerts.
  • Provide a Business Intelligence reporting platform on a relational database
  • Calculate financials from data within Salesforce and integrate customers, payables, and receivables with Epicor financial system.

Solution

  • Relational Junction
  • Salesforce.com data replication for reporting warehouses
  • Integration with internal applications using SQL database technology
    Integration with Epicor ERP system for financial

Results

  • Up-to-date information in CRM data provides timely information for business response.
  • Consistent view of Salesforce data in a reporting database.
  • Savings in development and maintenance time using off the self software.

Salesforce ETL Data Integration & Replication

Rackspace Hosting – Integration

rackspace-refernce

Challenge

  • Integrate Customer and asset information contained within Salesforce.com with customer support, incident management, billing, and accounting applications.
    Provide a stable integration platform.

Solution

  • Relational Junction
  • Salesforce.com data replication to a relational database
  • Custom integration using Relational Junction ETL with existing custom and package solutions., using the Relational Junction schema as a bridge.

Results

  • Consistent view of customer data in internal systems an in Salesforce.com
  • Flexibility to plug in best of breed applications as well as home-grown systems.
  • Minimal investment in resources
    Rock-stable and reliable integrated systems

Salesforce ETL Data Integration & Replication

Redhat – Customer Portal

redhat-reference

Challenge

  • Prior to acquisition by RedHat, JBoss needed a high-performance high-availability customer portal. Salesforce API programming did not provide the levels of performance, ease of development, and availability required by heavy web site volume.

Solution

  • Relational Junction
  • Bi-directional integration of JBoss Salesforce.com customer information to a MySQL database.
  • Custom web application using native SQL access to the MySQL database for the JBoss customer portal.

Results

  • Consistent view of customer data in both Salesforce.com and the portal database.
  • Rapid development of a sophisticated customer portal.
  • High performance.
  • High availability.

Salesforce & QuickBooks ETL Data Integration & Replication

goAuPair – Integration and Data Conversion

aupair-refernce

Challenge

  • Unique business needs – goAUPAIR (www.goaupair.com) provides au pairs from foreign countries to American host families.
  • Replace a home-grown system that ran the entire business with Salesforce.com, QuickBooks and new custom-coded portals
  • Implement new functionality over a 6 month period to allow a small IT staff to manage the process in stages, living in both systems during the rollout.
  • Provide a consistent view of customer data that allows complex reporting for government audits
    Replace QuickBooks integration developed by a company that went out of business.

Solution

  • Relational Junction
  • Convert legacy data to Salesforce.com through the Relational Junction warehouse using Relational Junction ETL
  • Provide an architecture platform (Relational Junction warehouse) to allow host families, local area representatives and international representatives to access/update data thru custom developed portals
  • Integrate with legacy system during rollout using both Relational Junction ETL and replication technologies
  • Two-way integration for QuickBooks accounting system where all credit card charges are performed

Results

  • Complete data migration in 2 months
  • On-site back up and accessibility of all data
  • 1-year migration of legacy functions to Salesforce.com, living out of both systems seamlessly
  • Consistent view of Salesforce data in a local database accessible by thousands of remote customers and business partners.
  • Enable updates from portals to be posted to Salesforce.com
    Up and running QuickBooks integration.

Salesforce & QuickBooks ETL Data Integration & Replication

Junior State Of America – Ecommerce Site

junior-state-reference

Challenge

  • Provide a public-facing ecommerce site to recruit new students for education and events.
  • Convert from an ecommerce solution what was no longer meeting our needs.
  • Integration with Salesforce.com so we can manage all this easily.
  • Send completed orders to QuickBooks for invoicing.
  • Receive payments in QuickBooks, post payment status and history to Salesforce.com.

Solution

  • Bi-directional Salesforce.com data replication to a relational database
  • Custom ecommerce web site using Relational Junction Customer Portal and Relational Junction database as a back end.
  • Integration with QuickBooks for processing of all orders and payments.
  • Conversion of six years of relevant data from the legacy system by Sesame’s professional services team.

Results

  • Capture of new customers and orders in public website.
  • Consistent view of customer data in web site and in Salesforce.com
  • Complete customer and order detail in QuickBooks Enterprise, improving our billing and receivables.
  • No loss of critical data from legacy system. Years of data now in Salesforce.
  • Great working relationship with the Sesame team.
LinkedInFacebookGoogle+TwitterShare