Alteryx Designer Cloud Features

Provides a wide range of possible data connections, including cloud applications, on-premise databases, and big data distributions, among others

Allows businesses to easily connect to any data source

Offers API connections for cloud-based applications and data sources

Permits profiling of data sets for increased organization, both by users and machine learning

Indexes metadata descriptions for easier searching and enhanced insights

Tools to (re)structure data in a manner that enables quick and accurate insight extraction

Allows self-service joining of tables

Provides the ability to combine data sources into one data set

Allows users and administrators to easily clean data to maintain quality and integrity

Offers collaborative functionality for sharing queries and data sets

Ensures user access management, data lineage, and data encryption

Provides a wide range of possible integrations, including analytics, data integration, master data management, and data science tools

Allows businesses to easily integrate with analytics, data integration, master data management, and data science tools

Operationalizes data workflows to easily scale repeatable preparation needs

View ETL process data via reports and visualizations like charts and graphs.

Record ETL historical data for auditing and potential data correction needs.

Provide follow-up information after data cleanings through a visual dashboard or reports.

Automatically run data identification, correction, and normalization on data sources.

Schedule automated audits to identify data anomalies over time based on set business rules.

Gives a view of the entire data quality management ecosystem.

Allows user role-based access and actions to authorization for specific tasks.

Extract data from the designated source(s) like relational databases, JSON files, and XML files.

Cleanse and re-format extracted data to the needed target format.

Load reformatted data into target database, data warehouse, or other storage location.

Arrange ETL processes to occur automatically on needed time schedule (e.g., daily, weekly, monthly).

Capable of scaling processing power up or down based on ETL volume.

Correctly identify inaccurate, incomplete, or duplicated data from a data source.

Utilize deletion, modification, appending, merging, or other methods to correct bad data.

Standardize data formatting for uniformity and easier data usage.

Clean data as it enters the data source to prevent mixing bad data with cleaned data.

Finds duplicates using the fuzzy logic technology or an advance search feature.

Supports event or transaction based integrations that react to changes in real-time

Provides a web-based interface for designing, documenting, and testing APIs.

Allows for integration development through the visual development of integration logic flows with the help od a drag and drop user interface.

Facilitiates API development and integrations with prebuilt connectors, templates, and examples.

Provides the ability to create connectors from existing services and APIs in catalog.

Provides prebuilt, reusable connectors and workflows for all user integration requirements.

Enables multiple tenants (customers) to securely share physical computing resources.

Console for monitoring resource utilization, system health, ability to start and stop processes, etc.

Enables data routing on configuration basis and management of complex workflows through an orchestration engine.

Facilitates to and fro data map according to the data model between applications/web services.

Provides standard tools and functions to convert data values from the data format of a source system into the data format of a destination system.

Supports and oversees the management of API products across their full lifecycle

Employs data encryption both at rest and in transit.

Comply to key industry standards like SOC 2, ISO 27001, PCI DSS, HIPAA etc to protect and safeguard data.

Supports secure communication protocols like FTPS, SFTP etc

Integrates data from disparate sources, without physical data movement

Provides one or more methods to securely transfer data from one location to another through a network

Provides integration to BigData sources such as Hadoop and other NoSQL sources (MongoDB, Cassandra and HBase)

Provides Integrations to EDI service providers.

Supports deployment of integration apps both on-premisis and cloud environments/

Supports deployment of integration apps to a managed cloud environment

Allows users to generate text based on a text prompt.

Allows users to generate text based on a text prompt.

Condenses long documents or text into a brief summary.