Informatica-ADF(HDInsight)-PowerBI Push to Pilot

by uday-sg
Last updated: 06/10/2016

This push to pilot 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-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/informatica-adf-hdinsight-powerbi/azuredeploy.json
Installing and configuring Azure PowerShell
Command line
azure config mode arm
azure group deployment create <my-resource-group> <my-deployment-name> --template-uri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/informatica-adf-hdinsight-powerbi/azuredeploy.json
Installing and configuring the Azure cross-platform command-line interface