Creating a SAP HANA source node - Amazon Glue
Prerequisites neededAdding a SAP HANA data source
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Creating a SAP HANA source node

Prerequisites needed

  • An Amazon Glue SAP HANA connection, configured with an Amazon Secrets Manager secret, as described in the previous section, Creating a SAP HANA connection.

  • Appropriate permissions on your job to read the secret used by the connection.

  • A SAP HANA table you would like to read from, tableName, or query targetQuery.

    A table can be specified with a SAP HANA table name and schema name, in the form schemaName.tableName. The schema name and "." separator are not required if the table is in the default schema, "public". Call this tableIdentifier. Note that the database is provided as a JDBC URL parameter in connectionName.

Adding a SAP HANA data source

To add a Data source – SAP HANA node:

  1. Choose the connection for your SAP HANA data source. Since you have created it, it should be available in the dropdown. If you need to create a connection, choose Create SAP HANA connection. For more information see the previous section, Creating a SAP HANA connection.

    Once you have chosen a connection, you can view the connection properties by clicking View properties.

  2. Choose a SAP HANA Source option:

    • Choose a single table – access all data from a single table.

    • Enter custom query – access a dataset from multiple tables based on your custom query.

  3. If you chose a single table, enter tableName.

    If you chose Enter custom query, enter a SQL SELECT query.

  4. In Custom SAP HANA properties, enter parameters and values as needed.