basiQa Solutions/ Data Management

Data Management

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.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Features

Custom Application Development for C-Level Value
Use basiQa's expertise and offshore development team for your IT projects Improve content and document management on an enterprise level and gain competitive advantage

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

	Home	Contact	Privacy	Login	Register

Copyright © 2010-2012 basiQa.com

Name* :
Organization* :
Email* :
Phone* :

Username :
Password :

Name*:
Email Address (basiQa ID)*:
Company* :