SEGMENTTREE

Every organization generates hundreds of files from their enterprise systems for various communication and data transfer needs. ClearCycle SEGMENTTREE is a very versatile tool that allows users to generate complex and formatted data files from any databases. This easy to use tool does not require sophisticated IT knowledge and any user without the knowledge of database or any other programming language can create the necessary file structure and generate the data files.

Irrespective of the complexity of the file, any users can build the file specification using the intuitive multi-level editor. Once the file specification is created, a simple command-line invocation of SEGMENTTREE is sufficient to repeatedly pull data and create files as desired.

SEGMENTTREE natively supports pulling data from ORACLE, MS SQL Server and Firebird databases. With additional dlls (dynamic link libraries) all other databases can be supported. For more advanced users, the tool also provides a full proprietary scripting language to do custom processing during the file generations.

SECTIONLOADER

SECTIONLOADER is a tool that provides the reverse capability of SEGMENTTREE and enables you to parse complex data files and move the data into Database Tables.

Similar to the SEGMENTTREE, users first build a file parsing specification using the easy to use and intuitive multi-level editor. Then a command-line invocation of SECTIONLOADER is typically used to repeatedly parse files and create records as desired in the database.

SECTIONLOADER natively supports ORACLE, MS SQL Server and Firebird
Databases. With additional dlls (dynamic link libraries) all other databases can be supported. For more advanced users, the tool also provides a full proprietary scripting language to do custom processing during the during the file parse and record preparation process.

The combination of SEGMENTTREE and SECTIONLOADER provides the complete ETL processing and file integration environment for any organization.

XML FLATTENER

XML FLATTENER converts XML files into standard text files with key strings indicating of the different records. This conversion makes the data available for import into applications that do not read XML directly.

Therefore, custom code need not be written just to bring in XML data for use by legacy programs.

For more detail on SEGMENTTREE, SECTIONLOADER and XML FLATTENER, please contact sales@clearcycle.com. You can also use our download section for a free  15 day trial version.