Overview

Ascend Integration Mechanisms

There are three mechanisms to integrate your data in Ascend to other systems:

  • Push the data out from Ascend into another system. Our Write Connectors push the data out and keep the external system synchronized with the data in Ascend.
  • Pull the data from Ascend into other systems. There are two interfaces to pull data, the JDBC / ODBC Connection and File-Based Access.
  • Pull records through the Python SDK. This mechanism is suitable for low latency, low volume of data fetches.

Common Integration Patterns

To help decide which mechanism and interface would best suit your integration, we've listed out the common tools and patterns used:

Integrated System

Examples

Mechanism

Interface

Object Stores

Azure Blob
Google Cloud Storage
AWS S3

Push

Write Connector

Databases + Warehouses

Microsoft SQL Server
Snowflake
AWS Redshift
Google BigQuery

Push

Write Connnector

Notebooks

Jupyter
Zeppelin

Pull

File-Based Access

Apache Spark

Databricks
AWS EMR
Google Cloud Dataproc

Pull

File-Based Access

Distributed Query Services

Presto
Athena
Hive

Push

Write Connector

BI Tools

Tableau
PowerBI

Pull

JDBC / ODBC Connection

Record Samples (Ensuring Pipeline Health)

CI / CD systems

Pull

Python SDK


© Ascension Labs Inc. | All Rights Reserved