Export SAP HANA to OneLake in Parquet
Fast, parallel data export with zero intermediate storage
Terminal
.\FastBCP.exe `
--connectiontype "hana" `
--server "host.domain | host.domain,port | host.domain,port/service" `
--database "tpch" `
--trusted `
--sourceschema "tpch10" `
--sourcetable "orders" `
--query "SELECT * FROM tpch10.orders" `
--directory "onelake://workspace/lakehouse/fastbcpexports/raw/{sourcedatabase}/{sourceschema}" `
--fileoutput "{sourcetable}.parquet" `
--method "Ntile" `
--distributekeycolumn "o_orderkey" `
--paralleldegree -2 `
--merge false `
--runid "runidfromcaller"Source - SAP HANA
SAP HANA is a high-performance in-memory database platform. FastBCP optimizes exports from HANA to leverage its capabilities.
Features:
- •Native SAP HANA connector
- •Support for views and columnar tables
- •Optimized for in-memory data
Parallel Method - Ntile
Divides data into N equal partitions based on a numeric column.
Requirement: Requires a numeric distribution column
Available parallel methods with SAP HANA:
Output Format - Apache Parquet
Parquet is a columnar file format optimized for analytical processing. FastBCP exports to Parquet with compression and type preservation, ideal for data lake architectures.
Features:
- •Columnar storage for efficient analytics
- •Integrated compression (Snappy, Gzip)
- •Full data type preservation
- •Optimized for big data tools (Spark, Hadoop)
Destination - Microsoft OneLake
OneLake is Microsoft Fabric's unified data lake. FastBCP exports data directly to OneLake workspaces, enabling seamless integration with Fabric analytics services.
Storage Type:
Unified Data Lake
Features:
- •Direct integration with Microsoft Fabric
- •Workspace and lakehouse support
- •Built on Delta Lake format
- •Unified analytics and governance
