Astera Data Stack
Ask or search…
⌃
K
Welcome to Astera Data Stack Documentation
RELEASE NOTES
Astera 10.3 - Release Notes
Astera 10.2 – Release Notes
Astera 10.1 - Additional Notes
Astera 10.1 - Release Notes
Astera 10.0 - Release Notes
SETTING UP
Install Manager
System Requirements
Product Architecture
Migrating from Astera 9 to Astera 10
Migrating from Astera 7.x to Astera 10
Installing Client and Server Applications
Connecting to a Astera Server using Lean Client
How to Connect to a Different Astera 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 Astera
How to Supply a License Key Without Prompting the User
User Roles and Access Control
Offline Activation of Astera
Setting Up R in Astera
Silent Installation
DATAFLOWS
What are Dataflows?
Sources
Transformations
Destinations
Data Logging and Profiling
Database Write Strategies
Text Processors
Data Warehouse
Testing and Diagnostics
Analytical Models
Time Series Smoothing
Linear Regression
Visualization
WORKFLOWS
What are Workflows?
Creating Workflows in Astera
Decision
EDI Acknowledgment
File System
File Transfer
Or
Run Dataflow
Run Program
Run SQL File
Run SQL Script
Run Workflow
Send Mail
Workflows with a Dynamic Destination Path
Customizing Workflows With Parameters
GPG-Integrated File Decryption in Astera
Subflows
Using Subflows in Astera
DATA MODEL
Creating a Data Warehousing Project
Data Models
Dimensional Modelling
Data Vaults
Documentation
Deployment and Usage
REPORT MODEL
User Guide
Report Model Interface
Use Cases
Auto Generate Layout
AI Powered Data Extraction
Optical Character Recognition
Exporting Options
Miscellaneous
API Flow
API Publishing
API Consumption
Data Analytics
Linear Regression
Basic Plots
Correlation Analysis
R Script Transformation
Predictive Analysis
Decision Tree
Pre-Analytics Testing
Working with LLMS
Coming Soon!
Project Management and Scheduling
Project Management
Job Scheduling
Functions
Introducing Function Transformations
Custom Functions
Logical
Conversion
Math
Financial
String
Date Time
Files
Date Time With Offset
GUID
Encoding
Regular Expressions
TimeSpan
Matching
USE CASES
End-to-End Use Cases
CONNECTORS
Setting Up IBM DB2/iSeries Connectivity in Astera
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
Connecting to MySQL Database
Connecting to PostgreSQL in Astera
Connecting to Netezza Database
Connecting to Oracle Database
Connecting to Microsoft Azure Databases
Amazon S3 Bucket Storage in Astera
Connecting to Amazon RDS Databases
Microsoft Azure Blob Storage in Astera
ODBC Connector
Microsoft Dynamics CRM
Connection Details for Azure Data Lake Gen 2 and Azure Blob Storage
Configuring Azure Data Lake Gen 2
Connecting to Microsoft Message Queue
Connecting to Google BigQuery
Azure SQL Server Configuration Prerequisites
Connecting to Microsoft Azure SQL Server
Connecting to Microsoft SharePoint in Astera
MISCELLANEOUS
Using Dynamic Layout & Template Mapping in Astera
Synonym Dictionary File
SmartMatch Feature
Role-Based Access Control in Astera
Updating Your License in Astera
Using Output Variables in Astera
Parameterization
Connection Vault
Safe Mode
Using the Data Source Browser in Astera
Pushdown Mode
Optimization Scenarios
Using Microsoft’s Modern Authentication Method in Email Source Object
Shared Actions
Data Formats
Resource Catalog
Windows Authentication
Cloud Deployment
GIT In Astera Data Stack
Astera Best Practices - Dataflows
UPCOMING
Data Governance
Powered By
GitBook
Comment on page
Analytical Models
Here are the articles in this section:
Time Series Smoothing
Linear Regression
Previous
Correlation Analysis
Next
Time Series Smoothing