AWS Athena Federated Query Connectors

With our growing library of AFQ connectors, users can consolidate key data sources on a single cloud platform to deliver faster and more powerful analytics with minimal disruption to their current infrastructure.

connectors

What Are AFQ Connectors?

Trianz Athena Federated Query (AFQ) Connectors provide the ability to connect and query databases across on-prem and public cloud environments outside your AWS ecosystem. AFQ connectors are integrated with Athena SDK for seamless query authoring experience and implement the security best practices defined by AWS. In addition, the connectors use existing AWS identity and access management policies, data protection using cryptographic services for credential management, and integrated with CloudWatch for audit management.

What Are AFQ Connectors?

Utilize the Combined Trianz and AWS AFQ Connector Library to Create Visually Interactive Reports

With a complete ecosystem of Trianz and AWS AFQ connectors, you can produce hybrid/multi-cloud analytics and visualizations without migrating or consolidating your data. The combined library of Trianz and AFQ connectors can pull data from disparate sources to run analysis, and connect to BI tools, such as Tableau, QuickSight, and Power BI to generate interactive visualizations on large data sets.

More Data Connections for Athena

CloudWatch
AWS-CMDB
DocumentDB
DynamoDB
Elasticsearch
HBase
MySQL
Neptune
PostgreSQL
Redis
Redshift
Timestream
TPC-Benchmark-DS
Vertica
Cloudera
Google-BigQuery
Google-Sheets
Hortonworks
Microsoft-SQL-Server
Oracle
SAP-ERP
Snowflake
Teradata
Databricks
Microsoft-Azure-Data-Lake
Microsoft-SQL-Azure
Salesforce

Plus Icon

Don’t See the Connector You Need?

Reach out to us and we can help you get connected.

Request New Connector
Cloud Icon

View Articles From Our Blog

Stay up-to-date with new connectors and features as they become available.

Check out our latest blog entry.

The AWS & Trianz AFQ Connectors Produce Powerful Results – Fast

Our AFQ connectors have been built in conjunction with Amazon and successfully implemented with our Fortune 1000 clients to transform their analytics capabilities. Here are the results produced by our AFQ connectors:

Data Source

Use Case

Table Record size(Num Rows)

Throughput

SAP HANAERP1,000,000< 1 min @ 77983 records/sec (Range partition, Instance running on AWS EC2)
SAP HANAERP1,000,000< 1 min @ 38134 records/sec (Non partitioned table, Instance running on AWS EC2)
SAP HANAERP1,000,000< 1 min @ 51347 records/sec (Hash partitioned table, Instance running on AWS EC2)
SAP HANAERP1,000,000< 1 min @ 48984 records/sec (View with pagination based partition -300000 records/partition, Instance running on AWS EC2)
OracleCRM250,000< 1 min @ 3300 records/sec (Range partition, Instance running on RDS)
OracleCRM250,000< 2 min @ 2400 records/sec (Non partitioned table, Instance running on RDS)
OracleCRM250,000< 2 min @ 2650 records/sec (List partition, Instance running on RDS)
TeradataEDW200,000< 2 min @ 2617 records/sec (Range partition, Instance running on On-prem)
TeradataEDW200,000< 2 min @ 3000 records/sec (Case partition, Instance running on On-prem)
SnowflakeEDW20,000,000< 3 min @ 113132 records/sec (Partitioned table with 300k records/partition)
SnowflakeEDW10,000,000< 2 min @ 87695 records/sec (Partitioned table with 200k records/partition)
BigqueryCloud native Data Warehouse2,000,0001341 records/sec (Over the public internet)
Cloudera(Hive)CDW1,000,0002400 records/sec (Hive cluster)

Get Started Deriving Insights and Easily Making Data-Driven Decisions

Our pre-built AFQ Connectors expedite time-to-market, minimize development effort, and enable greater customer-centricity. In addition, our solution expands upon existing Amazon Athena support, enabling data connections across the enterprise.

With Trianz and AWS, your data analytics capability on cloud can not only optimize cost and process efficiencies but also provide business users with new ways to analyze data in-place using analytics tools or business intelligence platforms. Schedule a demo of our Athena federated query connectors to learn more and get a free PoV.

Request a Connector


Contact Trianz to request a connector
from our library or to create a new one.

By submitting your information, you agree to our revised  Privacy Policy.

×