Astera Support Center
Facing problems in managing your data? Have questions about using Astera’s Products? Our experts are here to help you. Tell us how can we help?
Need Help with our Software Solutions?
ReportMiner, EDI, and Integration Extensions
API and Power BI Connectivity
ReportMiner Licensing and EDI Submissions
Centerprise Workflow and File Automation
Automated File Ingestion and Transfers
- How do I configure a new file watcher or folder-based import in Centerprise so incoming files are picked up automatically?
- How do I set up and troubleshoot SFTP file transfers in Centerprise for automated inbound and outbound workflows?
- How do I troubleshoot Centerprise workflows that fail when reading or writing files on a network share or mapped drive?
Data Load and Source Structure Troubleshooting
- How do I troubleshoot Centerprise workflows that fail when reading Excel files with missing sheets, renamed tabs, or changed column headers?
- How do I troubleshoot Centerprise workflows that fail when reading JSON or XML files with unexpected structure changes?
- How do I troubleshoot Centerprise workflows that fail when writing to a database because of duplicate keys or constraint violations?
Centerprise Installation, Upgrade, and Connectivity
Connecting Centerprise to Servers and Databases
- How do I troubleshoot Centerprise dataflows that fail when connecting to a database after a driver, DSN, or environment change?
- How do I connect Centerprise to a different server from the Lean Client after moving environments or changing the server host?
- How do I install or update the required database driver or ODBC DSN for Centerprise when a connection stops working?
Installing and Activating Centerprise
User Guide for Version 8.0
Getting Started
- Centerprise Data Integrator 8 – What’s New, Improved, and Fixed
- Known Issues in Centerprise 8 (Beta)
- Installing Client and Server Applications
- How to Install Centerprise Lean Client
- Connecting to a Centerprise Server using Lean Client
- How to connect to a different Centerprise Server from the Lean Client
Integration Server
Transformations
- Subflow Transformation
- Apply To All Transformation
- Normalize Transformation
- Tree Join Transformation
- Sequence Generator
- Union Transformation
Sources
- Setting Up Sources
- Database Table Source
- Delimited File Source
- Excel File Source
- XML/JSON File Source
- File System Entries Source
Destinations
Database Write Strategies
Data Logging and Profiling
Workflow
Subflows
User Guide for Version 7
Workflow Tasks
Transformations
- Passthru Transformation
- Expression Transformation
- Web Service Transformation
- Denormalize Transformation
- Aggregate Transformation
- Subflow Transformation
Sources (Readers)
- Fixed Length File Source
- SQL Query Source
- COBOL File Source
- Data Model Source
- File System Entries Source
- XML/JSON File Source
Maps
- Creating List Lookup Maps
- Creating Direct Maps
- Linking and Mapping Objects
- Creating Function Maps
- Creating Database Lookup Maps
- Creating Expression Maps
Integration Server
Forums and Knowledgebase
Destinations (Writers)
- Database Table Destination
- SQL Statement Destination
- Delimited File Destination
- Fixed Length File Destination
- Excel File Destination
- XML File Destination
Database Write Strategies
Working with Databases
Workflow
Subflows
Misc
Logging and Profiling
Getting Started
EDIConnect
- Acknowledgement Generation in EDIConnect
- Trade Partner Management in EDIConnect
- Custom Repository in EDIConnect - Customizing EDI Transactions
- Acknowledgement Generation in EDIConnect
- Trade Partner Management in EDIConnect
- EDI Source Files and Parsing in EDIConnect
Dataflow
Report Mining
- How to use Email Source Object in a Report Model
- Using Floating Fields
- Data Fields
- Optical Character Recognition Support
- Microsoft Word and Rich Text Format Support
- Data Exporting
User Guide for Version 6
Getting Started
Dataflow
Transformations
- Web Service Transformation
- REST Client
- Expression Transformation
- Passthru Transformation
- Apply To All Transformation
- Expression Transformation
Maps
- Creating SQL Statement Lookup Maps
- Creating Function Maps
- Creating Expression Maps
- Creating Constant Value Maps
- Creating List Lookup Maps
- Creating Database Lookup Maps
Workflow
Workflow Tasks
Misc
Sources (Readers)
- SQL Query Source
- File System Entries Source
- Data Model Source
- ADO.Net Metadata Collections Source
- Database Table Source
- COBOL File Source
Destination (Writers)
- SQL Statement Destination
- Fixed Length File Destination
- Delimited File Destination
- Excel File Destination
- Database Table Destination
- Setting Up Destinations
Forums and Knowledgebase
Subflows
Logging and Profiling
Database Write Strategies
Working with Databases
Integration Server
ReportMiner
EDIConnect
Astera Data Virtualization
Data Virtualization
- Multi-Table Query Source
- Deploying a Virtual Data Model on Server
- Virtual Data Model Layouts
- Installing Astera Data Virtualization Server and Client
- Designing a Data Model
- Using Astera Query Language (AQL) in Centerprise