sap_database_instances

Creates, updates, deletes, gets or lists a sap_database_instances resource.

Overview

Name	sap_database_instances
Type	Resource
Id	azure_isv.sap_workloads.sap_database_instances

Fields

vw_sap_database_instances

Name	Datatype	Description
databaseInstanceName	text	field from the properties object
database_sid	text	field from the properties object
database_type	text	field from the properties object
errors	text	field from the properties object
ip_address	text	field from the properties object
load_balancer_details	text	field from the properties object
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sapVirtualInstanceName	text	field from the properties object
status	text	field from the properties object
subnet	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
vm_details	text	field from the properties object

sap_database_instances

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Defines the Database properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Gets the SAP Database Instance resource.
list	SELECT	resourceGroupName, sapVirtualInstanceName, subscriptionId	Lists the Database resources associated with a Virtual Instance for SAP solutions resource.
create	INSERT	databaseInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Creates the Database resource corresponding to the Virtual Instance for SAP solutions resource. This will be used by service only. PUT by end user will return a Bad Request error.
delete	DELETE	databaseInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Deletes the Database resource corresponding to a Virtual Instance for SAP solutions resource. This will be used by service only. Delete by end user will return a Bad Request error.
update	UPDATE	databaseInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Updates the Database resource.
start_instance	EXEC	databaseInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Starts the database instance of the SAP system.
stop_instance	EXEC	databaseInstanceName, resourceGroupName, sapVirtualInstanceName, subscriptionId	Stops the database instance of the SAP system.

SELECT examples

Lists the Database resources associated with a Virtual Instance for SAP solutions resource.

vw_sap_database_instances

SELECT
databaseInstanceName,
database_sid,
database_type,
errors,
ip_address,
load_balancer_details,
location,
provisioning_state,
resourceGroupName,
sapVirtualInstanceName,
status,
subnet,
subscriptionId,
tags,
vm_details
FROM azure_isv.sap_workloads.vw_sap_database_instances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';

sap_database_instances

SELECT
location,
properties,
tags
FROM azure_isv.sap_workloads.sap_database_instances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new sap_database_instances resource.

All Properties

/*+ create */
INSERT INTO azure_isv.sap_workloads.sap_database_instances (
databaseInstanceName,
resourceGroupName,
sapVirtualInstanceName,
subscriptionId,
tags,
location,
properties
)
SELECT 
'{{ databaseInstanceName }}',
'{{ resourceGroupName }}',
'{{ sapVirtualInstanceName }}',
'{{ subscriptionId }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: subnet
          value: string
        - name: databaseSid
          value: string
        - name: databaseType
          value: string
        - name: ipAddress
          value: string
        - name: loadBalancerDetails
          value:
            - name: id
              value: string
        - name: vmDetails
          value:
            - - name: virtualMachineId
                value: string
              - name: status
                value: []
              - name: storageDetails
                value:
                  - - name: id
                      value: string
        - name: provisioningState
          value: []
        - name: errors
          value:
            - name: properties
              value:
                - name: code
                  value: string
                - name: message
                  value: string
                - name: details
                  value:
                    - - name: code
                        value: string
                      - name: message
                        value: string
                      - name: details
                        value:
                          - - name: code
                              value: string
                            - name: message
                              value: string
                            - name: details
                              value:
                                - - name: code
                                    value: string
                                  - name: message
                                    value: string
                                  - name: details
                                    value:
                                      - - name: code
                                          value: string
                                        - name: message
                                          value: string
                                        - name: details
                                          value:
                                            - - name: code
                                                value: string
                                              - name: message
                                                value: string
                                              - name: details
                                                value:
                                                  - - name: code
                                                      value: string
                                                    - name: message
                                                      value: string
                                                    - name: details
                                                      value:
                                                        - - name: code
                                                            value: string
                                                          - name: message
                                                            value: string
                                                          - name: details
                                                            value:
                                                              - []

UPDATE example

Updates a sap_database_instances resource.

/*+ update */
UPDATE azure_isv.sap_workloads.sap_database_instances
SET 
tags = '{{ tags }}'
WHERE 
databaseInstanceName = '{{ databaseInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified sap_database_instances resource.

/*+ delete */
DELETE FROM azure_isv.sap_workloads.sap_database_instances
WHERE databaseInstanceName = '{{ databaseInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sapVirtualInstanceName = '{{ sapVirtualInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';