Analytics Platform
No-code connectors
AP provides connectors to the most popular information systems in international development, allowing you to load data effortlessly and make it ready for analysis without writing custom code.
Azure Blob Storage
The Azure Blob Storage connector extracts data from CSV and Parquet data files from Blob storage containers, automatically detects columns and data types and loads the data in the AP data warehouse, represented in an easy-to-navigate schema.
BHIMA
The BHIMA connector extracts key information including depot, inventory, stock, lot, requisition, usage and satisfaction data, and loads the data in the AP data warehouse, represented in an easy-to-navigate schema.
CommCare
The CommCare connector extracts key information including survey forms and case data, loads the data in the AP data warehouse, and creates views optimized for analytics, represented in an easy-to-navigate schema.
CSV file upload
The CSV file upload connector allows you to upload your data files in CSV format, and automatically detects columns and data types and loads the data in the AP data warehouse, represented in an easy-to-navigate schema.
DHIS2
The DHIS2 connector extracts metadata, aggregate data, events and tracked entities from DHIS2, loads the data in the AP data warehouse, represented in an easy-to-navigate schema with wide analytics tables optimized for analytics.
FHIR
The FHIR connector extracts FHIR resources including code system, encounter, location, medication, observation, organization, patient, person, practioner and questionnaire, and makes the information available for analytics.
Google Sheets
The Google Sheets connector allows you to specifty ranges for header and data, detects columns and data types and loads the data in the AP data warehouse, represented in an easy-to-navigate schema.
iHRIS
The iHRIS connector extracts key human resouce information including staff employment records, references and facts, and loads the data in the AP data warehouse, represented in an easy-to-navigate schema.
Kobo Toolbox
The Kobo Toolbox connector extracts survey data, detects data type for each survey field and loads the data in the AP data warehouse, represented in an easy-to-navigate schema, with one table per survey.
MS SQL Server
The MS SQL Server connector allows you to automatically replicate entire tables, or select data with a SQL query, and have AP load the data in the AP data warehouse, ensuring data is consistent and always up to date.
MySQL
The MySQL connector allows you to automatically replicate entire tables, or select data with a SQL query, and have AP load the data in the AP data warehouse, ensuring data is consistent and always up to date.
ODK
The ODK connector extracts survey data, detects data type for each survey field and loads the data in the AP data warehouse, represented in an easy-to-navigate schema, with one table per survey.
Ona
The Ona connector extracts survey and form data, detects data type for each survey field and loads the data in the AP data warehouse, represented in an easy-to-navigate schema, with one table per survey.
Oracle
The Oracle connector allows you to automatically replicate entire tables, or select data with a SQL query, and have AP load the data in the AP data warehouse, ensuring data is consistent and always up to date.
Parquet file upload
The Parquet file upload connector allows you to upload your data files in Parquet format, and automatically detects columns and data types and loads the data in the AP data warehouse, represented in an easy-to-navigate schema.
PostgreSQL
The PostgreSQL connector allows you to automatically replicate entire tables, or select data with a SQL query, and have AP load the data in the AP data warehouse, ensuring data is consistent and always up to date.
Public dataset
The public dataset connector allows you to effortlessly integrate data from a library of curated public datasets, and have AP load the data in the AP data warehouse, ensuring the data is consistent and always up to date.
Amazon Redshift
The Amazon Redshift connector allows you to automatically replicate entire tables, or select data with a SQL query, and have AP load the data in the AP data warehouse, ensuring data is consistent and always up to date.
Amazon S3
The Amazon S3 connector extracts data from CSV and Parquet data files from S3 buckets, automatically detects columns and data types and loads the data in the AP data warehouse, represented in an easy-to-navigate schema.
Talamus
The Talamus connector extracts aggregate data from patient records in a secure way, including data element, facility and disaggregation, and loads the data in the AP data warehouse, represented in an easy-to-navigate schema.