Integrate Salesforce using Fiber

Sync your customers' dataFiber pulls data from your customers' Salesforce accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.

→

Fiber

→

postgres-prod

salesforce_accounts

salesforce_leads

Your customers' Salesforce accounts

Your production database

Meet your new integration toolkit: SQLReplace calls to the Salesforce API with an interface you already use. Access the data you need straight from your database.

-- Fetch all the Leads belonging to the Salesforce 
-- account of a particular user. 

SELECT *
FROM fiber.salesforce_lead
WHERE account_id = '{user.salesforce_id}'

-- Fetch all the Leads belonging to the Salesforce 
-- account of a particular user. 

SELECT *
FROM fiber.salesforce_lead
WHERE account_id = '{user.salesforce_id}'

Code

CREATE TABLE fiber.salesforce_lead (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  available JSONB,
  pending JSONB,
  object TEXT,
  connect_reserved JSONB,
  instant_available JSONB,
  issuing JSONB,
  livemode BOOLEAN
)

CREATE TABLE fiber.salesforce_lead (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  available JSONB,
  pending JSONB,
  object TEXT,
  connect_reserved JSONB,
  instant_available JSONB,
  issuing JSONB,
  livemode BOOLEAN
)