The wedding tradition in the States is to have something old, something new, something borrowed and something blue.
And the data access geek in you is thinking: "Use the blue font on Putty to your Unix/Linux server to launch Progress DataDirect's new standards based bulk utilities and samples." After working with several financial services organizations, I have observed this tradition has indeed become a trend:
Old: BCP and ISQL are trusted utilities for Sybase and SQL Server shops that started out running on Windows Servers. These environments have since grown to include new platforms and databases that need to support existing BCP and ISQL scripts and functionality.
New: Progress DataDirect's unique standards based approach to bulk is interoperable with major databases including SQL Server, Sybase, Oracle and DB2. And the drivers and sample utilities to run BCP and ISQL are supported on the latest virtual and non-virtualized enterprise servers including both 32-bit and 64-bit flavors Windows, AIX, Solaris, HP-UX, and Linux. Our users have been completely blown away testing DataDirect bulk firsthand concluding that it is faster than native BCP with additional functionality that includes bulk replay, fault tolerance, and tuning.
Borrowed: The initial feedback from customers and prospects of the new out-of-box code sample utilities installed with the Connect for ODBC 6.1 drivers has been phenomenal. We ship a variety of code samples with source code and make files that can:
The reason we ship our source code is so that you can "borrow" our utilities and customize them for your internal use!
Summary of bcp/isql related sample utilities available from Progress DataDirect:
Get started today:
Download and test drive our bulk BCP and ISQL out-of-box samples today! Or call 1-800-876-3101 to speak with a Solutions Consultant to learn more about how other organizations are making Progress with DataDirect Bulk.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.