(Glue 2402) App Quick Start

Owned by SNP
Feb 22, 2024
2 min read

After downloading and installing the App, there are a few steps necessary to set up.

  1. Grant authorizations to the user of the App.

    GRANT APPLICATION ROLE SNP_GLUE_UI TO ROLE "<Account role>"; GRANT APPLICATION ROLE SNP_GLUE_SAP TO ROLE "<Account role>";

  2. Grant authorizations to the technical user used with SNP Glue™ add-on for SAP.

    GRANT APPLICATION ROLE SNP_GLUE_CORE TO ROLE "<Account role>"; GRANT APPLICATION ROLE SNP_GLUE_SAP TO ROLE "<Account role>";

  3. Add database and/or source for the SAP system that will be sending the data.

  4. Define settings in the App for the SAP system (warehouse, frequency of tasks, suffix for historical table, etc.). By default, the first available warehouse, alphabetically, is assigned to a new source.

  5. Configure SNP Glue™ with the App settings (DB name and schema) and select Snowflake App integration.

  6. Add SAP data into replication in SNP Glue™ and start sending data into Snowflake.

These steps define a working real-time SAP data replication solution that provides immediate data consumption. Architecture describing this process is a part of the documentation too.