FAQs

Home · Centerprise · ReportMiner · EDIConnect · Data Virtualization

Installation, Licensing, and Server Configuration

What are the system requirements to install Astera Centerprise?
Why do we need to make two installations for Astera Centerprise?
What’s the difference between Custom and Complete installation?
What’s the difference between 32-bit and 64-bit Centerprise?
Can we use a single license for multiple users?
Can we install Centerprise on more than one system using a single license key?
Does Centerprise client work when it’s not connected to the server?
Why do we need to build a cluster database and set up a repository while working with Centerprise?
Which database providers does Centerprise support for setting up a cluster database?
How many Centerprise clients can be connected to a single server?
How do Centerprise client and server communicate?
Is there any limit to the number of jobs that can be run on the server at a time?
Can we access help documentation from Centerprise client?
Up to how many servers can a single Centerprise client connect to?
Why Centerprise is possibly not able to access my source file or create a new one?
Will an upgrade result in the failure of existing .dlls?
I uninstalled Centerprise from one machine and attempted to activate it on a new device, but the server is not accepting my license key. Why am I getting this error?
Will I lose all my scheduled jobs when upgrading to the latest version?
Is there a way to export the existing jobs from the previous to the latest version of Centerprise?
Is there a permanent link from where I can always have access to the newest build?

Sources

Does Astera Centerprise support data extraction from unstructured docs or text files?
What is the difference between full and incremental loading in database sources?
Does Centerprise support extraction of data residing in online sources?
How is the File System Items Source used in a dataflow?
How does the PDF Form Source differ from Report Source in Centerprise?
Does Centerprise support extraction of data from EDI files?
How does the Raw Text Filter option work in file sources in Centerprise?

Transformations

What does the Aggregate Transformation do in Astera Centerprise?
How is the Aggregate Transformation different from the Expression Transformation?
What are the different sorting options in the Aggregate Transformation and how do they impact the output?
Can we omit duplicate records using the Aggregate Transformation in Astera Centerprise?
How many datasets can a single Aggregate object take input from?
What is an Expression Transformation?
How is Expression Transformation different from the Function Transformation?
Does the SQL Query source support the use of parameters? If yes, how and in what cases can it be used?
What is a set level transformation?
What is a Record level transformation?
What are the different types of lookups in Astera Centerprise?
How is the Filter Transformation different from the Route Transformation?
Is the Filter transformation similar to Data Quality Rules in function?
What are the different types of Join available in Astera Centerprise?
Can we perform a Join using more than one key in the Join transformation?
What’s the difference between INSERT, UPDATE, UPSERT and DELETE actions available for data loading in a Database Table destination?
What does the Truncate Table option do in Database Table destinations?
What’s the difference between ‘Bulk insert with batch size’ and ‘Use single record insert’ Data Load Options in Database Table destinations?
How does the Default Value column in Database Table destination layout work?
What does the Advanced Connection Info option do in a Database object?
What’s the maximum number of groups we can create in Route transformation?
What is the outcome if an incoming record matches multiple rules in Route transformation?
Can we perform a hierarchical join using the Join transformation in Centerprise?
What is the meaning of Batch Size in Sequence Generator transformation where a sequence is generated in a Database Table?
Can we join multiple children to a single parent node using only one Tree Join transformation object?
Which output would be assigned if a record satisfies two conditions in a Switch transformation object?
What is the order of priority of options in different columns in the Layout Builder of the Merge transformation object?
What is the difference between Survivor Type and Precedence in Merge transformation?
Why does the Return All option on the Lookup Options screen in the File Lookup transformation give an error?

Destinations

If I want to have a different field delimiter, say a pipe (“|”), is there an option to export with another delimiter and filename extension?
I want to change the output format of a column, say integer to string, or vice versa. Any error trapping abilities with that conversion?
Tools Menu > Data Format has different date formats, but it doesn’t seem to do anything. Each time I go into it, it still has the first option selected even after choosing a different one.
Can we export the Object Path column present in the Data Preview window?
What will be the outcome if we write files multiple times to the same Excel Destination?

Data Profiling

Is there a log file created that we can have written/saved to a folder of our choice for troubleshooting purposes? Something that shows when it ran, how many records it loaded, how many failed, and why?

Database Write Strategy

Why Database Diff Processor does not have an output node in Centerprise v8.2?
Which Database Write Strategy is more efficient for working with larger volumes of data?
In which Database Write Strategy do we use a CDC file?
How can CDC improve the performance of Database Diff Processor when used in conjunction?
Which one from the Database Diff Processor and Source Diff Processor is a more cost-effective write strategy?
Is it necessary for the database tables to be of same layout in order to work with Data Driven, Database Diff Processor, and Source Diff Processor?
Is there any limitation to the type of source each Database Write Strategy can take input from?
Why is it necessary to select the Single Port option in the Database Table Destination while working with a write strategy?
Will a record be tried against the following rule if it satisfies the current rule in Data Driven write strategy?
What is the difference between ‘Single Output’ and ‘One Port for Each Action’ in Source Diff Processor?
What is the difference between UPSERT and Database Diff Processor?
Is it sufficient to use a Slowly Changing Dimension Write Strategy to insert new records and update existing records? Or do we need to use it in conjunction with Database Diff Processor for the purpose?
How can Source Diff Processor load data incrementally?

Dataflow

What is a dataflow?

Workflow

What is a workflow?
What does deployment refer to in Centerprise?
What is the difference between a Decision and OR object in workflows?

Subflow

Is it possible to work with nested subflows in Astera Centerprise?

ReportMiner

What is the difference between Single Instance Data Region and Collection Data Region in Astera ReportMiner?

Miscellaneous

How can we preview ‘x’ number of records in a Data Preview window?
Does the Max result rows option in Tools > Options > Query tab being defaulted at 5000 limit the processing of any records?
What is Pushdown Mode?

FAQs

»
Which database providers does Centerprise support for setting up a cluster database?

Which database providers does Centerprise support for setting up a cluster database?¶

Centerprise supports SQL server and PostgreSQL for setting up a cluster database.

© Copyright 2019, Astera Software