DB2TOOLS PACKAGE

The ultimate IBM DB2 Toolkit

Complete price $1.299



With the i-effect® DB2Tools-Package you can export databases or any part of the contents of databases in various file formats with arbitrarily fixed configurations.


Download PDF

TRY BEFORE YOU BUY
Download i-effect® free as a 30-days demo.

RAPID DB2 DATA EXPORTS

Direct exports from DB2 data in tabular formats like XML, XLS, XLSX, CSV, TXT, HTML ...

i-effect *DB2EXPORT is a native IBM i application for direct DB2 data export into spreadsheet formats (XML, XLS, CSV, HTML, TXT and PDF) on IBM Power System. It sends your employees any report at any time and for every defined event straight into their inboxes using push technology. The PC output files posses the full range of formatting and functional features.











Up-to-date and consistent

Reliable data from DB2

Direct exports from DB2 data in tabular formats - Management and specialist departments require up-to-date and consistent data to make trend-setting decisions. Most reliable business data is provided by the data base itself. On the one hand queries should provide homogeneous information in standardised format and regular time intervals. On the other hand, the processing of data base queries must be possible for different departments at any time on short notice. Mostly, inhouse data base specialists are in charge of data provision but because of lack of time they cannot process it as flexible as favoured by the specialist departments.

More about DB2EXPORT
Conditional Formatting

Conditional formatting offers a further possibility of content dependent formatting and dynamic creation of visual appearance. By specifying rules for formatting, it is possible to render all the negative numerical values in a column red and all headings in bold print. Even changes of font and color can be defined depending on the existing data.


Download PDF

User-defined Style

When converting to Excel, XML, and HTML formats, user defined styles can be used.Styles, which can be stored permanently on the system, can be applied to individual data fields and also specific data groups (headings, titles etc.). Styles contain attributes that determine the visual appearance such as font color, font, and background color.
In addition, field attributes are also determined by styles, so that the column width can be set and numerical or
alphanumerical fields are correctly formatted. In particular, date and time data, and also currency and number formats can be individually defined and applied.




Design Excel Sheets or XML Files

Effective Data Preparation
and Integration

Exportation of DB2 database contents into Excel formats has long been an integral part of an i-effect® installation and one can't imagine a work day without it. The exported DB2 data structure is transmitted and stored exactly.

You can use the new i-effect® *DB2MAPS module not only to export DB2 database contents, but also to translate them into a custom Excel or XML file structure or format, according to mapping rules. These freely definable database mappings can be used to separate database fields into various columns and rows, as well as headlines, sub headlines, subtotals etc. Likewise, i-effect® *DB2MAPS can export database exports into nested items and attributes of an XML file.

More about DB2MAPS

 




Elimination of Errors and Employee Motivation

To manage your business processes and your whole EDI-workflow on the IBM i, our module *SERVER offers extensive possibilities for the automation and monitoring of the functions and procedures. For the automated processing of files or for the control of the process you have to define time and/or event-driven tasks.

Push technology is another unique selling point of *DB2MAPS and *DBEXPORT: Users will find database information completely processed report and are free from error-prone, monotonous, routine database queries.

More about Automation





Feature overview
Take a quick overview of all features within this package.

 

We are not the only ones who are happy with i-effect®.

More than 600 customers in over 30 different countries use i-effect®


See our customers and sectors

 

You cannot play even fairer

We are sure that everyone who has tried i-effect once will see all advantages of this solution. For this reason we make a promise now:

No Cure, No Pay

Be inspired! In the case you‘re not entirely convinced, we uninstall i-effect and say goodbye. There won‘t be any costs or obligations.

 

More about No Cure, No Pay

 

 


Software Made in Germany

The "Software Made in Germany" initiative is under the patronage of the Federal Ministry of Economy and Energy.

IBM Advanced Business Partner

IBM Partnership since 2001. Platform bounded but we still attach great importance to our independence as an IBM Independent Software Vendor (ISV).

AS/400-Specialist since 1989

The menten GmbH is a specialist for the exchange of electronic business documents since 1989. More than 600 customers in 30 countries rely on our solution suite i-effect®.

Contact us now!

Call us and tell us about your project, we will offer you free advice!

*We guarantee the security of your information under the Privacy Act and will not refer your data to third parties.