Home Services Partners Company
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

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

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. 

Read next Standards-Based Connectivity vs. Native Coding: What’s Best?
Comments are disabled in preview mode.