CoolSpools

Easily import, export, convert and distribute IBM i data in multiple formats.

With CoolSpools, you can easily import, export, interface and manage information from within your AS400 / IBM i database. CoolSpools includes a sophisticated spool file manager that allows you to:

Convert files into PDF, Excel, XML, Text and HTML formats

Manage email distribution for easy reporting

CoolSpools is driving data modernisation for hundreds of organisations running IBM i / AS400 servers worldwide.

Rapid IBM i / AS400 data extraction and conversion to Excel, PDF, XML, Text, CSV, XML and more with CoolSpools Database.

Database is a module of the CoolSpools Suite and is available separately if you only need to convert database files to Excel, XML, HTML, Text, CSV – and save query output and SQL selection results in any of those formats.

CoolSpools Database offers IBM I / AS400 file conversion. It distributes IBM i data quickly, conveniently and cost-effectively – and it extracts data from IBM i AS400 database files to a variety of formats, including Excel, XML and fully searchable PDF’s.

CoolSpools Database will also allow you to import from Excel to a database file and validate an XML document against an XSD schema.

Free Trial

CoolSpools Database and the full CoolSpools Suite are available to download free for 30 days.

Already evaluated CoolSpools Database?

Buy CoolSpools Database now from £850 per LPAR.

Multi-licence discounts are available by application.

Annual maintenance is free in the first year after purchase.

Extract data from your AS400 databases directly or using SQL or Query

Import data into your AS400 databases from Excel spreadsheets

Record and field selection and sequencing

Use styles to control the appearance of Excel rows and cells

Use colours, fonts, shading, borders etc. and define conditional formatting rules

Generate XML documents, schemas and stylesheets

Interface your data into third-party systems

Manage data extracts with a single command

CoolSpools Database distributes queries, reports and database extracts to your users and customers in electronic form. It avoids the need to run file transfers from a PC by creating Excel files etc. directly on your AS400, letting you generate data extracts as part of your batch jobs, just by running a single command.

All database file types are supported, including physical, logical and DDM files.

CoolSpools Database also supports input from SQL statements, SQL scripts and queries, allowing you to run a query and save the output as an Excel spreadsheet.

Generate XML files with reliability and precision

The use of XML is becoming increasingly widespread so the ability to generate XML from Spool files and database files is a major advantage to AS400 users.

With CoolSpools the process of creating XML files from your AS400 data is simple and reliable as everything happens on the AS400 platform.

Database is a module of the CoolSpools Suite and is available separately if you only need to convert database files to Excel, XML, HTMLHTML, Text, CSV – and save query output and SQL selection results in any of those formats.

Database is a module of the CoolSpools SuiteCoolSpools Suite and is available separately if you only need to convert database files to Excel, XML, HTML, Text, CSV – and save query output and SQL selection results in any of those formats.

Database is a module of the CoolSpools Suite and is available separately if you only need to convert database files to Excel, XML, HTML, Text, CSV – and save query output and SQLSQL selection results in any of those formats.

Rapid IBM i / AS400 data extraction and conversion to Excel, PDF, XML, Text, CSV, XML and more with CoolSpools Database.

Database is a module of the CoolSpools Suite and is available separately if you only need to convert database files to Excel, XML, HTML, Text, CSV – and save query output and SQL selection results in any of those formats.

CoolSpools Database offers IBM I / AS400 file conversion. It distributes IBM i data quickly, conveniently and cost-effectively – and it extracts data from IBM i AS400 database files to a variety of formats, including Excel, XML and fully searchable PDF’s.

CoolSpools Database will also allow you to import from Excel to a database file and validate an XML document against an XSD schema.

Free Trial

CoolSpools Database and the full CoolSpools Suite are available to download free for 30 days.

Already evaluated CoolSpools Database?

Buy CoolSpools Database now from £850 per LPAR.

Multi-licence discounts are available by application.

Annual maintenance is free in the first year after purchase.

Extract data from your AS400 databases directly or using SQL or Query

Import data into your AS400 databases from Excel spreadsheets

Record and field selection and sequencing

Use styles to control the appearance of Excel rows and cells

Use colours, fonts, shading, borders etc. and define conditional formatting rules

Generate XML documents, schemas and stylesheets

Interface your data into third-party systems

Manage data extracts with a single command

CoolSpools Database distributes queries, reports and database extracts to your users and customers in electronic form. It avoids the need to run file transfers from a PC by creating Excel files etc. directly on your AS400, letting you generate data extracts as part of your batch jobs, just by running a single command.

All database file types are supported, including physical, logical and DDM files.

CoolSpools Database also supports input from SQL statements, SQL scripts and queries, allowing you to run a query and save the output as an Excel spreadsheet.

Generate XML files with reliability and precision

The use of XML is becoming increasingly widespread so the ability to generate XML from Spool files and database files is a major advantage to AS400 users.

With CoolSpools the process of creating XML files from your AS400 data is simple and reliable as everything happens on the AS400 platform.