Database Reference
In-Depth Information
The next screen in the wizard accepts the connection string for the data source. You can choose to build the
connection string instead of writing it manually. So click on the
Build
button to bring up the Data Link file, where you
can select the
HadoopOnAzure
DSN we created earlier and provide the correct credentials to access the HDInsight
cluster. Make sure to select
Allow saving password
so that the password is retained in the underlying PowerPivot
Table
Import Wizard
. Also, verify that
Test Connection
succeeds as shown in Figure
9-5
. If you provide all the details correctly,
you should also be able to enumerate the default database
HIVE
in the
Enter the initial catalog to use
drop-down list.
Figure 9-5.
Configuring the connection string
The
Table Import Wizard
dialog should be populated with the appropriate connection string as shown in
Figure
9-6
. Click on
Next
.