Name: FactBranch - Connecting Zendesk to an SQL database
Uploaded: 2020-07-04T17:22:55.000Z
Duration: 5 min 5 s
Description: FactBranch - Connecting Zendesk to an SQL database

Help Desk

Web and Video Conferencing

Customer Support

Cross-Browser Testing

PHP Frameworks

Development

Learning Management

Education

Business Intelligence (BI)

Collaboration

Demand Planning

Enterprise Content Management

Enterprise Feedback Management

Facility Management

Knowledge Management

Payment Facilitation

Enterprise

Accounting

Blockchain Payments

Cryptocurrency Wallets

Hedge Fund

Finance and Accounting

ACA Compliance

Applicant Tracking

Corporate Learning Management

HR Management

Payroll

Talent Intelligence

Talent Management

Workforce Analytics

Workforce Management

Human Resources

Change Management

Cloud Storage

Embedded Database

Endpoint Security

Fraud Detection

Function as a Service (FaaS)

Graph Database

Infrastructure-as-a-Service

Integration Platform as a Service (iPaaS)

Network Attached Storage

Network Performance Monitoring

Object Storage

Privileged Access Management

Rack Servers

Storage as a Service (STaaS)

Technology Business Management

Value Stream Management

Website Hosting

Information Technology

A/B Testing

Account-Based Marketing (ABM)

Ad Serving & Retargeting

All-in-One Marketing

Contact Management

Content Management

Creative Management

Customer Advocacy

Email Marketing

Marketing Automation

Social Media Management

Survey & Forms Building

Translation

Web Analytics

Marketing

Project Management

Video Conferencing

Professional Services

Auction Software

Customer Relationship Management (CRM)

Headless eCommerce

Lead Management

Sales Incentive Compensation Management

Sales

Data-Centric Audit Protection (DCAP)

Database Security

Operational Technology (OT) Security

Security

Aviation

Civil Engineering

Computer-Aided Manufacturing (CAM)

Healthcare Learning Management

Lease Management

Vendor Neutral Archive (VNA)

Vertical-Specific

Find top rated software and services based on in-depth reviews from verified users. 400+ software categories including PaaS, NoSQL, BI, HR, and more.

Boomi

MuleSoft Anypoint Platform

Salesforce

SQL Server Integration Services

Microsoft

SnapLogic

Snaplogic

Skyvia

Devart

Matillion

Oracle Data Integrator (ODI)

Oracle

Informatica PowerCenter (legacy)

Discontinued Products

IBM DataStage

Oracle WebLogic Server

MySQL

PostgreSQL

Dixa

Zendesk Sell

Zendesk Suite

MongoDB

Apollo GraphOS

Google Sheets

Microsoft SQL Server

Fin by Intercom

Stripe Payments

Zendesk Chat

FactBranch is a data integration platform that seamlessly loads and displays customer data from various sources to agents and sales representatives within their support and sales software. According to the vendor, FactBranch caters to businesses of all sizes and is utilized by customer support teams, sales teams, data analysts, business intelligence professionals, and e-commerce companies across different industries.

## Key Features

**Data Integration and Display**: FactBranch integrates with popular support and sales software, such as Zendesk, Dixa, Gmail, Intercom, and Stripe, to load and display customer data to agents and sales representatives.

**Connect Multiple Data Sources**: FactBranch enables businesses to connect and query various data sources, including SQL databases, spreadsheets, and RESTful APIs, allowing the collection of data from multiple systems.

**Easy Installation and Setup**: FactBranch provides pre-built apps for popular support and sales tools, simplifying the installation and setup process without requiring development work.

**Enhanced Customer Service**: Agents and sales reps can quickly access and view customer data within their existing support and sales software, potentially improving the level of personalized and efficient customer service.

**Wide Range of Data Sources**: FactBranch supports various data sources, including PostgreSQL, MySQL, SQL Server, BigQuery, Google Sheets, and REST APIs, enabling users to retrieve relevant customer data from databases, spreadsheets, or APIs.

**User-Friendly Visual Flow Editor**: FactBranch offers a visual flow editor that allows users to build data pipelines without coding, connecting data sources, creating flows, and adding nodes for data fetching or writing.

**Template Generator for Customized Data Displays**: FactBranch provides a template generator that allows users to create customized and informative data displays, which can be further personalized using HTML and a Liquid-style templating language.

**Powerful Data Pipelines**: FactBranch's data pipelines empower users to connect and query multiple data sources, perform data transformations, and write the results to another API or display them in one of FactBranch's apps.

**Data Privacy and Security**: FactBranch prioritizes data privacy and security by minimizing stored data, ensuring data remains under the user's control, and complying with data privacy laws such as GDPR and CCPA.

**Hosted on Google Cloud Infrastructure**: FactBranch is hosted on Google Cloud Infrastructure, providing data encryption at rest and in transit, as well as ensuring availability and reliability through independent audits.

FactBranch is a help desk integration tool from the small company of the same name in Vienna, that loads fresh customer data from a data source and displays it to agents and sales reps when they open a ticket or look at a contact. Data sources include popular DBs such as MySQL, PostgreSQL, MongoDB, GraphQL, or spreadsheets as well, like Google Sheets. This data can be displayed in Freshdesk, Dixa, Intercom, or other customer support tools.

1st agent

2nd through 10th agent

11th through 100th agent

Boomi is a cloud-based, on-premise, or hybrid integration platform. It offers a low-code/no-code
interface with the capacity for API and EDI connections for integrating with external organizations and
systems, as well as compliance with data protection regulations.

Task Factory

Task Factory Azure Data Factory

SolarWinds Task Factory

FactBranch

Data integration involves combining data residing in different sources and providing users with a unified view of these data.

Data Integration

FactBranch - Connecting Zendesk to an SQL database

This step-by-step guide shows you how to connect Zendesk to a PostgreSQL, MySQL or Microsoft SQL Server database.
Learn more at https://factbranch.com/apps/zendesk/?utm_source=youtube&utm_medium=video&utm_campaign=step-by-step

Sign up today at https://factbranch.com/account/create/?utm_source=youtube&utm_medium=video&utm_campaign=step-by-step

#zendesk #mysql #postgresql #postgres #sqlserver #sql #database

--
Chapters
0:00 Intro
0:17 How FactBranch looks in Zendesk
0:50 Connect FactBranch to SQL
1:25 Testing your SQL connection
1:58 Writing an SQL query
3:10 Customizing the output in Zendesk
4:31 Outro

Data Source Connection

Ability to connect to multiple data sources

Connect to traditional data sources

Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications

Connecto to Big Data and NoSQL

Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

Simple transformations

Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

Complex transformations

Complex data transformations are data normalization, advanced data parsing, etc.

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

Data model creation

Ability to create and maintain data models using a graphical tool to define relationships between data

Metadata management

Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management

Business rules and workflow

Ability to define and manage business rules and workflows

Collaboration is enabled by a shared repository of project information and metadata

Testing and debugging

Tool to debug and tune for optimal performance

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

Integration with data quality tools

Integration with tools for cleansing, parsing and normalizing data according to business rules

Integration with MDM tools

Integration with master data management tools to ensure data consistency across the organization

TrustRadius is a technology and business research firm based in Austin, Texas. The company is known as a review platform for verified B2B technology and software reviews through a proprietary algorithm and human verification.

TrustRadius

Home

Data Integration Tools

FactBranch

Overview

What is FactBranch?