Get Started
Role Guides
Kaptio Platform Architecture
Global Platform Setup
Getting Started with Core Configuration
Managing Users, Roles & Access
Understanding Your Sample Data
PIM: Supplier Contracting
PIM: Tour & Package Design
CRM Module
Setup Trip & Itinerary Workflow
CONNECT: Land & Air Connectivity
Getting Started with Connectivity
Hotel Connectivity Setup & Usage
DOCS Module
Building Custom Content Components
Using the Document Starter Kit
Using the ATOL Certificate Starter Kit
Advanced Sample Email Template
CRS: Training Guides
PAY: Payment Gateway Integrations
Data Migration
Peripheral Integration Guides
This guides describes how to integrate Kaptio to data warehouse. By integrating data from different applications into a single platform and converting all records into a consistent format, a data warehouse provides enhanced Business Intelligence capabilities. This allows users to connect data points from multiple applications, making it easier to make informed decisions.
The diagram below illustrates a high-level setup of a Data Warehouse architecture. It includes an ETL/Middleware that integrates with various cloud and on-premise applications and then dumps data into a common Data Warehouse. The Data Warehouse is divided into three layers: Staging, Core, and Semantic. Finally, the data is made accessible to a BI tool for reporting and dashboarding.
If you're a Kaptio Data Expert, the Core Data Model Documentation is a crucial reference point. It's where you can find all the essential information about Kaptio's data model and how it works. This documentation is available online at https://docs.kaptioapis.com/kaptio-travel/-/erd-overview.
The Core Data Model Documentation provides an overview of the various data objects and their relationships within Kaptio. You can use this information to understand how different data entities are related and how they impact each other. Furthermore, the documentation includes detailed descriptions of the various fields and their data types.
By using this documentation, Kaptio Data Experts can better understand how Kaptio's data model works and how to best leverage it for their organization's needs. It's an invaluable resource for anyone working with Kaptio's data and can help ensure data accuracy, consistency, and completeness.
So, if you're a Kaptio Data Expert, be sure to bookmark the Core Data Model Documentation and refer to it often. It's a powerful tool that can help you succeed in your role and ensure that your organization can make informed decisions based on accurate data.
Data extraction is a critical process in integrating Kaptio with your data warehouse. Given that Kaptio is built on Salesforce, you have the option to leverage various Salesforce APIs for this purpose. It’s essential to choose the right API and approach based on your specific data and integration requirements. Below is a breakdown of the different Salesforce APIs you can use for data extraction, along with their pros and cons.
The Salesforce REST API is a simple and powerful way to access objects in your Salesforce environment. It's best suited for situations where you need to interact with the data on a granular level or make small amounts of requests.
Salesforce REST API Documentation
The Salesforce SOAP API allows for robust interactions and is ideal for scenarios requiring integration via a strongly typed protocol.
Salesforce SOAP API Documentation
The Salesforce Bulk API is ideal for handling large amounts of data. It is optimized for loading or deleting large sets of data, and you can use it to query, queryAll, insert, update, upsert, or delete a large number of records asynchronously.