Get Started
Describes how to get started with HPE Ezmeral Unified Analytics Software.
Administration
Provides information about managing applications and clusters in HPE Ezmeral Unified Analytics Software.
Security
Describes security in HPE Ezmeral Unified Analytics Software.
Observability
Describes observability in HPE Ezmeral Unified Analytics Software.
Data Engineering
Data engineers can design and build pipelines that transform and transport data into usable formats for data consumers.
- Accessing Data in External S3 Object Stores
  Describes how to access data in external object stores from clients such as Spark and Kubeflow notebooks.
- EzPresto
  Describes the EzPresto SQL query engine and its featues.
  - Connecting Data Sources
    Provides instructions for connecting HPE Ezmeral Unified Analytics Software to external data sources.
    - Delta Connection Parameters
      List of Delta connection parameters, descriptions, default values, and supported data types.
    - Delta Thrift Connection Parameters
      List of Delta Thrift connection parameters, descriptions, default values, and supported data types.
    - Hive Connection Parameters
      List of Hive connection parameters, descriptions, default values, and supported data types.
    - Hive Glue Metastore Connection Parameters
      List of Hive Glue Metastore connection parameters, descriptions, default values, and supported data types.
    - Hive Thrift Metastore Connection Parameters
      List of Hive Thrift Metastore connection parameters, descriptions, default values, and supported data types.
    - Hive Discovery Metastore Connection Parameters
      Lists Hive discovery metastore connection parameters, parameter descriptions, default values, and supported data types.
    - MySQL Connection Parameters
      List of MySQL connection parameters, descriptions, default values, and supported data types.
    - Oracle Connection Parameters
      List of Oracle connection parameters, descriptions, default values, and supported data types.
    - Snowflake Connection Parameters
      List of Snowflake connection parameters, descriptions, default values, and supported data types.
    - SQL Server Connection Parameters
      List of SQL Server connection parameters, descriptions, default values, and supported data types.
    - Teradata Connection Parameters
      List of Teradata connection parameters, descriptions, default values, and supported data types.
    - PostgreSQL Connection Parameters
      List of PostgreSQL connection parameters, descriptions, default values, and supported data types.
    - Iceberg Connection Parameters
      List of Iceberg connection parameters, descriptions, default values, and supported data types.
    - Configuring a Hive Data Source with Kerberos Authentication
      Describes the required prerequisite steps to complete before you connect HPE Ezmeral Unified Analytics Software to a Hive data source that uses Kerberos authentication.
  - Using MAPRSASL to Authenticate to Hive Metastore on HPE Ezmeral Data Fabric
    Describes how to create a Hive data source connection that uses MAPRSASL to authenticate to a Hive Metastore on HPE Ezmeral Data Fabric.
  - Connecting to CSV and Parquet Data in an External S3 Data Source via Hive Connector
    Describes how to use the Hive connector with Presto in HPE Ezmeral Unified Analytics Software to connect to CSV and Parquet data in S3-based external data sources.
  - Connecting External Applications to EzPresto via JDBC
    Describes how to connect external applications and BI tools, such as Tableau and PowerBI, to EzPresto through the EzPresto JDBC endpoint.
  - Using Spark to Query EzPresto
    Describes how to use Spark to query EzPresto.
  - Connecting to EzPresto via Python Client
    Provides information for connecting to EzPresto from a Python client.
  - Caching Data
    Describes data caching and provides the steps for caching data in HPE Ezmeral Unified Analytics Software.
  - Submitting Presto Queries from Notebook
    Describes how to submit Presto queries from the notebook.
- Airflow
  Provides an overview of Apache Airflow in HPE Ezmeral Unified Analytics Software.
- Superset
  Provides a brief overview of Superset in HPE Ezmeral Unified Analytics Software.
Data Analytics
Provides a brief overview of data analytics in HPE Ezmeral Unified Analytics Software.
Data Science
Provides a brief overview of data science in HPE Ezmeral Unified Analytics Software.
Notebooks
Provides a brief overview of Notebooks in HPE Ezmeral Unified Analytics Software.
Glossary
Definitions for commonly used terms in HPE Ezmeral Unified Analytics environments.

SQL Server Connection Parameters

List of SQL Server connection parameters, descriptions, default values, and supported data types.

The following sections list the required and optional SQL Server connection parameters.

Required Connection Parameters

The following table lists the required connection parameters:

Parameter	Description	Default Value	Data Type
Connection Url	JDBC connection url.	null	STRING
Connection User	Specifies the login name of the user for the connection.	null	STRING
Connection Password	Specifies the password of the user for the connection.	null	STRING
Enable Local Snapshot Table	Enable Caching while querying.	true	BOOLEAN

Optional Connection Parameters

The following table lists the optional connection parameters:

Parameter	Description	Default Value	Data Type
Case Insensitive Name Matching	Match schema and table names case insensitively.	false	BOOLEAN
Case Insensitive Name Matching Cache Ttl	Duration for which remote dataset and table names will be cached. Set to 0ms to disable the cache.	1m	DURATION
Allow Drop Table	Allow connector to drop tables.	false	BOOLEAN
Generic Cache Table Ttl	TTL for cache table expiry in minutes.	1440	INTEGER

Partners Support Dev-Hub Community Training ALA Privacy Policy Glossary

HPE Ezmeral Unified Analytics Software 1.5 Documentation
Abstract	HPE Ezmeral Unified Analytics Software is a usage-based Software-as-a-Service (SaaS) model that operationalizes hybrid and multi-cloud modern analytical workloads through a simple user interface, easily installed and deployed in minutes. HPE Ezmeral Unified Analytics Software separates compute and storage for flexible, cost-efficient scalability to securely access data stored in multiple data platforms, enabling you to run traditional and advanced analytics workloads with open-source tools.
Published	November 2024
Edition	1.5.0