drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [08/26] drill git commit: update spotfire server doc with captures
Date Sun, 17 May 2015 06:51:28 GMT
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 <brumsby@mapr.com>
Authored: Thu May 14 18:04:17 2015 -0700
Committer: Bob Rumsby <brumsby@mapr.com>
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**. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-start.png)
+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**. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-configtab.png)
4.
In the Data Source Templates window, click the **New** button at the bottom of the window.
![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-new.png)
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**. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-template.png)
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**. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-saveconfig.png)
7.
Select Database as the destination and click Next. ![drill query flow]({{ site.baseur
 l }}/docs/img/spotfire-server-saveconfig2.png) 
+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**. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-importconfig.png)
+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. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-client.png)
+2. Log into TSS. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-tss.png)
+3. Select the deployment area in TSS to be used. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-deployment.png)
+4. Click **Tools > Information Designer**. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-infodesigner.png)
+5. In the Information Designer, click **New > Data Source**. ![drill query flow]({{ site.baseurl
}}/docs/img/spotfire-server-infodesigner2.png)
+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**. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-connectionURL.png)
+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. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-datasources-tab.png)
 
 
 ----------
 
 ### 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. ![drill query flow]({{ site.baseurl
}}/docs/img/spotfire-server-infolink.png)
+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. ![drill query flow]({{ site.baseurl }}/docs/img/spotfire-server-hiveorders.png)
 
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.


...
 


Mime
View raw message