Google Git Google Git
Sign in
eclipse/gerrit/www.eclipse.org/webtools/refs/heads/master/./initial-contribution/IBM/evalGuides/DataToolsEval.html
blob: bb083c4473c930cb6caa8bb82ec80694837f69d4 [file]
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="DataToolsEval_files/filelist.xml">
<link rel=Edit-Time-Data href="DataToolsEval_files/editdata.mso">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Getting Started.html</title>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Der Ping Chou</o:Author>
<o:LastAuthor>Der Ping Chou</o:LastAuthor>
<o:Revision>2</o:Revision>
<o:TotalTime>348</o:TotalTime>
<o:Created>2004-07-13T00:46:00Z</o:Created>
<o:LastSaved>2004-07-13T00:46:00Z</o:LastSaved>
<o:Pages>1</o:Pages>
<o:Words>634</o:Words>
<o:Characters>3618</o:Characters>
<o:Company>IBM</o:Company>
<o:Lines>30</o:Lines>
<o:Paragraphs>8</o:Paragraphs>
<o:CharactersWithSpaces>4244</o:CharactersWithSpaces>
<o:Version>10.2625</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<link rel=Stylesheet type="text/css" media=all href="../theme/Master.css">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
h1
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
mso-outline-level:1;
font-size:24.0pt;
font-family:"Times New Roman";
font-weight:bold;}
h2
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
mso-outline-level:2;
font-size:18.0pt;
font-family:"Times New Roman";
font-weight:bold;}
h3
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
mso-outline-level:3;
font-size:13.5pt;
font-family:"Times New Roman";
font-weight:bold;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:216820099;
mso-list-template-ids:1277307288;}
@list l0:level1
{mso-level-start-at:4;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1
{mso-list-id:347800264;
mso-list-template-ids:-978969588;}
@list l1:level1
{mso-level-start-at:2;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2
{mso-list-id:628972938;
mso-list-template-ids:-1929337976;}
@list l3
{mso-list-id:925764890;
mso-list-template-ids:-1763424008;}
@list l3:level1
{mso-level-start-at:3;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l4
{mso-list-id:926772034;
mso-list-template-ids:35409304;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l4:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l4:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l4:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l4:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l4:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l4:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l4:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l5
{mso-list-id:1310207450;
mso-list-template-ids:2115414768;}
@list l5:level1
{mso-level-start-at:6;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6
{mso-list-id:1334600384;
mso-list-template-ids:1188730944;}
@list l6:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l7
{mso-list-id:1546019837;
mso-list-template-ids:1367504666;}
@list l7:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l8
{mso-list-id:2048412170;
mso-list-template-ids:1579335996;}
@list l8:level1
{mso-level-start-at:5;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
<meta http-equiv=Content-Style-Type content="text/css">
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US style='tab-interval:.5in'>
<div class=Section1>
<h1>Data Tools Evaluation Guide</h1>
<h2>1.0 Introduction</h2>
<p>The Data Tools contribution offers features to allow you to work with a
variety of databases.<br>
<br>
You can connect to the database, load and view database objects, sample the contents
of tables, and execute SQL statements and commands.<br>
<br>
This information will get you started using these features.</p>
<h2>2.0 Getting Started</h2>
<p>Before using the Data Tools components, you will need to have access to a
supported database and the information required to connect to it. </p>
<h2>3.0 Quick Tour</h2>
<p>The following sections give step-by-step instructions on how to use the Data
Tools functions.</p>
<h3>3.1 Opening the Data Views</h3>
<p>The Data Tools provides two views: the Database Explorer view and the DB
Output view. </p>
<p>The Database Explorer view is where you will create connections, view your
database objects and launch actions from those objects. The DB Output view is
where query results and messages are displayed.<br>
<br>
To open the Database Explorer view, select Window-&gt;Show view-&gt;Other-&gt;Data-&gt;
Database Explorer.<br>
To open the DB Output view, select Window-&gt;Show view-&gt;Other-&gt;Data-&gt;
DB Output view.<br>
Rearrange the views as follows:<br style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></p>
<p><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600"
o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f"
stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:221.25pt;
height:315pt'>
<v:imagedata src="DataToolsEval_files/image001.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=295 height=420
src="DataToolsEval_files/image002.jpg" v:shapes="_x0000_i1025"><![endif]></p>
<h3>3.2 Connecting to a Database</h3>
<p><span style='color:red'>{Can add Connection screencaps in this section}</span><br>
You can connect to a variety of database systems using the Connection Wizard.
Once connected, the database metadata is loaded, allowing you to view the
schemas, tables, columns and their data types.<br>
<br>
For example, if you have DB2 UDB v8.1 installed and the SAMPLE database
created, you can follow these steps to connect and load its database metadata:</p>
<ol start=1 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l6 level1 lfo3;tab-stops:list .5in'>Launch the Connection Wizard<br>
The Connection Wizard can be launched from the New Connection item in the
context menu of the Database Explorer (right mouse click on Database
Explorer View). </li>
</ol>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1026" type="#_x0000_t75"
style='width:491.25pt;height:136.5pt'>
<v:imagedata src="DataToolsEval_files/image003.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=655 height=182
src="DataToolsEval_files/image004.jpg" v:shapes="_x0000_i1026"><![endif]></p>
<ol start=2 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l6 level1 lfo3;tab-stops:list .5in'>Establish a Connection to a
Database Page<br>
Ensure the &quot;Choose a database manager and JDBC driver&quot; radio
button is selected and press Next. </li>
</ol>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1027" type="#_x0000_t75"
style='width:479.25pt;height:436.5pt'>
<v:imagedata src="DataToolsEval_files/image005.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=639 height=582
src="DataToolsEval_files/image006.jpg" v:shapes="_x0000_i1027"><![endif]></p>
<ol start=3 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l6 level1 lfo3;tab-stops:list .5in'>Specify Connection Parameters
Page<br>
In the Select a Database Manager tree, expand the DB2 Universal Database
node and select V8.1. In the Alias field, type &quot;SAMPLE&quot;. Press
the Test Connection button. After a successful connection, press Next.</li>
</ol>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1028" type="#_x0000_t75"
style='width:479.25pt;height:436.5pt'>
<v:imagedata src="DataToolsEval_files/image007.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=639 height=582
src="DataToolsEval_files/image008.jpg" v:shapes="_x0000_i1028"><![endif]></p>
<ol start=4 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l6 level1 lfo3;tab-stops:list .5in'>Limit the Objects Retrieved
from the Database catalog loading<br>
On this page you can filter the database objects that are retrieved. To
add a filter which excludes tables that start with &quot;C&quot;, press
the Add button to the right of the Table and Routine filter grid. In the
Add Object Filter dialog, select Table for the Target field, select NOT LIKE
for the Predicate field and type &quot;C%&quot; (without the quotes) in
the Predicate field, then press OK. Back in the main wizard page, click
Next.<br>
Note: If you are connecting to a database with a large number of database
objects, it is important to filter appropriately to reduce the number of
tables returned. </li>
</ol>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1029" type="#_x0000_t75"
style='width:353.25pt;height:135pt'>
<v:imagedata src="DataToolsEval_files/image009.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=471 height=180
src="DataToolsEval_files/image010.jpg" v:shapes="_x0000_i1029"><![endif]></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1030" type="#_x0000_t75"
style='width:479.25pt;height:436.5pt'>
<v:imagedata src="DataToolsEval_files/image011.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=639 height=582
src="DataToolsEval_files/image012.jpg" v:shapes="_x0000_i1030"><![endif]></p>
<ol start=5 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l6 level1 lfo3;tab-stops:list .5in'>Specify Connection Parameters
Page <span style='color:red'>{Q: same name as a previous page? or is it
because I'm on an older driver?}</span> <br>
Press Next. </li>
</ol>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1031" type="#_x0000_t75"
style='width:479.25pt;height:436.5pt'>
<v:imagedata src="DataToolsEval_files/image013.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=639 height=582
src="DataToolsEval_files/image014.jpg" v:shapes="_x0000_i1031"><![endif]></p>
<ol start=6 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l6 level1 lfo3;tab-stops:list .5in'>Summary Page<br>
Review your settings and press Finish. The database metadata will load. </li>
</ol>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1032" type="#_x0000_t75"
style='width:479.25pt;height:436.5pt'>
<v:imagedata src="DataToolsEval_files/image015.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=639 height=582
src="DataToolsEval_files/image016.jpg" v:shapes="_x0000_i1032"><![endif]></p>
<p>In the Database Explorer, you will see a tree structure representing your
connection and the database objects retrieved. <br>
<br>
<!--[if gte vml 1]><v:shape id="_x0000_i1033" type="#_x0000_t75" style='width:483.75pt;
height:318pt'>
<v:imagedata src="DataToolsEval_files/image017.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=645 height=424
src="DataToolsEval_files/image018.jpg" v:shapes="_x0000_i1033"><![endif]><span
style='mso-spacerun:yes'>&nbsp;</span></p>
<h3>3.3 Sampling Contents of a Table</h3>
<p>You can sample the contents of a table and see its data appear in the DB
Output view.</p>
<p>To sample the data from a table, expand the connection, database, schema and
Tables nodes in the Database Explorer. Using a table's context menu, select
Sample Contents. This displays the table's data in the Results tab of the DB
Output view.<br>
<br>
<!--[if gte vml 1]><v:shape id="_x0000_i1034" type="#_x0000_t75" style='width:488.25pt;
height:320.25pt'>
<v:imagedata src="DataToolsEval_files/image019.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=651 height=427
src="DataToolsEval_files/image020.jpg" v:shapes="_x0000_i1034"><![endif]></p>
<p><span style='color:red'><!--[if gte vml 1]><v:shape id="_x0000_i1035"
type="#_x0000_t75" style='width:489.75pt;height:318pt'>
<v:imagedata src="DataToolsEval_files/image021.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=653 height=424
src="DataToolsEval_files/image022.jpg" v:shapes="_x0000_i1035"><![endif]><span
style='mso-spacerun:yes'>&nbsp;</span></span></p>
<h3>3.4 Executing SQL Statements and Commands</h3>
<p>The Data Tools offer a way to execute SQL statements and commands through
its SQL Scrapbook editor. <br>
<br>
To invoke the SQL Scrapbook, select Open SQL Scrapbook from the connection node
context menu in the Database Explorer. The SQL Scrapbook opens in the editor
area. Type a SQL statement or command then execute it by selecting Execute from
the SQL menu or by selecting the Execute icon in the toolbar. <br>
<br>
<!--[if gte vml 1]><v:shape id="_x0000_i1036" type="#_x0000_t75" style='width:489.75pt;
height:159.75pt'>
<v:imagedata src="DataToolsEval_files/image023.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=653 height=213
src="DataToolsEval_files/image024.jpg" v:shapes="_x0000_i1036"><![endif]><span
style='color:red'><br style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]><o:p></o:p></span></p>
<p><!--[if gte vml 1]><v:shape id="_x0000_i1037" type="#_x0000_t75" style='width:489.75pt;
height:479.25pt'>
<v:imagedata src="DataToolsEval_files/image025.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=653 height=639
src="DataToolsEval_files/image026.jpg" v:shapes="_x0000_i1037"><![endif]></p>
<h2>4.0 Known Problems</h2>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo11;tab-stops:list .5in'>CLOB and BLOB data types do
not display well in the DB Output view.</li>
</ul>
<h2>5.0 Provide Feedback to Us</h2>
<P>We encourage development/design feed back on the <A
href="https://dev.eclipse.org/mailman/listinfo/wtp-dev">wtp-dev</A> mailing list. You can subscribe to the list via <A
href="https://dev.eclipse.org/mailman/listinfo/wtp-dev">this link</A>.<BR>
<BR>
For usage questions, discussion of bugs, and strange behaviour please post to the eclipse.webtools newsgroup. Information on the Web Tools Platform newsgroup can be found <A
href="http://www.eclipse.org/newsgroups/index.html">here</A>.</P>
</div>
</body>
</html>