quick-start.md

Quick Start

Get up and running with hana-cli in 5 minutes.

Step 1: Verify Installation

hana-cli --version
# Output: hana-cli/x.x.x

Step 2: Check Your Connection

Ensure you have a default-env.json file with HANA credentials (see Configuration).

Test the connection:

hana-cli systemInfo

If this displays database information without errors, you're connected!

Step 3: Try Basic Commands

View database information

hana-cli systemInfo

List tables in the current schema

hana-cli tables 

Profile data in a table

hana-cli dataProfile -t EMPLOYEES

Step 4: Import Data

Create a CSV file (data.csv):

ID,Name,Age
1,Alice,30
2,Bob,25
3,Charlie,35

Import into a table:

hana-cli import -f data.csv -s MYSCHEMA -t EMPLOYEES -m name

Step 5: Export Data

Export table data to CSV:

hana-cli export -s MYSCHEMA -t EMPLOYEES -o output.csv

Common Tasks

Compare Two Schemas

hana-cli compareSchema -s SCHEMA1 -t SCHEMA2

Analyze Data Quality

hana-cli dataValidator -s MYSCHEMA -t EMPLOYEES

Find Duplicates

hana-cli duplicateDetection -s MYSCHEMA -t EMPLOYEES -c ID

Get Data Lineage

hana-cli dataLineage -s MYSCHEMA -t EMPLOYEES

Getting Help

Get help for any command:

# General help
hana-cli --help

# Command-specific help
hana-cli import --help
hana-cli export --help
hana-cli dataProfile --help

Next Steps

• Explore All Commands - View all 170+ commands
• Features & Integration
• Full API Reference
• Configuration Guide

Troubleshooting

Having issues? See the Troubleshooting Guide