BCP and ISQL on Unix/Linux to SQL Server, Oracle, Sybase, DB2 and something blue

BCP and ISQL on Unix/Linux to SQL Server, Oracle, Sybase, DB2 and something blue

Posted on July 20, 2011 0 Comments

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.

BCP vendor comparison on Unix/Linux

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:

  • Stream data using bulk load between two data sources via GUI or command line
  • Interactively export/load CSV files to and from any data source via GUI or command line
  • Execute ISQL scripts against any data source

The reason we ship our source code is so that you can "borrow" our utilities and customize them for your internal use!

Bulk Load on Unix/Linux to SQL Server

Summary of bcp/isql related sample utilities available from Progress DataDirect:

  • bulk CSV- $ODBCHOME/samples/bulk
  • bulk stream - $ODBCHOME/samples/bulkstrm
  • SQL prompt - $ODBCHOME/samples/example
  • Extended SQL prompt (exampleex) - extended version of example available from customer support.
  • Full featured ISQL interactive sql for odbc (odbcisql) - Installed with OpenAccess Client for ODBC driver.

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 Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.


Comments are disabled in preview mode.

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation