This blog demonstrates how to provision SAP BDC Connect for Snowflake.
Prerequisites:
Access toSAP for Me(me.sap.com) with the appropriate authorizations.
SAP Business Data Cloud Coremust be enabled.
Sufficient remaining capacity units in your contract to allocate to the new solution.
The Snowflake account must be Standard, Enterprise, or Business Critical edition. You should be ORGADMIN to accept the SAP® BDC Connect for Snowflake Terms or the ORGADMIN must accept the terms before to star the provisioning process.
You need to have the role ACCOUNTADMIN or need to have the proper roles and privileges in Snowflake to create the connector.
Step-by-Step Provisioning Guide:
1. Log in toSAP for Me and navigate toPortfolio & Products > Business Data Cloud. On theApplicationstab you will find SAP Business Data Cloud Connect. Click on “Start Provisioning“.
2. In the “Business Data Cloud – Create Solution” dialog that appears, provide details such as Solution Name (you can edit it later), Path (select the same resource group you selected for the BDC Cockpit) and Business Type (by default is ‘Production’). Click on “Next Step”.
3. On the Assign Quota page, specify the planned Capacity Units (CU) for SAP BDC Connect. You can use the SAP Business Data Cloud Capacity Unit Estimator to check the appropriate number that you need. Then click on “Next Step”.
4. Log in to Snowflake and go to Ingestion > Zero-Copy, look for SAP® BDC Connect for Snowflake and click on “Connect”.
5. If you’ve not accepted the SAP® BDC Connect for Snowflake Terms please click on “View Terms”. Then click on “Review” and click on “Accept”. You must have the ORGADMIN role.
6. If you’ve already accepted the SAP® BDC Connect for Snowflake Terms. Then provide the Connector name and the Target Database and Schema where the connector will be installed, if you don’t have a database you can create a new one in this step. Then click on “Create connector”.
7. Copy the Unique Connector Identifier it is your Snowflake account URL: https://<orgName>–<accountName>.snowflakecomputing.com.
5. Go back to SAP for Me portal. On the Configure Parameters page provide the “External System Instance Identifier”. Enter your Snowflake account that you copy in the previous step. Then select the same region as you selected for the BDC Cockpit and click on “Review“.
5. The final Review page presents a consolidated summary of all configuration choices made across the previous steps. Verify each section carefully. Once satisfied then click on “Finish” to submit the provisioning request.
6. A confirmation message notifies you that the system is now creating the solution. Choose “View in Resources” to view the tenant in the resource group you have indicated.
7. Wait a few minutes, and you will see a notification message for your SAP BDC Connect. Click on it to check the details, then copy the link provided.
8. Go back to Snowflake and paste the Activation Link from SAP for Me. Then click on “Connect”.
9. Now, your connector is ready in both sides Snowflake and SAP for Me.
10. The final step to start sharing data products is that you need to come back to SAP for Me and add this new BDC connect instance to a SAP BDC formation. Then you can open you BDC Cockpit and share data products.
BDC Connect instance in a BDC formation.
Sharing a data product to BDC connect for Snowflake.
Open your SAP BDC connector in Snowflake. Now you can see the data product.
Overview:This blog demonstrates how to provision SAP BDC Connect for Snowflake.Prerequisites:Access to SAP for Me (me.sap.com) with the appropriate authorizations.SAP Business Data Cloud Core must be enabled.Sufficient remaining capacity units in your contract to allocate to the new solution.The Snowflake account must be Standard, Enterprise, or Business Critical edition. You should be ORGADMIN to accept the SAP® BDC Connect for Snowflake Terms or the ORGADMIN must accept the terms before to star the provisioning process.You need to have the role ACCOUNTADMIN or need to have the proper roles and privileges in Snowflake to create the connector.Step-by-Step Provisioning Guide:1. Log in to SAP for Me and navigate to Portfolio & Products > Business Data Cloud. On the Applications tab you will find SAP Business Data Cloud Connect. Click on “Start Provisioning”.2. In the “Business Data Cloud – Create Solution” dialog that appears, provide details such as Solution Name (you can edit it later), Path (select the same resource group you selected for the BDC Cockpit) and Business Type (by default is ‘Production’). Click on “Next Step”.3. On the Assign Quota page, specify the planned Capacity Units (CU) for SAP BDC Connect. You can use the SAP Business Data Cloud Capacity Unit Estimator to check the appropriate number that you need. Then click on “Next Step”.4. Log in to Snowflake and go to Ingestion > Zero-Copy, look for SAP® BDC Connect for Snowflake and click on “Connect”.5. If you’ve not accepted the SAP® BDC Connect for Snowflake Terms please click on “View Terms”. Then click on “Review” and click on “Accept”. You must have the ORGADMIN role.6. If you’ve already accepted the SAP® BDC Connect for Snowflake Terms. Then provide the Connector name and the Target Database and Schema where the connector will be installed, if you don’t have a database you can create a new one in this step. Then click on “Create connector”.7. Copy the Unique Connector Identifier it is your Snowflake account URL: https://<orgName>-<accountName>.snowflakecomputing.com.5. Go back to SAP for Me portal. On the Configure Parameters page provide the “External System Instance Identifier”. Enter your Snowflake account that you copy in the previous step. Then select the same region as you selected for the BDC Cockpit and click on “Review”.5. The final Review page presents a consolidated summary of all configuration choices made across the previous steps. Verify each section carefully. Once satisfied then click on “Finish” to submit the provisioning request. 6. A confirmation message notifies you that the system is now creating the solution. Choose “View in Resources” to view the tenant in the resource group you have indicated.7. Wait a few minutes, and you will see a notification message for your SAP BDC Connect. Click on it to check the details, then copy the link provided. 8. Go back to Snowflake and paste the Activation Link from SAP for Me. Then click on “Connect”.9. Now, your connector is ready in both sides Snowflake and SAP for Me.10. The final step to start sharing data products is that you need to come back to SAP for Me and add this new BDC connect instance to a SAP BDC formation. Then you can open you BDC Cockpit and share data products.BDC Connect instance in a BDC formation.Sharing a data product to BDC connect for Snowflake.Open your SAP BDC connector in Snowflake. Now you can see the data product.Reference documentation:Provisioning SAP Business Data Cloud ConnectSAP® BDC Connect for Snowflake Read More Technology Blog Posts by SAP articles
