Welcome to Centerprise 10 Documentation¶
Other Versions¶
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¶
Data Logging and Profiling¶
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
Data Governance (Upcoming)¶
Database Write Strategies¶
Testing and Diagnostics¶
Analytical Models¶
Visualization¶
Text Processors¶
Incremental Loading¶
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¶
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¶
Cloud Deployment¶
Job Scheduling¶
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
Resources¶