Export ODBC to AZ Blob Storage in XLSX

Fast, parallel data export with zero intermediate storage

Terminal

.\FastBCP.exe `
--connectiontype "odbc" `
--dsn "DSN_4_DATASOURCE" `
--database "tpch" `
--trusted `
--sourceschema "tpch10" `
--sourcetable "orders" `
--query "SELECT * FROM tpch10.orders" `
--directory "abs://storageaccount.blob.core.windows.net/fastbcpoutput/raw/{sourcedatabase}/{sourceschema}" `
--fileoutput "{sourcetable}.xlsx" `
--decimalseparator "." `
--dateformat "yyyy-MM-dd HH:mm:ss" `
--encoding "UTF-8" `
--method "Ntile" `
--distributekeycolumn "o_orderkey" `
--paralleldegree -2 `
--merge false `
--runid "runidfromcaller"

Get FastBCP

Source - ODBC

ODBC (Open Database Connectivity) allows connection to virtually any database. FastBCP supports ODBC connections for maximum compatibility.

Features:

•Compatible with any database supporting ODBC
•Maximum flexibility
•Standard ODBC driver support

Parallel Method - Ntile

Divides data into N equal partitions based on a numeric column.

Requirement: Requires a numeric distribution column

Available parallel methods with ODBC:

Output Format - Excel (XLSX)

The Excel XLSX format is ubiquitous in enterprise environments. FastBCP exports directly to Excel format, ready to open in Microsoft Excel or compatible tools.

Features:

•Native Excel format (Office Open XML)
•Automatic column headers
•Data type formatting (numbers, dates)
•Ready for business reporting

Destination - Azure Blob Storage

Azure Blob Storage is Microsoft's object storage solution. FastBCP uploads files to Azure containers with optimized block upload for maximum throughput.