Welcome to the frequently asked questions for Centerprise Data Integrator. Click links below to navigate to answers on page.
You can download a trial version of our software directrly from our website here.
250 MB – if .NET Framework is not yet installed
A lot. You can now design your dataflow anyway you wish with multiple sources, destinations and any number of mappings in between. We've also added tons of record set transformations and placed a greater emphasis on data quality. Too much to list here. Check out the detailed product information.
Yes. By using the Join Transformation, the Merge Transformation, or the Union Transformation, you can combine data coming from different sources and then map out from that Join. To write into multiple destinations, just map to each destination as you would into a single destination. To selectively map into destinations, you the Router Transformation before the destinations. Need to know more? You can find answers in our Online Help.
You can contact support@astera.com, or better yet, you can post your question on the Astera forum.
This means that you have not registered a server with a client and the "Servers" dropdown in the main menu bar is empty. To be able to run dataflows, you must register a server. By default, Centerprise registers the local machine as the server, but if you choose the "client only" option during installation, this will be empty.
Make sure that the resources you are using are visible and accessible to the server. When you are previewing data, you are running this action under your personal user account. This account usually has permission to items other than your own machine on a network. Ther server, on the other hand, is by default running under the "local system" account. This account usually does not have access to secured resources on the network. It also won't know anything about your mapped drives.
To resolve, either grant access to the machine Centerprise is running on or, better yet create an account just for Centerprise (or use an existing one such as yours) that has access.
There are number of errors you could possibly receive depending on your set up and what kind of license you have.
Read more about licnesing here and look for your problem in the trouble shooting section.
You can see these errors by using the in-built record level log. This is found under "data profiling" in the toolbox. Drag this onto the diagram and connect to the action you wish to log (usually the target). The next time you run your job, you'll see a link to the log file that will list alll of the errors in detail.
Please take a look at the feature matrix for a breakdown of what is supported in each edition.
Centerprise strings support character escaping. So do regular expressions that are defined in a string. Thus, to use a character class in a regular expression, you must escape the escape character. i.e. "\d+" becomes "\\d+".