update spotfire server doc with captures
Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/9fd0ccac Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/9fd0ccac Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/9fd0ccac Branch: refs/heads/gh-pages Commit: 9fd0ccac4a756a5c58874c82addd262c43a60971 Parents: 6244940 Author: Bob Rumsby <[email protected]> Authored: Thu May 14 18:04:17 2015 -0700 Committer: Bob Rumsby <[email protected]> Committed: Thu May 14 18:04:17 2015 -0700 ---------------------------------------------------------------------- .../065-configuring-spotfire-server.md | 25 +++++++++++--------- 1 file changed, 14 insertions(+), 11 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/9fd0ccac/_docs/odbc-jdbc-interfaces/065-configuring-spotfire-server.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/065-configuring-spotfire-server.md b/_docs/odbc-jdbc-interfaces/065-configuring-spotfire-server.md index 674929c..b79d378 100644 --- a/_docs/odbc-jdbc-interfaces/065-configuring-spotfire-server.md +++ b/_docs/odbc-jdbc-interfaces/065-configuring-spotfire-server.md @@ -27,8 +27,11 @@ Drill provides standard JDBC connectivity, making it easy to integrate data expl The Drill Data Source template can now be configured with the TSS Configuration Tool. The Windows-based TSS Configuration Tool is recommended. If TSS is installed on a Linux system, you also need to install TSS on a small Windows-based system so you can utilize the Configuration Tool. In this case, it is also recommended that you install the Drill JDBC driver on the TSS Windows system. -1. Click **Start > All Programs > TIBCO Spotfire Server > Configure TIBCO Spotfire Server**. -2. Enter the Configuration Tool password that was specified when TSS was initially installed. 3. Once the Configuration Tool has connected to TSS, click the **Configuration** tab, then **Data Source Templates**. 4. In the Data Source Templates window, click the **New** button at the bottom of the window. 5. Provide a name for the data source template, then copy the following XML template into the **Data Source Template** box. When complete, click **OK**. 6. The new entry will now be available in the data source template. Check the box next to the new entry, then click **Save Configuration**. +1. Click **Start > All Programs > TIBCO Spotfire Server > Configure TIBCO Spotfire Server**.  +2. Enter the Configuration Tool password that was specified when TSS was initially installed. 3. Once the Configuration Tool has connected to TSS, click the **Configuration** tab, then **Data Source Templates**.  4. In the Data Source Templates window, click the **New** button at the bottom of the window.  5. Provide a name for the data source template, then copy the following XML template into the **Data Source Template** box. When complete, click **OK**.  6. The new entry will now be available in the data source template. Check the box next to the new entry, then click **Save Configuration**.  7. Select Database as the destination and click Next.  +8. Add a comment to the updated configuration and click **Finish**. +9. A response window is displayed to state that the configuration was successfully uploaded to TSS. Click **OK**.  +10. Restart TSS to enable it to use the Drill data source template. #### XML Template @@ -42,20 +45,20 @@ Make sure that you enter the correct ZooKeeper node name instead of `<zk-node>`, To configure Drill data sources in TSS, you need to use the Tibco Spotfire Desktop client. -1. Open Tibco Spotfire Desktop. -2. Log into TSS. -3. Select the deployment area in TSS to be used. -4. Click **Tools > Information Designer**. -5. In the Information Designer, click **New > Data Source**. -6. In the Data Source window, enter the name for the data source. Select the Drill Data Source template created in Step 2 as the type. Update the connection URL with the correct hostname of the ZooKeeper node(s) and the Drill cluster name. Note: The Zookeeper node(s) hostname(s) and Drill cluster name can be found in the `$DRILL_HOME/conf/drill-override.conf` file on any of the Drill nodes in the cluster. Enter the username and password used to connect to Drill. When completed, click **Save**. -7. In the Save As window, verify the name and the folder where you want to save the new data source in TSS. Click **Save** when done. TSS will now validate the information and save the new data source in TSS. 8. When the data source is saved, it will appear in the **Data Sources** tab, and you will be able to navigate the schema. +1. Open Tibco Spotfire Desktop.  +2. Log into TSS.  +3. Select the deployment area in TSS to be used.  +4. Click **Tools > Information Designer**.  +5. In the Information Designer, click **New > Data Source**.  +6. In the Data Source window, enter the name for the data source. Select the Drill Data Source template created in Step 2 as the type. Update the connection URL with the correct hostname of the ZooKeeper node(s) and the Drill cluster name. Note: The Zookeeper node(s) hostname(s) and Drill cluster name can be found in the `$DRILL_HOME/conf/drill-override.conf` file on any of the Drill nodes in the cluster. Enter the username and password used to connect to Drill. When completed, click **Save**.  +7. In the Save As window, verify the name and the folder where you want to save the new data source in TSS. Click **Save** when done. TSS will now validate the information and save the new data source in TSS. 8. When the data source is saved, it will appear in the **Data Sources** tab, and you will be able to navigate the schema.  ---------- ### Step 4: Query and Analyze the Data -After the Drill data source has been configured in the Information Designer, the information elements can be defined. 1. In this example all the columns of a Hive table have been defined, using the Drill data source, and added to an information link. -2. The SQL syntax to retrieve the data can be validated by clicking the **SQL** button. Many other operations can be performed in Information Link, including joins, filters, and so on. See the Tibco Spotfire documentation for details. 3. You can now import the data of this table into TSS by clicking the **Open Data** button. +After the Drill data source has been configured in the Information Designer, the information elements can be defined. 1. In this example all the columns of a Hive table have been defined, using the Drill data source, and added to an information link.  +2. The SQL syntax to retrieve the data can be validated by clicking the **SQL** button. Many other operations can be performed in Information Link, including joins, filters, and so on. See the Tibco Spotfire documentation for details. 3. You can now import the data of this table into TSS by clicking the **Open Data** button.  The data is now available in Tibco Spotfire Desktop to create various reports and tables as needed, and to be shared. For more information about creating charts, tables and reports, see the Tibco Spotfire documentation. ...
