drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject drill git commit: new bi doc: drill with webfocus
Date Thu, 07 Apr 2016 22:27:06 GMT
Repository: drill
Updated Branches:
  refs/heads/gh-pages 44c91d38c -> 8e17a6cb0


new bi doc: drill with webfocus


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/8e17a6cb
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/8e17a6cb
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/8e17a6cb

Branch: refs/heads/gh-pages
Commit: 8e17a6cb05f88c705301f5967835f17634028615
Parents: 44c91d3
Author: Bridget Bevens <bbevens@maprtech.com>
Authored: Thu Apr 7 15:25:06 2016 -0700
Committer: Bridget Bevens <bbevens@maprtech.com>
Committed: Thu Apr 7 15:25:06 2016 -0700

----------------------------------------------------------------------
 .../075-using-apache-drill-with-webfocus.md     | 77 ++++++++++++++++++++
 1 file changed, 77 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/8e17a6cb/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/075-using-apache-drill-with-webfocus.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/075-using-apache-drill-with-webfocus.md
b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/075-using-apache-drill-with-webfocus.md
new file mode 100644
index 0000000..0ae3213
--- /dev/null
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/075-using-apache-drill-with-webfocus.md
@@ -0,0 +1,77 @@
+---
+title: "Using Information Builders’ WebFOCUS with Apache Drill"
+date:  
+parent: "Using Drill with BI Tools"
+---
+
+This document describes how to configure Information Builders’ WebFOCUS 8.2 with Apache
Drill. You can use WebFOCUS with Drill to couple the visualization and analytic capabilities
of WebFOCUS with the powerful SQL capabilities of Drill.  
+
+Complete the following steps to configure WebFOCUS with Apache Drill:  
+
+1. Install the Drill JDBC Driver on a Linux or Windows system configured with the WebFOCUS
environment.  
+2. Configure the WebFOCUS adapter and connections to Drill.  
+3. (Optional) Create additional Drill connections.  
+
+###Prerequisite  
+
+Drill 1.2 or later
+
+----------
+
+### Step 1: Install the Apache Drill JDBC driver.  
+
+Drill provides JDBC connectivity that easily integrates with WebFOCUS. See [{{site.baseurl}}/docs/using-the-jdbc-driver/](https://drill.apache.org/docs/using-the-jdbc-driver/)
for general installation steps.  
+
+Complete the following steps to install the driver:  
+
+1. Locate the Drill JDBC driver in the Drill installation directory on any node in the cluster
with Drill installed:  
+`<drill-home>/jars/jdbc-driver/drill-jdbc-all-<drill-version>.jar`  
+The following example shows the location of the driver on a MapR cluster:  
+`/opt/mapr/drill/drill-1.4.0/jars/jdbc-driver/drill-jdbc-all-1.4.0.jar`
+2.  Copy the Drill JDBC driver to a directory on the WebFOCUS system.  
+The following example shows the driver JAR file copied to a directory on a Linux server.
 
+`/usr/lib/drill-1.4.0/jdbc-driver/drill-jdbc-all-1.4.0.jar`
+
+
+----------
+
+### Step 2: Configure the WebFOCUS adapter and connections to Drill.  
+
+1. From a web browser, access the WebFOCUS Management Console. The WebFOCUS administrator
provides you with the URL information: `http://hostname:port/`  
+The default port is 8121.
+2. Click **Adapters** in the WebFOCUS Management Console.  
+![](http://i.imgur.com/owkjMKU.png)  
+The Apache Drill adapter appears in the list.  
+![](http://i.imgur.com/4y5EAzK.png) 
+3. Right-click on the Apache Drill adapter, and select **Configure** to open the configuration
form.
+4. Complete the configuration form. For security, provide the User and Password credentials
for the Drill cluster.  
+![](http://i.imgur.com/estSqu0.png)  
+ 
+5. After completing the configuration form click **Configure**. When the adapter is configured,
the following dialog appears:  
+![](http://i.imgur.com/qDbOtXa.png)
+6. Click **Test** to verify the configuration. If the configuration is successful, you see
a window similar to the following, otherwise you get error messages that need to be resolved:
 
+![](http://i.imgur.com/072YTag.png)  
+Now you can use the WebFOCUS adapter and connection or create additional connections.
+
+----------
+
+### (Optional) Step 3: Create additional Drill connections. 
+
+Complete the following steps to create additional connections:  
+
+1. Right-click on the configured Drill adapter, and select **Add connection**.  
+![](http://i.imgur.com/o06bn15.png)  
+2. Right-click on the connection, and select **Create or Update Synonym** to gather metadata.
 
+![](http://i.imgur.com/7BvXalY.png)    
+3. In the Synonym Candidates dialog, click **Next**.  
+![](http://i.imgur.com/lXnd0VK.png)
+4. In the Create Synonym for Apache Drill dialog, select the WebFOCUS Application folder
where you want to store your metadata, select the tables and views to use, and click **Next**.
 
+![](http://i.imgur.com/GbBOo59.png)  
+You should receive a message stating that the WebFOCUS metadata (synonyms) for the Apache
Drill objects were created successfully. Click **Close** to exit the message.
+5. Verify that WebFOCUS can access the Apache Drill objects.  
+       * Select the Application folder that contains the metadata created in the previous
steps.  
+       * Highlight the object that was created.  
+6. Right-click on that object, and select **Sample Data**. You should see a retrieval of
at least 50 records or possible error messages. If you get error messages, you must troubleshoot
them.  
+
+Drill is now configured as a data source that WebFOCUS can use to create content, such as
reports, charts, and graphs, and to perform analytics against.
+


Mime
View raw message