The Data Management module offers advanced tools for data extraction and mapping to facilitate data collection. It allows you to effectively acquire, manage, and merge enterprise-level data running in various databases or data warehouses. In addition, it has a customer-facing interactive web interface for creating and scheduling data push/pull as well as back-office administration tools to automate and execute multi-channel campaigns.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------| Data Management |
Data acquisition--buy data, upload data, schedule data, pick up data via SFTP, Web Services and EDI |
Interactive drag-and-drop data mapping |
A Microsoft Excel-style formula language that includes a large library of built-in functions to handle complex mapping situations |
Support for Microsoft SQL Server, Oracle, MySQL, IBM DB2, Sybase, Microsoft Access databases, as well as various database connections |
Data transfer between tree layouts, such as XML files as well as other hierarchical layouts |
Easy-to-save and reuse data maps: Create once, save and use once, save and exit, save and use many times |
Aggregate mappings, group-by conditions |
One-to-many, many-to-one transfers allow you to pivot or un-pivot your data using a simple interface |
Bulk insert into various database destinations, and customize bulk insert settings for improved transfer performance |
Data models to allow and define contained and referencing relationships |
Data maintenance with many options for handling source/destination files, such as move, delete, or rename. |
Auto email notification with attachments such as source file, destination file, profiler file, or rejected records file |
Change all database connections simplifies your work if you need to quickly replace all database connections with other database connections as required by your environment. Achieved via a single and easy-to-use control. |
Transfers between XML files, as well as any combination of flat and tree sources, such as XML to flat file, flat file to XML, database to XML, XML to XML, etc. XML transfers support the concept of anchor, which lets you control how many destination records you want created for each source node |
XML/XSD Editor |