You can use Amazon AppFlow to set up data flows in minutes with no coding required. Using an intuitive user interface, you can select your data sources and destinations; configure optional transformations, filters, and validations; and run your flow without having to rely on technical teams.
Amazon AppFlow includes native integration with software as a service (SaaS) applications used daily for business operations including Salesforce, SAP, Google Analytics, and Facebook Ads, with additional integrations planned. With Amazon AppFlow, you can transfer data from any supported SaaS application in a few selections.
You can use Amazon AppFlow to map source and destination fields through bulk or individual field mapping, or by using a CSV file. Amazon AppFlow helps you perform data transformations such as merging, masking, filtering, and validation. For example, you can validate your data is in the right numerical format, merge first and last names, or mask credit card details.
Amazon AppFlow partitions your data by source object schema when Amazon Simple Storage Service (S3) is selected as a destination. Partitioning enhances the layout of your data to encourage efficient querying by analytic engines such as Amazon Athena and Amazon Redshift Spectrum. Data is organized in a hierarchical partition structure based on the destination fields you select.
Queries also run more efficiently when data scanning can be parallelized and when blocks of data can be read sequentially. Amazon AppFlow helps you aggregate records into files that are customized to the size you specify. This helps decrease processing overhead and improve parallelism.
The Amazon AppFlow Connector Software Development Kit (SDK) allows you to build your own connectors to securely transfer data between your custom endpoint, application, or other cloud service to and from Amazon AppFlow's library of managed SaaS and AWS connectors. Develop and test connectors with the same open source SDK used by AWS teams internally. Start your custom connector today, available in Java and Python.
Amazon AppFlow offers a cost-savings advantage compared to building connectors in-house or through other application integration services. There are no upfront charges or licensing fees to use Amazon AppFlow, and you pay for only the number of flows you run and the volume of data processed.
With Amazon AppFlow, you can use your existing AWS Identity and Access Management (IAM) policies to enforce fine-grained permissions and keep access consistent across your organization, without creating new policies. With strictly enforced IAM policies, application administrators can safely create and manage data flows without depending on technical teams.
Amazon AppFlow is built with a highly available architecture to prevent single points of failure. Amazon AppFlow takes advantage of AWS scaling, monitoring, auditing, and billing features so you don’t need to configure these yourself.