Skip to main content

organizations

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

Overview

Nameorganizations
TypeResource
Idazure_isv.informaticadatamanagement.organizations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. # pylint: disable=line-too-long
namestringThe name of the resource.
companyDetailsobjectCompany details.
informaticaPropertiesobjectInformatica Organization properties.
linkOrganizationobjectLink Organization.
locationstringThe geo-location where the resource lives. Required.
marketplaceDetailsobjectMarketplace details.
provisioningStatestringProvisioning State of the resource. Known values are: "Accepted", "Creating", "Updating", "Deleting", "Succeeded", "Failed", "Canceled", "Deleted", and "NotSpecified".
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
userDetailsobjectUser details.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, organization_name, subscription_idGet a InformaticaOrganizationResource.
list_by_resource_groupselectresource_group_name, subscription_idList InformaticaOrganizationResource resources by resource group.
list_by_subscriptionselectsubscription_idList InformaticaOrganizationResource resources by subscription ID.
create_or_updateinsertresource_group_name, organization_name, subscription_id, locationCreate a InformaticaOrganizationResource.
updateupdateresource_group_name, organization_name, subscription_idUpdate a InformaticaOrganizationResource.
create_or_updatereplaceresource_group_name, organization_name, subscription_id, locationCreate a InformaticaOrganizationResource.
deletedeleteresource_group_name, organization_name, subscription_idDelete a InformaticaOrganizationResource.
get_all_serverless_runtimesexecresource_group_name, organization_name, subscription_idGets all serverless runtime resources in a given informatica organization resource.
get_serverless_metadataexecresource_group_name, organization_name, subscription_idGets 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.

NameDatatypeDescription
organization_namestringName of the Organizations resource. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

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
;

INSERT examples

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
;

UPDATE examples

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 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 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

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
;