Welcome to Centerprise 7 Documentation

Other Versions

• Version 6
• Version 8

New Features in Centerprise 7.6

• What’s New in Astera Centerprise 7.6
• Synonym Dictionary File
• SmartMatch Feature
• How SmartMatch Option Works
• Raw Text Filters in File Sources
• Job Trace Improvements

Getting Started

• Centerprise Best Practices Part 1 - Dataflows
• System Requirements for Centerprise 7
• Installing Centerprise Data Integrator
• Setting up Astera Integration Server 7
• Functions Glossary
• Introducing Dataflows
• UI Walkthrough - Astera Centerprise Data Integrator
• Upgrading to Centerprise 7.6

Sources

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

Transformations

• Aggregate Transformation
• Apply To All Transformation
• Constant Value Transformation
• Data Cleanse Transformation
• Data Quality Rules Transformation
• Denormalize Transformation
• Distinct Transformation
• Expression Transformation
• Expression Transformation
• Filter Transformation
• Join Transformation
• Merge Transformation
• Normalize Transformation
• Passthru Transformation
• REST Client
• Route Transformation
• Sequence Generator
• Sort Transformation
• Sources as Transformations
• Subflow Transformation
• Tree Join Transformation
• Union Transformation
• Web Service Transformation
• Function Transformations

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

• Creating Workflows
• Using Workflow Designer
• Using Data Source Browser
• Adding Workflow Tasks
• Workflows with a Dynamic Destination Path
• Customizing Workflows with Parameters
• Resuming and Rerunning Workflows in Centerprise

Subflow

• Using Subflows

Database Write Strategies

• Database Write Strategies
• Data Driven

Text Processors

• Fixed Length Parser
• Fixed Length Serializer

Connectors and Providers

• Oracle Client Tools Setup
• ORACLE Data Load Options in Centerprise 7.4
• Setting Up Oracle ODP.Net Connectivity in Centerprise
• Running Microsoft Access Database Engine with Centerprise

Project Management

• Deployment
• Parameterization

Web Services

• How to Connect to Eloqua using Centerprise REST API
• POSTing Data Using the REST Client
• Using the REST Client to Download a Text File
• Configuring Google Drive API through REST Client in Centerprise

Metadata Management

• Lineage and Impact Analysis

Data Mapping - Best Practices

• Cardinality Errors FAQs
• Overview of Cardinality in Data Modeling