Sagent Data Flow for Business Intelligence Applications
Combine powerful data integration and location intelligence capabilities in a single solution
There are two daunting parts to achieving sound reports. One is accessing data from various sources. The other is manipulating the data to create meaningful reports. Sagent Data Flow™ is one solution that can quickly, easily and affordably bring both capabilities to you.
Sagent Data Flow from Pitney Bowes Business Insight is a powerful and flexible integration engine that brings together data from disparate sources into a single view where a comprehensive set of data transformation tools can merge and cleanse the data to enhance its business value. Once data is transformed, Sagent Data Flow provides a variety of tools for analyzing the information and creating meaningful reports for a better understanding of your business. Sagent Data Flow is a single solution for customer profiling, data warehousing, ETL and business intelligence – leveraging real data to make smarter decisions.
Quickly and easily see your data with a visual approach
Sagent Data Flow incorporates a powerful visual development environment that helps speed and simplify the creation of sophisticated data transformations, to support both business and technical users. Sagent Data Flow users can create a data integration plan and report more quickly. Its new and improved interface reduces the learning curve as it allows end users to master the solution more quickly than other Business Intelligence (BI) tools.
Supports many data formats for greater efficiency
Sagent Data Flow handles one of the widest varieties of data formats, from legacy applications to Web-based technologies. Available modules include Mainframe, AS/400 and R/3(SAP). And Sagent Data Flow natively handles all major RDBM systems, such as Oracle®, IBM® DB2 and Microsoft® SQL Server®, as well as most major text-based data formats, including XML. This ability to read data in its native format eliminates the time-consuming and expensive task of writing custom extract programs.
64-bit for faster processing
Sagent Data Flow features 64-bit processing power, for more memory, increased performance and greater scalability. It also supports a higher number of concurrent users, provides faster processing and handles larger data loads.
For more information on data management solutions to enhance enterprise business intelligence systems, 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
Sagent Data Flow™ allows 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, Sagent Data Flow 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 Sagent Data Flow. 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 Sagent Data Flow’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 Sagent Data Flow 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 Sagent Data Flow 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 Sagent Data Flow, 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. Sagent Data Flow now documents this automatically so you can focus on moving the plan forward, increasing efficiency and productivity.
Supported Operating Systems:
Server Operating Systems
- UNIX®:AIX 5.1, 5.3
- HP-UX 11i,
- Solaris® 9, 10
- Windows® 2003, and 2008*, 32 bit-bit and 64-bit systems
* Check the latest documentation for limitations.
Client Operating Systems
- Windows Vista®, XP, 2003, 2007 and 2008*
* Check the latest documentation for limitations.
Supported Databases:
- Microsoft®SQL Server® 9.0, 2000 and 2005
- Oracle® 9.2, 10.1, 10.2 and 11g
- IBM®DB2 8.0, 8.1, 8.2 and 9.1
- Sybase® 12.5 and 15.0
- Informix® 9 and 10
- RedBrick® 6.3
- ODBC
- ODBC connection to Netezza
- XML
- Delimited Text Files
- Fixed Width Text Files
- Multiple ERP and CRM Solutions
Supported Languages:
- English
- Japanese
- Simplified Chinese
- German
- French
Support
Data Sheets and Brochures
Case Studies
- Shenzhen Telecom Improves Customer Service through Better Bills
- Basler Kantonalbank (BKB)
- Grameenphone
- Spokane Teachers Credit Union
- eScholar
- Berliner Wasserbetriebe
- BECU (formerly Boeing Employees’ Credit Union)