N. America: (800)876-3101 | World: +44 (0) 1-344-386-367

Bulk Load Use Cases

With Progress DataDirect Bulk Load, enterprise organizations effectively satisfy the bulk data access requirements for a broad array of data access use cases. In doing so, they simplify the data access architecture; save important resources for other tasks; and improve operational performance.

 

Enterprise Scenario

Progress DataDirect Bulk Load Capabilities

Data Warehousing – loading bulk data files into a data warehouse

Results prove that Progress DataDirect ODBC, JDBC, and ADO.NET Bulk Load delivers the fastest, best performance for loading bulk data into an Oracle, DB2, Sybase, or SQL Server-based data warehouse while avoiding data latency issues.

Data Migration – moving or copying data in tables from one database to another database

Progress DataDirect Bulk Load is ideal for simple extract and load data migration operations, moving bulk data from one database directly into the other by streaming, thus avoiding the need to load the data into memory.

Data Replication – taking bulk data files from a server or location and loading them into a database

Instead of using FTP or similar approaches for pushing files around a network, Progress DataDirect Bulk Load quickly loads the data you need into relational database tables. This approach is faster and provides the added benefit of storing the data as a relational database table easily accessed by reporting or BI applications.

Disaster Recovery – moving data into a backup, disaster recovery, or failover database

Disaster recovery is all about making sure that when a failure occurs, the backup database you are working with is as close to the original set of data as possible. Progress DataDirect Bulk Load ensures that any bulk data is quickly and easily replicated into disaster recovery databases.

Cloud Data Publication – loading bulk data files or tables into a cloud-based database

In cloud-based computing, efficient network usage is critical. As a result, performance is ever-important when moving bulk data files or database tables into a cloud-based database. Progress DataDirect Bulk Load allows developers to quickly and easily build a simple program that publishes bulk data into the cloud.