Extract | Transform | Load (ETL) Services

High Speed ETL Big Data Transformation | Document & File Type Conversions

CCBD ETL is used to mine through your Big Data Warehouse and build HTML5 content-rich documents for storage in your Content Services Platform Solution such as Hyland OnBase, Microsoft SharePoint, or other software offerings. CCBD ETL is made up of a configurable, data transformation automation WorkBot that creates patient records (forms) populated with historical data from a Big Data Warehouse. CAPSYS enables an I.T. Administrator or Business Analyst to map data elements to an HTML5 (eForm) template, create the output file(s), and documents and render them as an HTML5, TIF or Adobe searchable PDF document.  The resulting documents are stored and managed alongside existing patient records (with similar patient meta-data) within a Content Services Platform such as Hyland OnBase, Microsoft SharePoint, or other Content platforms.

CAPSYS Rendition Document Conversion QSX is a CAPSYS Server extension designed to create an image or PDF renditions of raw data streams or Microsoft Office® documents including Word, Excel, PowerPoint as well as HTML, email and PDF formats. In addition, CAPSYS Rendition Document Conversion QSX standardizes captured images by correcting resolution (DPI) and bit depth so that downstream document processing applications such as forms recognition and OCR function properly.

CAPSYS Rendition can also be used to Extract | Transform | Load content from legacy ECM systems to rapidly convert meta-data and content from one ECM platform to another. Because CAPSYS Rendition can leverage the entire framework of CAPSYS CAPTURE - including our rules based workflow engine to manage exceptions and RESTful API's, CAPSYS Rendition is frequently used to manage large ECM platform conversion and migration projects. 

CAPSYS Rendition Document Conversion works at the batch or individual document level in a CAPSYS CAPTURE workflow to create image or PDF renditions of Microsoft Office documents. In addition, CAPSYS Rendition Manager processes the images that already exist in a document or batch and adjusts the bit depth quality and overall resolution of the images. This ensures that downstream processes that rely on uniform images will perform properly.




CCBD ETL is the perfect complement to your Big Data Warehouse initiatives.  With CCBD ETL, now Big Data Supportyou have the ability to take all that data that is currently locked up in your data warehouse and turn it into usable documents that can be used by your Customer Service, Research and Development, Customers, Sales and Marketing departments by storing them in your Content Services Platform solutions such as Hyland OnBase, OpenText, Microsoft SharePoint.

CCBD ETL includes the following features:CCBDS

  • HTML5 Forms Designer
  • Automated Big Data Warehouse Document Processor
  • Exception Handling
  • Adobe Acrobat (.pdf), TIF or HTML5 Document Output
  • Export Services to your favorite Content Services Platform Solution provider


Key Features and Benefits


illustration of rendition Rendition Document Conversion QSX from CAPSYS converts the following file types to TIFF or PDF:
  • Microsoft Word (.doc, .docx, .dot, .txt, .rtf, .wps, .wpt, .wpd, .js, .asp, .ini, .bat)
  • Microsoft Excel (.xls, xlsx, .dat, .csv)
  • Microsoft PowerPoint (.ppt, .pptx)
  • Microsoft Outlook (.msg, .oft, .htm)
  • HTML (.htm, .html, .mht)
  • Adobe Acrobat (.pdf)

Rendition Document Conversion QSX also creates an image (TIFF) or searchable PDF rendition, adjusting the bit depth (monochrome, grayscale) and resolution of existing images and supports TIF, BMP, JPEG, PCX, TGA, GIF, PNG, and MDI image formats. CAPSYS CAPTURE Rendition Document Conversion includes a built-in SMTP email interface that can be used to transmit messages about failed document conversions.

Integration with CAPSYS Scripts, CAPSYS Reports, and other CAPSYS modules are also included.  Rendition Document Conversion QSX is a thread-safe, multi-threaded extension module that speeds overall operations for maximum throughput.

Mixed Document Types and Formats? Image Conversion QSX Can Help

CAPSYS makes it easy to capture a mixture of image and non-image files. With the addition of CAPSYS Image Conversion QSX, the problems associated with processing all of these different types of files is eliminated. Image Conversion QSX can be used to control the resolution and bit depth settings that the users select when scanning. Image Conversion QSX can adjust the resolution and bit depth of the captured images automatically, and can create searchable PDF renditions as long as the files that are being processed are searchable (Word, Excel, Email, PowerPoint, HTML, text, etc.).