Matillion is an extract, transform, load (ETL) solution for cloud data warehouses including Amazon Redshift, Snowflake and Google BigQuery. It enables users to gather data from various sources and deliver them in structured and semi-structured frameworks using platform's data transformation capabilities. The search functionality lets enterprises find specific results across notes, jobs, and components within projects through term-based searches.
Key features of Matillion include data export/import, collaboration, audit logs, scripting, job scheduling, version control and task management. Businesses can use the automation tools to schedule multiple orchestration jobs against a project at predefined time intervals. Plus, it enables administrators to ensure data security by managing user access across Active/LDAP directories, SSL certificates and authentication to use information from the local directory.
Matillion facilitates integration with several third-party applications to aid with data management across cloud warehouses such as Facebook, MailChimp, Amazon RDS, Hubspot, Salesforce, Elasticsearch, Google Analytics, JIRA, Marketo, and more. It also comes with an application programming interface (API) query component, which allows users to integrate the platform with any JSON or XML-based API.