organizations
Creates, updates, deletes, gets or lists an organizations resource.
Overview
| Name | organizations |
| Type | Resource |
| Id | azure_isv.informaticadatamanagement.organizations |
Fields
The following fields are returned by SELECT queries:
- get
- list_by_resource_group
- list_by_subscription
| Name | Datatype | Description |
|---|---|---|
id | string | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. # pylint: disable=line-too-long |
name | string | The name of the resource. |
companyDetails | object | Company details. |
informaticaProperties | object | Informatica Organization properties. |
linkOrganization | object | Link Organization. |
location | string | The geo-location where the resource lives. Required. |
marketplaceDetails | object | Marketplace details. |
provisioningState | string | Provisioning State of the resource. Known values are: "Accepted", "Creating", "Updating", "Deleting", "Succeeded", "Failed", "Canceled", "Deleted", and "NotSpecified". |
systemData | object | Azure Resource Manager metadata containing createdBy and modifiedBy information. |
tags | object | Resource tags. |
type | string | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts". |
userDetails | object | User details. |
| Name | Datatype | Description |
|---|---|---|
id | string | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. # pylint: disable=line-too-long |
name | string | The name of the resource. |
companyDetails | object | Company details. |
informaticaProperties | object | Informatica Organization properties. |
linkOrganization | object | Link Organization. |
location | string | The geo-location where the resource lives. Required. |
marketplaceDetails | object | Marketplace details. |
provisioningState | string | Provisioning State of the resource. Known values are: "Accepted", "Creating", "Updating", "Deleting", "Succeeded", "Failed", "Canceled", "Deleted", and "NotSpecified". |
systemData | object | Azure Resource Manager metadata containing createdBy and modifiedBy information. |
tags | object | Resource tags. |
type | string | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts". |
userDetails | object | User details. |
| Name | Datatype | Description |
|---|---|---|
id | string | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. # pylint: disable=line-too-long |
name | string | The name of the resource. |
companyDetails | object | Company details. |
informaticaProperties | object | Informatica Organization properties. |
linkOrganization | object | Link Organization. |
location | string | The geo-location where the resource lives. Required. |
marketplaceDetails | object | Marketplace details. |
provisioningState | string | Provisioning State of the resource. Known values are: "Accepted", "Creating", "Updating", "Deleting", "Succeeded", "Failed", "Canceled", "Deleted", and "NotSpecified". |
systemData | object | Azure Resource Manager metadata containing createdBy and modifiedBy information. |
tags | object | Resource tags. |
type | string | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts". |
userDetails | object | User details. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | resource_group_name, organization_name, subscription_id | Get a InformaticaOrganizationResource. | |
list_by_resource_group | select | resource_group_name, subscription_id | List InformaticaOrganizationResource resources by resource group. | |
list_by_subscription | select | subscription_id | List InformaticaOrganizationResource resources by subscription ID. | |
create_or_update | insert | resource_group_name, organization_name, subscription_id, location | Create a InformaticaOrganizationResource. | |
update | update | resource_group_name, organization_name, subscription_id | Update a InformaticaOrganizationResource. | |
create_or_update | replace | resource_group_name, organization_name, subscription_id, location | Create a InformaticaOrganizationResource. | |
delete | delete | resource_group_name, organization_name, subscription_id | Delete a InformaticaOrganizationResource. | |
get_all_serverless_runtimes | exec | resource_group_name, organization_name, subscription_id | Gets all serverless runtime resources in a given informatica organization resource. | |
get_serverless_metadata | exec | resource_group_name, organization_name, subscription_id | Gets Metadata of the serverless runtime environment. |
Parameters
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
organization_name | string | Name of the Organizations resource. Required. |
resource_group_name | string | The name of the resource group. The name is case insensitive. Required. |
subscription_id | string |
SELECT examples
- get
- list_by_resource_group
- list_by_subscription
Get a InformaticaOrganizationResource.
SELECT
id,
name,
companyDetails,
informaticaProperties,
linkOrganization,
location,
marketplaceDetails,
provisioningState,
systemData,
tags,
type,
userDetails
FROM azure_isv.informaticadatamanagement.organizations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND organization_name = '{{ organization_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;
List InformaticaOrganizationResource resources by resource group.
SELECT
id,
name,
companyDetails,
informaticaProperties,
linkOrganization,
location,
marketplaceDetails,
provisioningState,
systemData,
tags,
type,
userDetails
FROM azure_isv.informaticadatamanagement.organizations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;
List InformaticaOrganizationResource resources by subscription ID.
SELECT
id,
name,
companyDetails,
informaticaProperties,
linkOrganization,
location,
marketplaceDetails,
provisioningState,
systemData,
tags,
type,
userDetails
FROM azure_isv.informaticadatamanagement.organizations
WHERE subscription_id = '{{ subscription_id }}' -- required
;
INSERT examples
- create_or_update
- Manifest
Create a InformaticaOrganizationResource.
INSERT INTO azure_isv.informaticadatamanagement.organizations (
tags,
location,
properties,
resource_group_name,
organization_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ organization_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;
# Description fields are for documentation purposes
- name: organizations
props:
- name: resource_group_name
value: "{{ resource_group_name }}"
description: Required parameter for the organizations resource.
- name: organization_name
value: "{{ organization_name }}"
description: Required parameter for the organizations resource.
- name: subscription_id
value: "{{ subscription_id }}"
description: Required parameter for the organizations resource.
- name: tags
value: "{{ tags }}"
description: |
Resource tags.
- name: location
value: "{{ location }}"
description: |
The geo-location where the resource lives. Required.
- name: properties
description: |
The resource-specific properties for this resource.
value:
provisioningState: "{{ provisioningState }}"
informaticaProperties:
organizationId: "{{ organizationId }}"
organizationName: "{{ organizationName }}"
informaticaRegion: "{{ informaticaRegion }}"
singleSignOnUrl: "{{ singleSignOnUrl }}"
marketplaceDetails:
marketplaceSubscriptionId: "{{ marketplaceSubscriptionId }}"
offerDetails:
publisherId: "{{ publisherId }}"
offerId: "{{ offerId }}"
planId: "{{ planId }}"
planName: "{{ planName }}"
termUnit: "{{ termUnit }}"
termId: "{{ termId }}"
userDetails:
firstName: "{{ firstName }}"
lastName: "{{ lastName }}"
emailAddress: "{{ emailAddress }}"
upn: "{{ upn }}"
phoneNumber: "{{ phoneNumber }}"
companyDetails:
companyName: "{{ companyName }}"
officeAddress: "{{ officeAddress }}"
country: "{{ country }}"
domain: "{{ domain }}"
business: "{{ business }}"
numberOfEmployees: {{ numberOfEmployees }}
linkOrganization:
token: "{{ token }}"
UPDATE examples
- update
Update a InformaticaOrganizationResource.
UPDATE azure_isv.informaticadatamanagement.organizations
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND organization_name = '{{ organization_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;
REPLACE examples
- create_or_update
Create a InformaticaOrganizationResource.
REPLACE azure_isv.informaticadatamanagement.organizations
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND organization_name = '{{ organization_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;
DELETE examples
- delete
Delete a InformaticaOrganizationResource.
DELETE FROM azure_isv.informaticadatamanagement.organizations
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND organization_name = '{{ organization_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;
Lifecycle Methods
- get_all_serverless_runtimes
- get_serverless_metadata
Gets all serverless runtime resources in a given informatica organization resource.
EXEC azure_isv.informaticadatamanagement.organizations.get_all_serverless_runtimes
@resource_group_name='{{ resource_group_name }}' --required,
@organization_name='{{ organization_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;
Gets Metadata of the serverless runtime environment.
EXEC azure_isv.informaticadatamanagement.organizations.get_serverless_metadata
@resource_group_name='{{ resource_group_name }}' --required,
@organization_name='{{ organization_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;