Unclear instructions on how to configure

kromerm / adflab

Azure Data Factory hands-on lab, self-paced. Learn how to lift & shift SSIS packages to the Cloud with ADF. Build new ETL pipelines in ADF, transform data at scale, load Azure Data Warehouse data marts. Also walks through operationalizing ADF pipelines with scheduling and monitoring modules.

http://aka.ms/adflab2

137 stars 129 forks source link

Unclear instructions on how to configure #19

Open shivankitsharma opened 6 years ago

shivankitsharma commented 6 years ago

The instruction are unclear about what to do here. It says for each SQL Server connection configure the connection string, server name, and password. I only see the password field empty so i added the password there. The connection string and server name are already present so do they have to be replaced by the setting of the azure version of the DW, ODS and OLTP from the Azure console?

Further, does adflabstaging need to be replaced by adflabstorage with the corresponding connection string and key?

Please help!

kromerm commented 6 years ago

Can you tell me which lab document and page this is from?

shivankitsharma commented 6 years ago

Hey Mark,

Thank you for taking out the time to reply. I had almost given up in trying to figure out what's wrong

LAb 2 - Page 16 - Instructions 24-27. I added the password for the labadmin account to all the 3 ODS, OLAP and DW connections and made no further changes. For the adflabstaging i don't know what to do because my Azure account is named adflabstorage and there is no staging account. I still added the Accountkey for the adflabstorage account and changed the account name and connection string to those found in the azure interface for the adfstorage account.

When i run it, it fails and throws up a couple of errors

Further if i tried to continue, i see nointegration runtime options

Help!

kromerm commented 6 years ago

Is the SSIS Integration Runtime present in your Data Factory?

shivankitsharma commented 6 years ago

Hey,

Yes it is and running but seems like it isn't being picked up

Further, these are the settings in place

kromerm commented 6 years ago

@joshuha Is this something you can take a look at?

joshuha commented 6 years ago

Yes each ServerName property needs to be updated to the output of your ServerName from the Powershell script. You need to update each connections ServerName and ConnectionString property. Also, if you changed the default admin UserName in the script you would also need to update that.