The Modernization Experts

 

DBintegrate - Frequently Asked Questions

Can I access my data using DBIntegrate?

DBIntegrate provides real-time, read-write access a wide range of different data sources. The list currently includes:

SQL Server databases, Oracle databases, DB2 databases, Sybase ASE databases, Sybase ADS databases, Sybase IQ databases, EXCEL worksheets, CSV text files, Micro Focus COBOL indexed files, ACUCOBOL indexed files, U/FOS hierarchical databases, PostgreSQL databases, MySQL databases, BB-ISAM indexed files, C-ISAM indexed files, D-ISAM indexed files, Sculptor data files, PROGRESS databases, FoxPro databases, MS Access databases.

This list is constantly expanding so please contact Transoft Customer Services if you don't see your data source on the list.


Can I define my entire data migration or ETL process using DBIntegrate?

A DBIntegrate project can include multiple data mapping processes involving any number of different data sources, as well as direct database access via SQL and steps that use operating system commands. The process can be scheduled and can also be integrated with email.


Can I send email notifications from my DBIntegrate project?

The DBIntegrate project designer allows specification of email steps at any stage during the process, possibly dependant on the outcome of previous steps.


What data transformation functions does DBIntegrate provide?

DBIntegrate includes a rich set of built-in functions for data mapping, data cleansing, data de-duplication and data profiling. This set of functions is growing continually but it can also be very easily extended by the DBIntegrate user. Simply create a .NET DLL that contains your processing functions, add the DLL to the list in the DBIntegrate configuration file, and go ahead with using your functions in any DBIntegrate process.


Can DBIntegrate be used to access data on platforms other than Windows?

DBIntegrate can access data on any networked platform via ODBC.


Can I schedule DBIntegrate projects to run regularly?

The DBIntegrate Project designer includes a Scheduler that allows complete flexibility. Schedule your DBIntegrate project to run at a specified date and time, on a regular weekday, every hour, day, week, month,... whatever you need.


Transoft is a trading name of Transoft Group Limited and Transoft Inc, part of the CSH Group of companies. Transoft is a trade mark. CSH is a trading name of Computer Software Holdings Limited and the CSH Group of Companies © Computer Software Holdings Limited. All rights reserved. All other marks are the property of their respective owners.