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.
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
Don’t See the Connector You Need?
Reach out to us and we can help you get connected.
Request New Connector
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 HANA | ERP | 1,000,000 | < 1 min @ 77983 records/sec (Range partition, Instance running on AWS EC2) |
| SAP HANA | ERP | 1,000,000 | < 1 min @ 38134 records/sec (Non partitioned table, Instance running on AWS EC2) |
| SAP HANA | ERP | 1,000,000 | < 1 min @ 51347 records/sec (Hash partitioned table, Instance running on AWS EC2) |
| SAP HANA | ERP | 1,000,000 | < 1 min @ 48984 records/sec (View with pagination based partition -300000 records/partition, Instance running on AWS EC2) |
| Oracle | CRM | 250,000 | < 1 min @ 3300 records/sec (Range partition, Instance running on RDS) |
| Oracle | CRM | 250,000 | < 2 min @ 2400 records/sec (Non partitioned table, Instance running on RDS) |
| Oracle | CRM | 250,000 | < 2 min @ 2650 records/sec (List partition, Instance running on RDS) |
| Teradata | EDW | 200,000 | < 2 min @ 2617 records/sec (Range partition, Instance running on On-prem) |
| Teradata | EDW | 200,000 | < 2 min @ 3000 records/sec (Case partition, Instance running on On-prem) |
| Snowflake | EDW | 20,000,000 | < 3 min @ 113132 records/sec (Partitioned table with 300k records/partition) |
| Snowflake | EDW | 10,000,000 | < 2 min @ 87695 records/sec (Partitioned table with 200k records/partition) |
| Bigquery | Cloud native Data Warehouse | 2,000,000 | 1341 records/sec (Over the public internet) |
| Cloudera(Hive) | CDW | 1,000,000 | 2400 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.
