Home · Centerprise · ReportMiner · EDIConnect · Data Virtualization

Getting Started

Centerprise 10 – System Requirements
Astera Centerprise – Product Architecture
Migrating from Centerprise 9 to Centerprise 10
Migrating from Centerprise 7.x to Centerprise 10
Installing Client and Server Applications
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 Login from Lean Client
How to Verify Admin Email
Licensing in Centerprise
How to Supply a License Key Without Prompting the User
User Roles and Access Control
Offline Activation of Astera Centerprise
Setting Up R in 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
Parquet File Source (Beta)
MongoDB Source (Beta)

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
Parquet File Destination (Beta)

Data Logging and Profiling

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

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

Data Governance (Upcoming)

Data Profiles
Data Discoverability
Modifying Asset Details
Tags

Database Write Strategies

Database Write Strategies
Data Driven
Source Diff Processor
Database Diff Processor

Testing and Diagnostics

Pre-Analytics Testing
Correlation Analysis

Analytical Models

Time Series Smoothing
Linear Regression

Visualization

Basic Plots
Distribution Plots

Text Processors

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

Incremental Loading

Trigger Based CDC
Incremental CDC

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
Amazon S3 Bucket Storage in Astera Centerprise
Connecting to Amazon RDS Databases
Microsoft Azure Blob Storage in Astera Centerprise
ODBC Connector
Connecting to Microsoft SharePoint in Astera Centerprise (Coming Soon)
Microsoft Dynamics CRM
Configuring the Cloud Connector object with the Azure Data Lake Gen 2 Storage Provider
Connection Details for Azure Data Lake Gen 2 and Azure Blob Storage
Microsoft Message Queue
Connecting to Google BigQuery
Azure SQL Server Configuration Prerequisites
Connecting to Microsoft Azure SQL Server in Astera Centerprise

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

GIT

GIT Repositories in Astera Centerprise
Moving a Repository to a Remote Server
Git Conflicts in Astera Centerprise

Cloud Deployment

Deploying Astera Centerprise on Microsoft Azure Cloud
Deploying Astera Centerprise on Oracle Cloud
Deploying Astera Centerprise on Amazon Web Services
Setting up Astera Data Management Server on AKS

Job Scheduling

Scheduling Jobs on the Server
Job Monitor

Miscellaneous

Using Dynamic Layout/Template Mapping in Astera Centerprise
Synonym Dictionary File
SmartMatch Feature
Role-Based Access Control in Astera Centerprise
Astera Centerprise – What’s New in Version 7 and Version 8
Updating Your License in Astera Centerprise
Using Output Variables in Astera Centerprise
Parameterization
Connection Vault
Safe Mode
Using the Data Source Browser in Astera Centerprise
Pushdown Mode
Optimization Scenarios
Using Microsoft’s Modern Authentication Method in Email Source Object
Shared Actions
Data Formats
Lineage and Impact Analysis
Resource Catalog
Windows Authentication

Use Cases

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

Resources

Context Information

Centerprise

»
Index

Index