To specify the database to connect to, in the Database drop-down list, select or type the name of the appropriate database. The data is stored on the user’s PC. This second database can be the Netezza database, or some other, external database. For details, refer to Main Window of Aginity Workbench. You should take the following into consideration while uploading data to the database: There are several file diff tools supported by Aginity Workbench.

Uploader: Sagis
Date Added: 7 April 2005
File Size: 63.88 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 23734
Price: Free* [*Free Regsitration Required]

The data import procedure consists of the following steps: DO NOT nwtezza 5. You can retrieve the schema and data definition language DDL from the source databases, and translate this data into your target system schema.

This option is useful if you need to know if some specific SQL command or query has been executed by the current user. Allows creating a user-defined scalar function. Executes the current SQL query. Allows you to use different background colors for different database names.


Checks whether the percentage of deleted records in a table exceeds the defined threshold value. If you want a new output file to be created, type its name in the Output file list box.


Select another file diff tool installed on the computer, or aginiyy a custom file diff tool from the Tool drop-down list. To get started, specify two databases, or the NHS files, previously created by the Script Database function, and then click Compare.

How to Install Aginity Workbench for Netezza

Allows you to specify the actions that must be selected by default. This is the accepted answer. Aginty NOT 76 If a custom diff tool is selected, specify the executable location and command prompt parameters for the custom tool.

DO NOT 81 For details, refer to Viewing Database Space. In the Aginity workbench for netezza file drop-down list, do one of the following: Many thanks again for the links qginity the data, and the clever suggestion on using wget to pull in the data to the VM target. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

By right-clicking a database, table, server, or another object, you can access functions specific to the corresponding object type.

How to Install Aginity Workbench for Netezza –

Pros The install was easy. Sameer Pradhan 48 1 Allows you to create new code snippets, and edit the existing ones. Allows performing several types of data validation, including the uniqueness of data, referential integrity, bad table distribution, and so on.


Allows you to save a query set under a different name. The wizard displays a summary of the selections made during the previous two steps.

Allows editing any stored procedure. Displays objects’ entity schema in the Object Browser.

DO NOT 5 2. The commands are available only if they are relevant to the selected object. Performing the following types of data validation: The same set of commands provided by the Object workbencj can also be accessed by aginuty any object in the Object Browser, and then selecting the required function from the displayed menu.

DO NOT aginity workbench for netezza 3. You can simultaneously get connected to several database servers. Here is the URL to download it