{"type":"doc","content":[{"type":"paragraph","content":[{"text":"This page provides general guidelines on how to set up Snowflake Storage to work with Datavard Storage Management.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"1. General prerequisites","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1.1 Open Ports","type":"text"}]},{"type":"paragraph","content":[{"text":"In order to enable communication of SAP systems with Snowflake host, the following port numbers should be reachable from the SAP system:","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#f0f0f0","rowspan":1,"colwidth":[48.0]},"content":[{"type":"paragraph","content":[{"text":"Port","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f0f0f0","rowspan":1,"colwidth":[92.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[620.0]},"content":[{"type":"paragraph","content":[{"text":"Snowflake Host","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[48.0]},"content":[{"type":"paragraph","content":[{"text":"443","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[92.0]},"content":[{"type":"paragraph","content":[{"text":"https","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[620.0]},"content":[{"type":"paragraph","content":[{"text":"...snowflakecomputing.com","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1.2 Warehouse and Database","type":"text"}]},{"type":"paragraph","content":[{"text":"Snowflake warehouse and database must already exist.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"1.3 Snowflake user","type":"text"}]},{"type":"paragraph","content":[{"text":"Snowflake user must be created. ","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"2. OS prerequisites (On SAP host)","type":"text"}]},{"type":"paragraph","content":[{"text":"This group of requirements relates to the operating systems underlying the SAP system with all its application servers. Datavard products (e.g. Datavard Glue, OutBoard DataTiering) have been developed and tested on the SUSE Linux environment and Windows Server 2012. However, by design, they are not limited by the choice of an operating system, if the requirements listed in this guide are met.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"2.1 OS directories","type":"text"}]},{"type":"paragraph","content":[{"text":"Datavard connector uses a directory dedicated to its configuration files:","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[760.0]},"content":[{"type":"paragraph","content":[{"text":"$ ls -ld /sapmnt//global/security/dvd_conn","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"rwx------ 2 dvqadm sapsys 4096 --- /sapmnt//global/security/dvd_conn","type":"text","marks":[{"type":"code"}]}]}]}]}]},{"type":"paragraph","content":[{"text":"The folder is used to store drivers and is shared among SAP application servers. Set the ownership and permissions appropriately to adm.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"2.2 JDBC Drivers","type":"text"}]},{"type":"paragraph","content":[{"text":"JDBC protocol is used to connect to Snowflake. Snowflake JDBC driver must be manually stored on the operating system and be accessible to the Datavard connector. ","type":"text"},{"text":"Download Snowflake JDBC driver","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/user-guide/jdbc-download.html#downloading-the-driver"}}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"We recommend storing the drivers in a folder within the connector directory, organized in sub-folders to avoid possible conflicts.","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[760.0]},"content":[{"type":"paragraph","content":[{"text":"$ ls -ld /sapmnt//global/security/dvd_conn/*","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"drwxr-xr-x 2 dvqadm sapsys 4096 --- /sapmnt//global/security/dvd_conn/snowflake","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"$ ls -l /sapmnt//global/security/dvd_conn/snowflake","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"drwxr-xr-x 2 dvqadm sapsys 4096 --- /sapmnt//global/security/dvd_conn/snowflake/snowflake-jdbc-3.12.9.jar","type":"text","marks":[{"type":"code"}]}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"3. SAP configuration","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"3.1 Datavard JAVA connector","type":"text"}]},{"type":"paragraph","content":[{"text":"Java connector is a critical middle-ware component. Please follow the steps in ","type":"text"},{"text":"Java Connector Setup","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/DATAVARD/pages/3266838670"}}]},{"text":" to set it up/upgrade to a new version before you continue. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":1204,"id":"3a72d3c5-3807-4ec0-989c-1730e4b6213a","collection":"contentId-3266806037","type":"file","height":274}}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"Java runtime environment","type":"text","marks":[{"type":"link","attrs":{"href":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/3266838670/SM-2105+Java+Connector+Setup#Java-runtime-environment-%5BinlineExtension%5D"}}]},{"text":" is narrowed per Snowflake JDBC driver requirement and must be installed in a 64-bit environment and requires Java 1.8 (or higher).","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"3.2 Storage Management setup","type":"text"}]},{"type":"paragraph","content":[{"text":"The final step in SAP & Snowflake connectivity is the creation of two storages in transaction ","type":"text"},{"text":"/DVD/SM_SETUP","type":"text","marks":[{"type":"code"}]},{"text":" - Snowflake storage which represents the table level of Snowflake infrastructure and the flat Snowflake stage which handles temporary files.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"3.2.1 Snowflake Stage (SNOW_STAGE)","type":"text"}]},{"type":"paragraph","content":[{"text":"It is binary storage pointing to the Internal Stage of the Snowflake user. For loading/unloading data uses extended functionality of Snowflake JDBC driver. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Storage ID","type":"text","marks":[{"type":"code"}]},{"text":" - logical name of the storage connection","type":"text"},{"type":"hardBreak"},{"text":"Storage type","type":"text","marks":[{"type":"code"}]},{"text":" - SNOW_STAGE (Snowflake internal stage)","type":"text"},{"type":"hardBreak"},{"text":"Full name of Snowflake account","type":"text","marks":[{"type":"code"}]},{"text":" - .. more information in ","type":"text"},{"text":"Snowflake account name doc","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/user-guide/connecting.html#your-snowflake-account-name"}}]},{"text":".","type":"text"},{"type":"hardBreak"},{"text":"User","type":"text","marks":[{"type":"code"}]},{"text":" - Snowflake user","type":"text"},{"type":"hardBreak"},{"text":"Password","type":"text","marks":[{"type":"code"}]},{"text":" - user password","type":"text"},{"type":"hardBreak"},{"text":"Password for JDBC Connection is Hashed","type":"text","marks":[{"type":"code"}]},{"text":" - indicator whether the password is hashed (you can create a hash of the password by using report /DVD/XOR_GEN)","type":"text"},{"type":"hardBreak"},{"text":"Java connector RFC","type":"text","marks":[{"type":"code"}]},{"text":" - TCP/IP RFC destination used for communication with Datavard Java connector","type":"text"},{"type":"hardBreak"},{"text":"Driver path","type":"text","marks":[{"type":"code"}]},{"text":" - Snowflake driver directory path","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":690,"id":"27441ab8-b5a1-4f25-ac34-fe9ca8b133fe","collection":"contentId-3266806037","type":"file","height":286}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"3.2.2 Snowflake Storage (SNOWFLAKE)","type":"text"}]},{"type":"paragraph","content":[{"text":"It is transparent storage pointing to Snowflake Database. For sending SQL commands data uses Snowflake JDBC driver. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Storage ID","type":"text","marks":[{"type":"code"}]},{"text":" - logical name of the storage connection","type":"text"},{"type":"hardBreak"},{"text":"Storage type","type":"text","marks":[{"type":"code"}]},{"text":" - SNOWFLAKE (Snowflake transparent storage)","type":"text"},{"type":"hardBreak"},{"text":"Full name of Snowflake account","type":"text","marks":[{"type":"code"}]},{"text":" - .. more information in ","type":"text"},{"text":"Snowflake account name doc","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/user-guide/connecting.html#your-snowflake-account-name"}}]},{"text":".","type":"text"},{"type":"hardBreak"},{"text":"Warehouse","type":"text","marks":[{"type":"code"}]},{"text":" - name of an existing warehouse in Snowflake","type":"text"},{"type":"hardBreak"},{"text":"Database","type":"text","marks":[{"type":"code"}]},{"text":" - name of an existing database in Snowflake","type":"text"},{"type":"hardBreak"},{"text":"Database schema","type":"text","marks":[{"type":"code"}]},{"text":" - name of an existing database schema in Snowflake","type":"text"},{"type":"hardBreak"},{"text":"User","type":"text","marks":[{"type":"code"}]},{"text":" - Snowflake user","type":"text"},{"type":"hardBreak"},{"text":"Password","type":"text","marks":[{"type":"code"}]},{"text":" - user password","type":"text"},{"type":"hardBreak"},{"text":"Password for JDBC Connection is Hashed","type":"text","marks":[{"type":"code"}]},{"text":" - indicator whether the password is hashed (you can create a hash of the password by using report /DVD/XOR_GEN)","type":"text"},{"type":"hardBreak"},{"text":"Referenced storage","type":"text","marks":[{"type":"code"}]},{"text":" - Snowflake stage storage used for staging temporary files while reading from/writing to Snowflake","type":"text"},{"type":"hardBreak"},{"text":"Driver path","type":"text","marks":[{"type":"code"}]},{"text":" - Snowflake driver directory path","type":"text"},{"type":"hardBreak"},{"text":"Java connector RFC","type":"text","marks":[{"type":"code"}]},{"text":" - TCP/IP RFC destination used for communication with Datavard Java connector","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":709,"id":"0a583aa4-d4a7-4a99-9457-18a152735e75","collection":"contentId-3266806037","type":"file","height":394}}]},{"type":"paragraph"}],"version":1}

Browser not supported