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 |
Updated over 2 years ago