organizations

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

Overview

Name	organizations
Type	Resource
Id	azure_isv.informatica.organizations

Fields

vw_organizations

Name	Datatype	Description
company_details	text	field from the properties object
informatica_properties	text	field from the properties object
link_organization	text	field from the properties object
location	text	The geo-location where the resource lives
marketplace_details	text	field from the properties object
organizationName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
user_details	text	field from the properties object

organizations

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Properties specific to the Informatica DataManagement Organization resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	organizationName, resourceGroupName, subscriptionId	Get a InformaticaOrganizationResource
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List InformaticaOrganizationResource resources by resource group
list_by_subscription	SELECT	subscriptionId	List InformaticaOrganizationResource resources by subscription ID
create_or_update	INSERT	organizationName, resourceGroupName, subscriptionId	Create a InformaticaOrganizationResource
delete	DELETE	organizationName, resourceGroupName, subscriptionId	Delete a InformaticaOrganizationResource
update	UPDATE	organizationName, resourceGroupName, subscriptionId	Update a InformaticaOrganizationResource

SELECT examples

List InformaticaOrganizationResource resources by subscription ID

vw_organizations

SELECT
company_details,
informatica_properties,
link_organization,
location,
marketplace_details,
organizationName,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
user_details
FROM azure_isv.informatica.vw_organizations
WHERE subscriptionId = '{{ subscriptionId }}';

organizations

SELECT
location,
properties,
tags
FROM azure_isv.informatica.organizations
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.informatica.organizations (
organizationName,
resourceGroupName,
subscriptionId,
properties,
tags,
location
)
SELECT 
'{{ organizationName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: informaticaProperties
          value:
            - name: organizationId
              value: string
            - name: organizationName
              value: string
            - name: informaticaRegion
              value: string
            - name: singleSignOnUrl
              value: string
        - name: marketplaceDetails
          value:
            - name: marketplaceSubscriptionId
              value: string
            - name: offerDetails
              value:
                - name: publisherId
                  value: string
                - name: offerId
                  value: string
                - name: planId
                  value: string
                - name: planName
                  value: string
                - name: termUnit
                  value: string
                - name: termId
                  value: string
        - name: userDetails
          value:
            - name: firstName
              value: string
            - name: lastName
              value: string
            - name: emailAddress
              value: []
            - name: upn
              value: string
            - name: phoneNumber
              value: string
        - name: companyDetails
          value:
            - name: companyName
              value: string
            - name: officeAddress
              value: string
            - name: country
              value: string
            - name: domain
              value: string
            - name: business
              value: string
            - name: numberOfEmployees
              value: integer
        - name: linkOrganization
          value:
            - name: token
              value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a organizations resource.

/*+ update */
UPDATE azure_isv.informatica.organizations
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
organizationName = '{{ organizationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified organizations resource.

/*+ delete */
DELETE FROM azure_isv.informatica.organizations
WHERE organizationName = '{{ organizationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';