Connect to SAP Datasphere

Console

1. In the Google Cloud console, go to the BigQuerypage.

   Go to BigQuery

2. In the Explorerpane, click add Add data.

   The Add datadialog opens.

3. In the Filter Bypane, in the Data Source Typesection, select Databases.

   Alternatively, in the Search for data sourcesfield, you can enter SAP HANA .

4. In the Featured data sourcessection, click SAP HANA.

5. Click the SAP HANA: BigQuery Federationsolution card.

6. In the External data sourcedialog, do the following:

   • For Connection type, select SAP HANA .
   • For Connection ID, enter a connection ID to identify this connection.
   • For Location type, specify a region of the BigQuery dataset to be combined with the data from SAP Datasphere. Queries that use this connection must be run from this region.
   • Optional: For Friendly name, enter a user-friendly name for the connection, such as My connection resource . The friendly name can be any value that helps you identify the connection resource if you need to modify it later.
   • Optional: For Description, enter a description for this connection resource.
   • For Encryption, select either Google-managed encryption keyor Customer-managed encryption key (CMEK). The use of a CMEK is optional.
   • For Host:port: enter the host and port of the SAP database instance, as shown in the Database User Detailsin the SAP Datasphere web console, in the format HOST:PORT .
   • Optional: For Network attachment, enter a path to the network attachment that defines the network configuration that is used for establishing a connection to SAP Datasphere.
   • For Username: enter the database username from Database User Detailsin the SAP Datasphere web console. For example, MY_SPACE#BIGQUERY .
   • For Password: enter the database user's password.

7. Click Create connection.

bq

Enter the bq mk command with the following flags:

   
bq  
mk  
 \ 
  
--connection  
 \ 
  
--location = 
 LOCATION 
  
 \ 
  
--project_id = 
 PROJECT_ID 
  
 \ 
  
--connector_configuration  
 '{ 
 "connector_id": "saphana", 
 "endpoint": { 
 "host_port": " HOST_PORT 
" 
 }, 
 "authentication": { 
 "username_password": { 
 "username": " USERNAME 
", 
 "password": { 
 "plaintext": " PASSWORD 
" 
 } 
 } 
 }, 
 "network": { 
 "private_service_connect": { 
 "network_attachment": " NETWORK_ATTACHMENT 
" 
 } 
 } 
 }' 
  
 \ 
  
 CONNECTION_ID 
 

Replace the following:

• LOCATION : specify a region of the BigQuery dataset to be combined with the data from SAP Datasphere. Queries that use this connection must be run from this region.
• PROJECT_ID : enter your Google Cloud project ID.
• HOST_PORT : enter the host and port of the SAP database instance, as shown in the Database User Detailsin the SAP Datasphere web console, in the format HOST:PORT .
• NETWORK_ATTACHMENT (optional): enter the network attachment in the format projects/{project}/regions/{region}/networkAttachments/{networkattachment} . With this field, you can configure the SAP Datasphere connection so that BigQuery opens the connection from a static IP address.
• USERNAME : enter the database username from Database User Detailsin the SAP Datasphere web console. For example, MY_SPACE#BIGQUERY .
• PASSWORD : enter the database user's password.
• CONNECTION_ID : enter a connection ID to identify this connection.

Console

1. Go to the BigQuerypage.

   Go to BigQuery

   Connections are listed in your project, in a group called External connections.

2. In the Explorerpane, click your project name > External connections > connection .

3. In the Detailspane, click Shareto share a connection. Then do the following:

   1. In the Connection permissionsdialog, share the connection with other principals by adding or editing principals.

   2. Click Save.

bq

You cannot share a connection with the bq command-line tool. To share a connection, use the Google Cloud console or the BigQuery Connections API method to share a connection.

API

Use the projects.locations.connections.setIAM method in the BigQuery Connections REST API reference section, and supply an instance of the policy resource.

Java

  import 
  
 com.google.api.resourcenames. ResourceName 
 
 ; 
 import 
  
 com.google.cloud.bigquery.connection.v1. ConnectionName 
 
 ; 
 import 
  
 com.google.cloud.bigqueryconnection.v1. ConnectionServiceClient 
 
 ; 
 import 
  
 com.google.iam.v1. Binding 
 
 ; 
 import 
  
 com.google.iam.v1. Policy 
 
 ; 
 import 
  
 com.google.iam.v1. SetIamPolicyRequest 
 
 ; 
 import 
  
 java.io.IOException 
 ; 
 // Sample to share connections 
 public 
  
 class 
 ShareConnection 
  
 { 
  
 public 
  
 static 
  
 void 
  
 main 
 ( 
 String 
 [] 
  
 args 
 ) 
  
 throws 
  
 IOException 
  
 { 
  
 // TODO(developer): Replace these variables before running the sample. 
  
 String 
  
 projectId 
  
 = 
  
 "MY_PROJECT_ID" 
 ; 
  
 String 
  
 location 
  
 = 
  
 "MY_LOCATION" 
 ; 
  
 String 
  
 connectionId 
  
 = 
  
 "MY_CONNECTION_ID" 
 ; 
  
 shareConnection 
 ( 
 projectId 
 , 
  
 location 
 , 
  
 connectionId 
 ); 
  
 } 
  
 static 
  
 void 
  
 shareConnection 
 ( 
 String 
  
 projectId 
 , 
  
 String 
  
 location 
 , 
  
 String 
  
 connectionId 
 ) 
  
 throws 
  
 IOException 
  
 { 
  
 try 
  
 ( 
  ConnectionServiceClient 
 
  
 client 
  
 = 
  
  ConnectionServiceClient 
 
 . 
 create 
 ()) 
  
 { 
  
  ResourceName 
 
  
 resource 
  
 = 
  
  ConnectionName 
 
 . 
 of 
 ( 
 projectId 
 , 
  
 location 
 , 
  
 connectionId 
 ); 
  
  Binding 
 
  
 binding 
  
 = 
  
  Binding 
 
 . 
 newBuilder 
 () 
  
 . 
  addMembers 
 
 ( 
 "group:example-analyst-group@google.com" 
 ) 
  
 . 
 setRole 
 ( 
 "roles/bigquery.connectionUser" 
 ) 
  
 . 
 build 
 (); 
  
  Policy 
 
  
 policy 
  
 = 
  
  Policy 
 
 . 
 newBuilder 
 (). 
  addBindings 
 
 ( 
 binding 
 ). 
 build 
 (); 
  
  SetIamPolicyRequest 
 
  
 request 
  
 = 
  
  SetIamPolicyRequest 
 
 . 
 newBuilder 
 () 
  
 . 
 setResource 
 ( 
 resource 
 . 
 toString 
 ()) 
  
 . 
  setPolicy 
 
 ( 
 policy 
 ) 
  
 . 
 build 
 (); 
  
 client 
 . 
 setIamPolicy 
 ( 
 request 
 ); 
  
 System 
 . 
 out 
 . 
 println 
 ( 
 "Connection shared successfully" 
 ); 
  
 } 
  
 } 
 }