Welcome to Centerprise 8 Documentation

Other Versions

• Version 6
• Version 7

Getting Started

• Astera Centerprise 8.1 – Release Notes
• Astera Centerprise 8.0 – What’s New, What’s Fixed, and What’s Improved
• Known Issues in Centerprise 8 (Beta)
• Migrating from Centerprise 7.x to Centerprise 8
• Centerprise 8 - Important Considerations
• Centerprise 8 – System Requirements
• Installing Client and Server Applications
• How to Install Centerprise Lean Client
• How to Set up a Server Certificate (.pfx) File in a New Environment
• Connecting to a Centerprise Server using Lean Client
• How to Connect to a Different Centerprise Server from the Lean Client
• How to Build a Cluster Database and Create Repository
• How to Configure the Server
• How to Login from Lean Client
• Licensing Model in Centerprise 8
• User Roles and Access Control
• UI Walkthrough - Astera Centerprise 8.0

Sources

• Data Providers and File Formats Supported in Centerprise
• Setting Up Sources
• Excel Workbook Source
• COBOL File Source
• Database Table Source
• Delimited File Source
• File System Items Source
• Fixed Length File Source
• Email Source
• Report Source
• SQL Query Source
• XML/JSON File Source
• PDF Form Source

Transformations

• Introducing Transformations
• Aggregate Transformation
• Constant Value Transformation
• Denormalize Transformation
• Distinct Transformation
• Expression Transformation
• Filter Transformation
• Join Transformation
• List Lookup Transformation
• Merge Transformation
• Normalize Transformation
• Passthru Transformation
• Reconcile Transformation
• Route Transformation
• Sequence Generator
• Sort Transformation
• Sources as Transformations
• Subflow Transformation
• Switch Transformation
• Tree Join Transformation
• Using the Tree Join Transformation
• Tree Transform
• Union Transformation
• Data Cleanse Transformation
• File Lookup Transformation
• SQL Statement Lookup
• Database Lookup

Destinations

• Setting Up Destinations
• Database Table Destination
• Delimited File Destination
• Excel Workbook Destination
• Fixed Length File Destination
• SQL Statement Destination
• XML File Destination

Data Logging and Profiling

• Creating Data Profile
• Creating Field Profile
• Data Quality Mode
• Using Data Quality Rules in Astera Centerprise
• Record Level Log

Workflow

• Adding Workflow Tasks
• Using the Workflow Designer
• Customizing Workflows with Parameters
• Workflows with a Dynamic Destination Path
• Using the Data Source Browser in Astera Centerprise
• Using The Workflow Designer
• GPG-Integrated File Decryption in Astera Centerprise

Subflow

• Using Subflow in Astera Centerprise

Database Write Strategies

• Database Write Strategies
• Data Driven
• Source Diff Processor
• Database Diff Processor

Text Processors

• Delimited Parser
• Delimited Serializer
• Language Parser
• Fixed Length Parser
• Fixed Length Serializer
• XML/JSON Parser
• XML/JSON Serializer

Connectors

• Setting Up IBM DB2/iSeries Connectivity in Centerprise
• Connecting to SAP HANA Database
• Connecting to MariaDB Database
• Connecting to Salesforce Database
• Connecting to Salesforce – Legacy Database
• Connecting to Vertica Database
• Connecting to Snowflake Database
• Connecting to Amazon Redshift Database
• Connecting to Amazon Aurora Database
• Connecting to Google Cloud SQL in Astera Centerprise
• Connecting to MySQL Database
• Connecting to PostgreSQL in Astera Centerprise
• Connecting to Netezza Database
• Connecting to Oracle Database
• Connecting to Microsoft Azure Databases
• Connecting to Amazon RDS Databases

Project Management

• Deployment
• Server Monitoring and Job Management
• Connecting to Source Control

Web Services

• REST API Browser
• Making HTTP Requests Through REST API Browser
• Open APIs – Configuration Details
• Authorizing Facebook APIs in Astera Centerprise
• Centerprise’s Server API
• Authorizing Avaza APIs in Astera Centerprise
• Authorizing Sqaure API in Astera Centerprise
• Authorizing ActiveCampaign API in Astera Centerprise
• Authorizing QuickBooks’ API in Astera Centerprise
• Using REST Client Outside the Scope of the Project

Miscellaneous

• Using Dynamic Layout/Template Mapping in Astera Centerprise
• Synonym Dictionary File
• SmartMatch Feature
• Scheduling Jobs on the Server
• Role-Based Access Control in Astera Centerprise
• Astera Centerprise – What’s New in Version 7 and Version 8
• Updating Your License in Astera Centerprise
• Deploying Astera Centerprise on Microsoft Azure Cloud
• Server Command Line Utility

Use Cases

• Using Astera Centerprise to Create and Orchestrate an ETL Process for Partner Onboarding

Resources

• Context Information