DOC1 Data Flow for Data Cleansing & Integration
The powerful data integration technology for automated document composition and delivery.
Faster and more flexible access to data
Automated document composition systems are only effective with good data. But that data may reside in a variety of systems and formats. Enhanced flexibility in data usage allows users to easily create personalized documents using a variety of different data sources – without changing the document’s underlying layout and design. DOC1 Dataflow™ provides the advanced data integration technology you need.
Dataflow is a general-purpose, pipelined data processing engine that uses transformation objects to implement data integration, data analysis and information delivery services. Dataflow fundamentally changes the way that data is accessed and integrated, making it easy for you to extend the accessibility and usefulness of corporate data. Using a unique visual diagramming workbench, business analysts and IT professionals can design data flow plans that create data warehouses, perform business analyses and deploy content to users and applications over the Web.
Dataflow technology combines ETL (Extract, Transform and Load), EII (Enterprise Information Integration) and BI (Business Intelligence) in a single-source solution.
DOC1 Series 5 features a highly scalable architecture that makes it possible to simultaneously read large amounts of data from heterogeneous sources, apply sophisticated algorithms, and then send the resulting information to any target source such as a flat file, a delimited file or an XML file for use by DOC1. With DOC1, the biggest hurdle to producing consolidated statements – extracting and consolidating data from multiple sources – is a thing of the past.
Access diverse data sources
DOC1’s unique visual diagramming workbench allows users to extract and transform data natively from a variety of sources, including: RDBMS (Oracle, Microsoft® SQL Server®, Sybase®, Redbrick®, Informix®, DB2®; XML Files; Flat Files; CSV Files; Legacy Mainframe Systems; ODBC; OLEDB; and a variety of business applications (Peoplesoft®, Oracle® Financials, SAP®, Siebel®, JD Edwards®, etc.).
More data integration convenience
Version 5.4 makes it even easier to integrate DOC1 data with Dataflow™ data integration solution, which has the ability to export data files with associated XML schema that describe the data structure. DOC1’s Data Format Editor can now import these types of data files, so you can automatically mark up associated data using the editor.
To gain more flexible access to your data for document composition, contact us today.
NOTICE: Because we offer many custom solutions, it is our policy not to post pricing on our website. Please contact our knowledgeable staff to select and price products that fit your organization's budget, number of users, IT environment, data requirements, support and training needs. We apologize for any inconvenience.
Access, transform and analyze data faster
DOC1 Dataflow™ allow users to rapidly access, connect, integrate and analyze data from a wide array of applications, databases, and data files. It also helps users quickly and easily incorporate any combination of these data sources into a single process. While other systems require you to perform join functions within the database, Dataflow joins two or more sources in memory, making it easier to analyze or perform operations on data from multiple sources.
Easier migration between development and production environments
Why deal with hard-coded connection parameters? You don’t have to with Dataflow. Just point your plan to the desired environment, eliminating the need to create multiple plans. If you are working in a large scale application, you can also work in physically partitioned arenas.
Reusable sub-component support
Increase your productivity by reusing already developed modules as you would a subroutine; A very user friendly feature for developers and business analysts. Common functionality used in different places can be developed, maintained and managed centrally to reduce redundancies that waste time and allow for error.
Unicode support
Global enterprises that need to glean data from around the world will find Dataflow’s Unicode support a huge benefit. Unicode which enables all international character sets means that no matter where the work is done, it can be collected and stored from around the globe.
Improved look-up performance and functionality
Perhaps the most widely utilized Dataflow transforms is the “key look-up,” enhanced for greater productivity and ease of use. Now you can return multiple columns in one transform, simplifying your plan. New comparison operators have been added which greatly reduces the number of manual modifications. And the memory and caching of the key look-up has been reconfigured for stronger performance.
New transforms for greater efficiency
The latest release of Dataflow packages three new transforms that were designed specifically at the request of our user community. They are: Mark Duplicate Rows; Filtered Splitter; and Multi-Condition Filter. These transforms enhance productivity and speed up the development process.
Automatic documentation of flow
Eliminate the burden of documentation for development while enhancing the quality of the development process altogether – with Dataflow, the documentation is done automatically and generated into an HTML file.
Track plan changes
So, how did we get to this point? Every data analyst knows that meticulous recording of plan changes is required to identify who changed what and when, and also how and what was changed. This was often a laborious manual effort. No more. Dataflow now documents this automatically so you can focus on moving the plan forward, increasing efficiency and productivity.
Our products are designed to work within a wide variety of existing technical environments.
Supported Operating Systems:
Server Operating Systems
- UNIX®:AIX 5.1. HP-UX 11i, Solaris®8or 9
- Windows®2000 or 2003
Client Operating Systems
Windows Vista®,XP, 2000 or 2003
Supported Databases:
- Microsoft®SQL Server 6, 7 and 2000
- Oracle®7, 8i and 9i
- IBM®DB2 6.1, 7.2, and 8.0
- IBM®DB2 for AS400 V4R4
- IBM®DB2 for OS390 v5 and v6
- AS400
- Sybase®11, 12, and 12.5
- Informix®7, 8, and 9
- RedBrick®5.0.12 and 6
- MySQL 4.1.4
- ODBC
- XML
- Delimited Text Files
- Fixed Width Text Files
- Hierarchical Files
- SAP R/3
- Multiple ERP and CRM Solutions
Supported Languages:
- English
- Japanese
- Korean
- Simplified Chinese
- German
- French
Support
- Sign in to the DOC1 Data Flow support area for downloads, licensing and documentation
- Contact Support
- Training