This Quickstart launches a Big Data solution stack which has Informatica, Azure Data Factory, HDInsight, Azure SQL Dataware house and PowerBI as stack components. This integrated stack is ready to use pre production environment.
This Azure Resource Manager (ARM) template was created by a member of the community and not by Microsoft. Each ARM template is licensed to you under a licence agreement by its owner, not Microsoft. Microsoft is not responsible for ARM templates provided and licensed by community members and does not screen for security, compatibility or performance. Community ARM templates are not supported under any Microsoft support programme or service, and are made available AS IS without warranty of any kind.
Parameters
| Parameter Name | Description |
|---|---|
| location | Deployment location |
| sqlDWDBAdminName | SQL Datawarehouse Admin Username |
| sqlDWAdminPassword | SQL Datawarehouse Admin password |
| jobId | Job Id of the create table automation Job, use https://www.guidgenerator.com to generate unique jobid Ex:5f32ff4e-a5c5-47af-8b70-981c896a9163 |
| jobIdSignup | Job Id of the sign-up automation Job, use https://www.guidgenerator.com to generate unique jobid Ex:5f32ff4e-a5c5-47af-8b70-981c896a9163 |
| jobIdWorkflow | Job Id of the workflow automation Job, use https://www.guidgenerator.com to generate unique jobid Ex:5f32ff4e-a5c5-47af-8b70-981c896a9163 |
| jobIdCont | Job Id of the workflow automation Job, use https://www.guidgenerator.com to generate unique jobid Ex:5f32ff4e-a5c5-47af-8b70-981c896a9163 |
| start | Start time of the data slice. ex: 2016-09-23T18:00:00 |
| end | End time of the data slice. ex: 2016-09-23T19:00:00 |
| tag | Tags for the resources |
| azurePortalUsername | Valid Username to login into your Azure Portal |
| azurePortalPassword | Valid Password to login into your Azure Portal |
| adminUsernameInformaticaVm | Username to login into informatica vm |
| adminPasswordInformaticaVm | Password to login into informatica vm |
| publicIPdnsPrefix | Public IP dns prefix |
| userEmail | Informatica Cloud Email ID |
| informaticaUsername | Informatica Cloud Username |
| informaticaUserPassword | Informatica Cloud password |
| userFirstname | First name for Informatica Sign up |
| userLastname | Last name for Informatica Sign up |
| userTitle | User title for Informatica Sign up |
| userPhone | User phone number for Informatica Sign up. Only numbers Ex: 1234567890 |
| orgName | Organization for Informatica Sign up |
| orgAddress | Organization Address for Informatica Sign up |
| orgCity | Organization city for Informatica Sign up |
| orgState | Organization state for Informatica Sign up, Hint:Pass State Postal Codes Ex:CA |
| orgZipcode | Organization zipcode for Informatica Sign up |
| orgCountry | Organization's country for Informatica Sign up, Hint:Pass Country's ISO Codes Ex:US |
| orgEmployees | Organization's Employees for Informatica Sign up |
| baseUrl | Base URL for the reference templates and scripts |
Use the template
PowerShell
New-AzResourceGroup -Name <resource-group-name> -Location <resource-group-location> #use this command when you need to create a new resource group for your deploymentInstalling and configuring Azure PowerShell
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/informatica-adf-hdinsight-powerbi/azuredeploy.json
Command line
az group create --name <resource-group-name> --location <resource-group-location> #use this command when you need to create a new resource group for your deploymentInstalling and configuring the Azure cross-platform command-line interface
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/informatica-adf-hdinsight-powerbi/azuredeploy.json