Google Spreadsheet DataSource Wizard

The Google Spreadsheet DataSource Wizard is shown in Figure 19.1, “Google Spreadsheet DataSource Wizard - User” and Figure 19.2, “Google Spreadsheet DataSource Wizard - URLs”

Figure 19.1. Google Spreadsheet DataSource Wizard - User

Google Spreadsheet DataSource Wizard - User

Figure 19.2. Google Spreadsheet DataSource Wizard - URLs

Google Spreadsheet DataSource Wizard - URLs

Name: Enter a unique name for the DataSource in the text box.

Description: Any additional description required to describe the data can be entered here.

On the User tab, fill in the following fields:

After entering the user name and password, click Test Connection to verify that the connection is successful.

On the URLs tab, the following field is automatically filled with information:

Spreadsheet Name: Click Fill Spreadsheet choices. Options for the spreadsheet name will display in the list. Select an option to proceed.

Worksheet Name: After you click Fill Spreadsheet choices, options for the worksheet name will display in the list. Select an option to proceed.

The next page of the wizard, seen in Figure 19.3, “Enter Google Spreadsheet Schema”, is for inferring the schema and editing it.

Figure 19.3. Enter Google Spreadsheet Schema

Enter Google Spreadsheet Schema

You can either enter the column names and data types explicitly, or infer the schema using Infer Schema. Column names and data types can be edited after inferring.