Logo
Home · Centerprise · ReportMiner · EDIConnect · Data Virtualization

Getting Started

  • Centerprise 9 – System Requirements
  • Astera Centerprise – Product Architecture
  • 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 9
  • User Roles and Access Control
  • Offline Activation of Astera Centerprise

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
  • 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

  • What are Workflows?
  • Decision
  • EDI Acknowledgment
  • File System
  • File Transfer
  • OR
  • Run Dataflow
  • Run Program
  • Run SQL File
  • Run SQL Script
  • Run Workflow
  • Send Mail
  • Creating Workflows in Astera Centerprise
  • Workflows with a Dynamic Destination Path
  • Customizing Workflows With Parameters
  • 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
  • Dimension Loader

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
  • Centerprise Project and Project Explorer

Web Services

  • REST Connection
  • Making API Calls with the REST Client Object in Astera Centerprise
  • REST API Browser
  • Method Operations
  • Pagination
  • Open APIs – Configuration Details
  • Authorizing Facebook APIs in Astera Centerprise
  • Authorizing Centerprise’s Server APIs
  • Authorizing Avaza APIs in Astera Centerprise
  • Authorizing Square API in Astera Centerprise
  • Authorizing ActiveCampaign API in Astera Centerprise
  • Authorizing QuickBooks’ API in Astera Centerprise
  • Accessing Centerprise’s Server APIs Through a Third-Party Tool
  • Centerprise’s Server API Documentation

Miscellaneous

  • Using Dynamic Layout/Template Mapping in Astera Centerprise
  • Synonym Dictionary File
  • SmartMatch Feature
  • Scheduling Jobs on the Server
  • Job Monitor
  • 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
  • Deploying Astera Centerprise on Oracle Cloud
  • Deploying Astera Centerprise on Amazon Web Services
  • Using Output Variables in Astera Centerprise
  • Connection Vault
  • Safe Mode
  • Using the Data Source Browser in Astera Centerprise
  • Pushdown Mode

Use Cases

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

Resources

  • Context Information
Centerprise
  • »
  • Search

© Copyright 2021, Astera Software