{"type":"doc","content":[{"type":"paragraph","content":[{"text":"The purpose of this page is to provide a single point of truth for SOW Prerequisites for each storage type that Storage management (SM) supports. The content should be in a form that can be copy-pasted to Word documents with minimal need for adjustments.","type":"text"}]},{"type":"paragraph"},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"maxLevel":{"value":"1"}},"macroMetadata":{"macroId":{"value":"a1e1e665-358b-4a03-8e25-92b9aa4f97ec"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}}}},{"type":"heading","attrs":{"level":1},"content":[{"text":"General prerequisites","type":"text"}]},{"type":"paragraph","content":[{"text":"These prerequisites are necessary for every storage in SM and are complementary to prerequisites specific to single storage.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 1: “Remote connection - OSS or alternative connection”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein remotely Customer must open an OSS connection (","type":"text"},{"text":"Type R3 Support","type":"text","marks":[{"type":"underline"}]},{"text":") by creating an OSS ticket to the XX-PART-DVD component and store the user information in the secure area. Customer can also provide access through alternative service, for example by onboarding a DATAVARD employee and giving him access to corporate VPN.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the connection is not granted the project timeline might be prolonged.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its basis team for possible remote connection alternatives.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 2: “User authorization”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must create an SAP user with proper authorization and approval to operate within SAP environment using a combination of dialog and batch processing in SAP system. It is expected that users should be at least authorized to execute the following transactions: /DVD/*, RSA1, ST04, DB02, DB20, SM37, SM50, SM51, ST11, SE16; SE37, SE38, SM59, FILE, STRUST, SMGW.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the authorization is not granted DATAVARD consultants will be not able to perform any activity related to SAP system.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD for details on needed authorizations.","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 3: “DATAVARD transports”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" Customer must import transports containing DATAVARD software required to establish the connection. that are provided by DATAVARD consultants. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the DATAVARD software is not imported into the SAP system, the connection can’t be established. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD for required software transports.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Hive (Impala)","type":"text"}]},{"type":"paragraph","content":[{"text":"These prerequisites are meant to be used when customer is looking for a connection to a traditional Hadoop platform (Cloudera, Hortonworks, MapR), or some cloud distributed Hadoop platforms (Amazon EMR, Azure HDInsight). Connection to Hive also requires a connection to HDFS, so prerequisites for both services are documented here.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 4: “SAP and Hadoop platform connectivity”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have a working network connection with sufficient bandwidth and stability between the SAP system and Hadoop platform. Specifically, outbound traffic from the SAP must be open to individual Hadoop components (Hive server, Impala daemon, HttpFS, WebHDFS, Datanodes, load balancers, etc..) and inbound traffic coming from the SAP system must be allowed on Hadoop services. DNS hostname resolution (also reverse) has to be working properly between SAP application servers and Hadoop hosts.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the communication is not configured prior to DATAVARD activities, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its security/network team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 5: “Hadoop components and configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have at least following Hadoop components available and configuration applied.","type":"text"}]},{"type":"paragraph","content":[{"text":"Hadoop Components ","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hive 1.1.0 and higher ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Impala 2.3.0 and higher (optional)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The default installation of httpFS or webHDFS (httpFS recommended)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Hadoop configuration","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create Hadoop technical user to be used per connected SAP system and provide it’s authentication details","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create HDFS location to be used as a temporary landing zone","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create Hive database per connected SAP system","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Define Sentry/Ranger rules (for secure deployment) for Hive database and HDFS location","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If components are not available, and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its Hadoop platform team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 6: “SAP system configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have the following SAP components available and configuration in place for SAP application servers and SAP system.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP release 7.01 SP15 or higher","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Http/https service running and available in SAP (by default available)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Required SSL certificates are imported to STRUST","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP Java Connector 3.0 library is available in LD_LIBRARY_PATH of adm user on every application server","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Technical user of type communication data is created in SAP","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The technical user has following authorization: object S_RFC with function group SYST, RFC1, SDIFRUNTIME and activity 16 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Program DATAVARD_JAVA_CONN is allowed to register on the SAP gateway (by default wildcard (*) is set)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Appropriate JDBC drivers are installed on the application server","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the SAP components are not available and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its SAP team for details on steps needed","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":1},"content":[{"text":"HDFS","type":"text"}]},{"type":"paragraph","content":[{"text":"The following prerequisites are suitable for customer who seek connection to a traditional Hadoop platform, but only want file-based extraction to HDFS (no Hive, Impala). If customer also wants connection to Hive (Impala) use prerequisites above.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 4: “SAP and Hadoop platform connectivity”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have a working network connection with sufficient bandwidth and stability between the SAP system and Hadoop platform. Specifically, outbound traffic from the SAP system must be allowed to individual Hadoop components (HttpFS, WebHDFS, Datanodes, load balancers, etc..) and inbound traffic coming from the SAP system must be allowed on Hadoop environment. DNS hostname resolution (also reverse) has to be working properly between SAP application servers and Hadoop hosts.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the communication is not configured prior to DATAVARD activities, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its security/network team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 5: “Hadoop components and configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have at least following Hadoop components available and configuration applied.","type":"text"}]},{"type":"paragraph","content":[{"text":"Hadoop Components ","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Default installation of httpFS or webHDFS (httpFS recommended)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Hadoop configuration","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create Hadoop technical user to be used per connected SAP system and provide it’s authentication details","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create HDFS location to be used as a landing zone","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Define Sentry/Ranger rules (for secure deployment) for the HDFS location","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If components are not available, and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its Hadoop platform team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 6: “SAP system configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have the following SAP components available and configuration in place for SAP application servers and SAP system.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP release 7.01 SP15 or higher","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Http/https service running and available in SAP (by default available)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Required SSL certificates are imported to STRUST","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"If Kerberos authentication is required:","type":"text","marks":[{"type":"underline"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP Java Connector 3.0 library is available in LD_LIBRARY_PATH of adm user on every application server","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Technical user of type communication data is created in SAP","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The technical user has following authorization: object S_RFC with function group SYST, RFC1, SDIFRUNTIME, and activity 16 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Program DATAVARD_JAVA_CONN is allowed to register on the SAP gateway (by default wildcard (*) is set)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the SAP components are not available and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its SAP team for details on steps needed","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"AWS S3","type":"text"}]},{"type":"paragraph","content":[{"text":"The following prerequisites are suitable for customer who seek connection to AWS S3. If customer also wants a connection to AWS Redshift, use the prerequisites for Amazon Redshift.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 4: “SAP and AWS connectivity”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have a working network connection with sufficient bandwidth and stability between the SAP system and AWS. Specifically, outbound traffic from the SAP system to individual AWS services must be allowed, and inbound traffic coming from the SAP system must be allowed on AWS services. DNS hostname resolution of AWS services has to be working properly on SAP application servers.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the communication is not configured prior to DATAVARD activities, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its security/network team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 5: “S3 configuration and authentication”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer applies following configuration on his AWS landscape:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create an S3 bucket, or identify an existing bucket to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a technical user in AWS IAM with privileges to read and create objects in the S3 bucket","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the bucket is not created and a user is not provided, then the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 6: “SAP system configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have the following SAP components available and configuration in place for SAP application servers and SAP system.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP release 7.01 SP15 or higher","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP Java Connector 3.0 library is available in LD_LIBRARY_PATH of adm user on every application server","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Technical user of type communication data is created in SAP","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The technical user has following authorization: object S_RFC with function group SYST, RFC1, SDIFRUNTIME, and activity 16 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Program DATAVARD_JAVA_CONN is allowed to register on the SAP gateway (by default wildcard (*) is set)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the SAP components are not available and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its SAP team for details on steps needed","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"AWS Redshift","type":"text"}]},{"type":"paragraph","content":[{"text":"Following prerequisites are suitable for customer who seek connection to AWS Redshift. Connection to Redshift also requires connection to S3, so prerequisites for both services are documented here.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 4: “SAP and AWS connectivity”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have a working network connection with sufficient bandwidth and stability between the SAP system and AWS. Specifically, outbound traffic from the SAP system must be open to individual AWS services, and inbound traffic coming from the SAP system must be allowed on AWS services. DNS hostname resolution of AWS services has to be working properly on SAP application servers.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the communication is not configured prior to DATAVARD activities, connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its security/network team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 5: “Redshift and S3 configuration and authentication”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer applies the following configuration on his AWS landscape:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a S3 bucket, or identify an existing bucket to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a technical user in AWS IAM with privileges to read and create objects in S3 bucket","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a Redshift cluster","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a database in Redshift","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a technical user in Redshift that is the owner of the database created in step 4","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Grant authorizations to the technical user so it will be able to select from pg_catalog.PG_TABLE_DEF and pg_catalog.SVV_TABLE_INFO","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the mentioned steps aren’t completed, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 6: “SAP system configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have the following SAP components available and configuration in place for SAP application servers and SAP system.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP release 7.01 SP15 or higher","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP Java Connector 3.0 library is available in LD_LIBRARY_PATH of adm user on every application server","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Technical user of type communication data is created in SAP","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The technical user has following authorization: object S_RFC with function group SYST, RFC1, SDIFRUNTIME and activity 16 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Program DATAVARD_JAVA_CONN is allowed to register on the SAP gateway (by default wildcard (*) is set)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Redshift JDBC drivers are installed on the SAP application servers","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the SAP components are not available and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its SAP team for details on steps needed","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"ADLS (gen1 or gen2)","type":"text"}]},{"type":"paragraph","content":[{"text":"The following prerequisites are suitable for customer who seek connection to ADLS (gen1 or gen2).","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 4: “SAP and Azure connectivity”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have a working network connection with sufficient bandwidth and stability between the SAP system and Azure. Specifically, outbound connection must be open to individual Azure services, and inbound traffic coming from the SAP system must be allowed on Azure services. DNS hostname resolution of Azure services has to be working properly on SAP application servers.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the communication is not configured prior to DATAVARD activities, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its security/network team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 5: “ADLS configuration and authentication”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer applies following configuration on his Azure landscape:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create an ADLS resource or identify an existing one to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a directory on ADLS to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a new App Registration in Azure Active Directory","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Generate a secret for the App registration","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Assign correct filesystem privileges (RWX on target directory and X on all parent directories) on ADLS, so the App Registration can read/write to the assigned directory","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For ADLS gen2 it is possible to only generate a SAS token that gives complete access to the ADLS resource. This can be done as a substitute for steps 3-5.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the mentioned steps aren’t completed, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 6: “SAP system configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have the following SAP components available and configuration in place for SAP application servers and SAP system.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP release 7.01 SP15 or higher","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Http/https service running and available in SAP (by default available)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Microsoft SSL certificates are imported to STRUST","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the SAP components are not available and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its SAP team for details on steps needed","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Azure BLOB","type":"text"}]},{"type":"paragraph","content":[{"text":"The following prerequisites are suitable for customer who seek connection to Azure BLOB.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 4: “SAP and Azure connectivity”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have a working network connection with sufficient bandwidth and stability between the SAP system and Azure. Specifically, outbound connection must be open to individual Azure services, and inbound traffic coming from the SAP system must be allowed on Azure services. DNS hostname resolution of Azure services has to be working properly on SAP application servers.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the communication is not configured prior to DATAVARD activities, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its security/network team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 5: “BLOB configuration and authentication”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer applies following configuration on his Azure landscape:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a BLOB resource or identify an existing one to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a container on BLOB to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Generate a SAS token that gives access to the ADLS resource. ","type":"text"}]}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the mentioned steps aren’t completed, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 6: “SAP system configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have the following SAP components available and configuration in place for SAP application servers and SAP system.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP release 7.01 SP15 or higher","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Http/https service running and available in SAP (by default available)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Microsoft SSL certificates are imported to STRUST","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the SAP components are not available and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its SAP team for details on steps needed","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Azure Databricks","type":"text"}]},{"type":"paragraph","content":[{"text":"The following prerequisites are suitable for customer who seek connection to Azure Databricks. Azure Databricks also requires a connection to ADLS gen1, so also those prerequisites are included here.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 4: “SAP and Azure connectivity”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have a working network connection with sufficient bandwidth and stability between the SAP system and Azure. Specifically, outbound traffic from the SAP system must be allowed to individual Azure services, and inbound traffic coming from the SAP system must be allowed on Azure services. DNS hostname resolution of Azure services has to be working properly on SAP application servers.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the communication is not configured prior to DATAVARD activities, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its security/network team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 5: “Databricks and ADLS configuration and authentication”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer applies following configuration on his Azure landscape:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create an ADLS resource or identify an existing one to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a directory on ADLS to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a new App Registration on Azure Active Directory","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Generate a secret for the App registration","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Assign correct filesystem privileges (RWX on target directory and X on all parent directories) on ADLS, so the App Registration can read/write to the assigned directory","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a Databricks resource and create a cluster","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a database in the Databricks cluster","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add the following configration to the cluster’s advanced parameters:","type":"text"},{"type":"hardBreak"},{"text":"spark.sql.hive.metastore.version 1.2.1","type":"text"},{"type":"hardBreak"},{"text":"spark.sql.hive.metastore.jars builtin","type":"text"},{"type":"hardBreak"},{"text":"spark.hadoop.dfs.adls.oauth2.access.token.provider.type ClientCredential","type":"text"},{"type":"hardBreak"},{"text":"spark.hadoop.dfs.adls.oauth2.refresh.url ","type":"text"},{"text":"https://login.microsoftonline.com//oauth2/token","type":"text","marks":[{"type":"link","attrs":{"href":"https://login.microsoftonline.com/6fdc3117-ec29-4d73-8b33-028c8c300872/oauth2/token"}}]},{"type":"hardBreak"},{"text":"spark.hadoop.dfs.adls.oauth2.credential ","type":"text"},{"type":"hardBreak"},{"text":"spark.hadoop.dfs.adls.oauth2.client.id","type":"text","marks":[{"type":"link","attrs":{"href":"http://spark.hadoop.dfs.adls.oauth2.client.id"}}]},{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In User settings, generate a new Access token","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the mentioned steps aren’t completed, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 6: “SAP system configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have the following SAP components available and configuration in place for SAP application servers and SAP system.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP release 7.01 SP15 or higher","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP Java Connector 3.0 library is available in LD_LIBRARY_PATH of adm user on every application server","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Technical user of type communication data is created in SAP","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The technical user has following authorization: object S_RFC with function group SYST, RFC1, SDIFRUNTIME and activity 16 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Http/https service running and available in SAP (by default available)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Microsoft SSL certificates are imported to STRUST","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Program DATAVARD_JAVA_CONN is allowed to register on the SAP gateway (by default wildcard (*) is set)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hive JDBC drivers are installed on SAP application servers","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the SAP components are not available and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its SAP team for details on steps needed","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Microsoft SQL server","type":"text"}]},{"type":"paragraph","content":[{"text":"The following prerequisites are suitable for customer who seek connection to Microsoft SQL server.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 4: “SAP and Azure connectivity”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have a working network connection with sufficient bandwidth and stability between the SAP system and MSSQL server. Specifically, outbound connection must be open to the MSSQL server, and inbound traffic coming from the SAP system must be allowed on MSSQL server. DNS hostname resolution of the SQL server has to be working properly on SAP application servers.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the communication is not configured prior to DATAVARD activities, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its security/network team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 5: “MSSQL server configuration and authentication”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer applies following configuration on his MSSQL server:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a database in the MSSQL server to be used or identify an existing one","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a technical user that is allowed to interact with the database","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the mentioned steps aren’t completed, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 6: “SAP system configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have the following SAP components available and configuration in place for SAP application servers and SAP system.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"following SAP release or higher","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"21: 619","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"22: 21","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"42: 315","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"45: 29","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Application servers are running either on Windows or Linux operating system","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Microsoft SQL server ODBC drivers are installed on every application server","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Secondary DB connection is added through t-code DBCO and the connection is successfully tested through report ADBC_TEST_CONNECTION ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the SAP components are not available and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its SAP team for details on steps needed","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Google Cloud Storage","type":"text"}]},{"type":"paragraph","content":[{"text":"The following prerequisites are suitable for customer who seek a connection to Google Cloud Storage (GCS).","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 4: “SAP and GCP connectivity”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have a working network connection with sufficient bandwidth and stability between the SAP system and GCP. Specifically, outbound traffic from the SAP system must be allowed to individual GCP services, and inbound traffic coming from the SAP system must be allowed on GCP services. DNS hostname resolution of GCP services has to be working properly on SAP application servers.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the communication is not configured prior to DATAVARD activities, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its security/network team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 5: “GCS configuration and authentication”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer applies following configuration on his Azure landscape:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create an GCS resource or identify an existing one to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a service account to be used and generate a key in JSON format","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Assign correct privileges to the service account for the bucket ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the mentioned steps aren’t completed, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 6: “SAP system configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have following SAP components available and configuration in place for SAP application servers and SAP system.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP release 7.01 SP15 or higher","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP Java Connector 3.0 library is available in LD_LIBRARY_PATH of adm user on every application server","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Technical user of type communication data is created in SAP","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The technical user has following authorization: object S_RFC with function group SYST, RFC1, SDIFRUNTIME, and activity 16 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Program DATAVARD_JAVA_CONN is allowed to register on the SAP gateway (by default wildcard (*) is set)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the SAP components are not available and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its SAP team for details on steps needed","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Google BigQuery","type":"text"}]},{"type":"paragraph","content":[{"text":"The following prerequisites are suitable for customer who seek a connection to Google BigQuery. Google BigQuery also requires a connection to Google Cloud Storage, so also those prerequisites are included here.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 4: “SAP and GCP connectivity”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have a working network connection with sufficient bandwidth and stability between the SAP system and GCP. Specifically, outbound traffic from the SAP system must be allowed to individual GCP services, and inbound traffic coming from the SAP system must be allowed on GCP services. DNS hostname resolution of GCP services has to be working properly on SAP application servers.","type":"text"}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the communication is not configured prior to DATAVARD activities, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD and its security/network team for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 5: “Google BigQuery & GCS configuration and authentication”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer applies following configuration on his Azure landscape:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a GCS resource or identify an existing one to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a service account to be used and generate a key in JSON format","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Assign correct privileges to the service account for the bucket","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a BigQuery resource or identify an existing one to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a dataset or identify an existing one to be used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Assign correct privileges to the service account for the BigQuery resource and dataset","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the mentioned steps aren’t completed, the connection can’t be established.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action: ","type":"text","marks":[{"type":"strong"}]},{"text":"The Customer shall check with DATAVARD for details on steps needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisite 6: “SAP system configuration”","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Details:","type":"text","marks":[{"type":"strong"}]},{"text":" In order to execute the services described herein Customer must have the following SAP components available and configuration in place for SAP application servers and SAP system.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP release 7.01 SP15 or higher","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SAP Java Connector 3.0 library is available in LD_LIBRARY_PATH of adm user on every application server","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Technical user of type communication data is created in SAP","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The technical user has following authorization: object S_RFC with function group SYST, RFC1, SDIFRUNTIME, and activity 16 ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Program DATAVARD_JAVA_CONN is allowed to register on the SAP gateway (by default wildcard (*) is set)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Impact:","type":"text","marks":[{"type":"strong"}]},{"text":" If the SAP components are not available and configuration not set, no data operation can be performed.","type":"text"}]},{"type":"paragraph","content":[{"text":"Action:","type":"text","marks":[{"type":"strong"}]},{"text":" The Customer shall check with DATAVARD and its SAP team for details on steps needed","type":"text"}]}],"version":1}

Browser not supported