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

»
Index

Index

© Copyright 2021, Astera Software