/
SAP HANA Account

SAP HANA Account

    This page is no longer maintained (May 13, 2026). For the most current information, go to SAP HANA Account.

    In this article

    Overview

    You can use this account type to connect SAP HANA Snaps with data sources that use an SAP HANA account.

    sap-hana-account.png

     

    Account Settings

    • Expression : JavaScript syntax to access SnapLogic Expressions to set field values dynamically (if enabled). If disabled, you can provide a static value. Learn more.

    • SnapGPT : Generates SnapLogic Expressions based on natural language using SnapGPT. Learn more.

    • Suggestion : Populates a list of values dynamically based on your Account configuration.

    • Upload : Uploads files. Learn more.

    Learn more about the icons in the Snap Settings dialog.

    Field/Field type

    Description

    Label
    String

     

    Required. Specify a unique name for the account instance.

    Default value: None
    Example: SAP HANA Account

    Account properties*

    Hostname*
    String/Expression

    Required. Specify the database server hostname.

    Default value: [None]
    Example: localhost

    Port number*
    String/Expression

     

    Required. Specify the database server's port number.

    Default value: 30015
    Example: 30015

    Database name*
    String/Expression

    Required. Specify the name of the database to connect.

    Default value: [None]
    Example: sample

    When configuring a SAP account to connect to SAP DWC, enter the Database name in the following format:

    Database name: <Space Schema Name>

    For the account to work as expected, you must do the following:

    Username
    String/Expression

     

    Specify the database username to use in the following format:
    Username: <Database User Name>

    Default value: [None]
    Example: Snapuser

    Password
    String/Expression

     

    Specify the password to use the database.

    Default value: [None]
    Example: Snapuser

    JDBC JARs

    The JDBC JAR files to be loaded.

    JDBC driver
    String

    Select the JDBC driver to use. The default driver is included in the Snap. If the user wants to override it then upload the jar here.

    Default value: [None]

    JDBC driver class*
    String

     

    Specify the JDBC Driver class name to use.

    Default value: [None]
    Example: com.sap.db.jdbc.Driver

    Advanced Properties

    Auto commit
    String/Expression/Checkbox

     

    Select this checkbox to commit the individual batches immediately after execution. If the Snap fails, only the batch being executed at that moment is rolled back.

    When deselected, the Snap execution output is committed only after all the batches are executed. If the Snap fails, the entire transaction is rolled back, unless the Snap detects invalid input data before sending the insert request to the server and routes the error documents to the Error view.

    Default value: Selected

    Fetch size
    String/Expression

     

    Required. Specify the number of records to retrieve from the DB per request.

    Default value: 100
    Example: 100

    Batch size
    String/Expression

     

    Required. Specify the number of statements to execute at a time.

    Default value: 1000
    Example: 1000

    Min pool size
    String/Expression

    Required. Specify the minimum connection pooling size to use.

    Default value: 1
    Example: 1

    Max pool size
    String/Expression

    Required. Specify the maximum connection pooling size to use.

    Default value: 10
    Example: 10

    Max lifetime (minutes)*
    String/Expression

    Required. Specify the maximum lifetime of a connection in the pool. Ensure that the value you enter is a few seconds shorter than any database or infrastructure-imposed connection time limit. A value of 0 indicates an infinite lifetime, subject to the Idle Timeout value. An in-use connection is never retired. Connections are removed only after they are closed.

    Default value: 30

    Idle timeout (minutes)*
    String/Expression

    Required. Specify the maximum time a connection is allowed to remain idle in the pool. A value of 0 indicates that idle connections are never removed from the pool.

    Default value: 5

    Checkout timeout (milliseconds)*
    String/Expression

     

     

    Specify the maximum time, in milliseconds, the system should wait for a connection to become available when the pool is exhausted.

    If you provide 0, the Snap waits infinitely until the connection is available. Therefore, we recommend that you do not set the Checkout timeout to 0.

    For any value other than 0, the Snap displays an exception after the wait time has expired.

    Default value: 10000
    Example: 9000

    Minimum value: 0
    Maximum value: No limit

    URL properties    

    Specify the properties to use.

    URL property name
    String/Expression

    Specify the URL property name.

    Default value: NA
    Example: maxAllowedPacket

    URL property value
    String/Expression

    Specify the value for the URL property

    Default value: NA
    Example: 1000

    Auto Commit with Execute Snaps

    For a DB Execute Snap, assume that a stream of documents enters the input view of the Snap and the SQL statement property has JSON paths in the WHERE clause. If the number of documents are large, the Snap executes in more than one batches rather than executing one per each document. Each batch would contain a certain number of WHERE clause values. If Auto commit is turned on, a failure would only roll back the records in the current batch. If Auto commit is turned off, the entire operation would be rolled back. For a single execute statement (with no input view), the setting has no practical effect.

    Enabling SSL in the SAP HANA Account

    Prerequisites

    • The keystore is present in the SAP HANA instance.

    • You have the keystore's location and password.

    To enable SSL, configure the following URL properties:

    • encrypt: Set to true to enable SSL encryption.

    • validateCertificate: Set to true to validate the server certificate.

    • keyStore: Enter the location of the keystore.

    • keyStorePassword: Enter the keystore's password.

    enabling-ssl-in-sap-hana-acct.png

    There are additional applicable URL properties beyond those mentioned above. Learn more: Client-Side TLS/SSL Configuration Properties (JDBC) for details on all URL properties. 

     

    SAP HANA Snap Pack

    Related Links