| <html> |
| |
| <head> |
| <meta http-equiv=Content-Type content="text/html; charset=windows-1252"> |
| <meta name=Generator content="Microsoft Word 11 (filtered)"> |
| <title>DTP Connectivity: Data Source Explorer</title> |
| |
| <style> |
| <!-- |
| /* Font Definitions */ |
| @font-face |
| {font-family:Courier; |
| panose-1:2 7 4 9 2 2 5 2 4 4;} |
| @font-face |
| {font-family:Wingdings; |
| panose-1:5 0 0 0 0 0 0 0 0 0;} |
| @font-face |
| {font-family:Tahoma; |
| panose-1:2 11 6 4 3 5 4 4 2 4;} |
| /* Style Definitions */ |
| p.MsoNormal, li.MsoNormal, div.MsoNormal |
| {margin-top:0in; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:0in; |
| font-size:12.0pt; |
| font-family:"Times New Roman";} |
| h1 |
| {margin-top:12.0pt; |
| margin-right:0in; |
| margin-bottom:3.0pt; |
| margin-left:0in; |
| text-indent:0in; |
| page-break-after:avoid; |
| font-size:16.0pt; |
| font-family:Arial;} |
| h2 |
| {margin-top:12.0pt; |
| margin-right:0in; |
| margin-bottom:3.0pt; |
| margin-left:0in; |
| text-indent:0in; |
| page-break-after:avoid; |
| font-size:14.0pt; |
| font-family:Arial; |
| font-style:italic;} |
| h3 |
| {margin-top:12.0pt; |
| margin-right:0in; |
| margin-bottom:3.0pt; |
| margin-left:0in; |
| text-indent:0in; |
| page-break-after:avoid; |
| font-size:13.0pt; |
| font-family:Arial;} |
| h4 |
| {margin-top:12.0pt; |
| margin-right:0in; |
| margin-bottom:3.0pt; |
| margin-left:0in; |
| text-indent:0in; |
| page-break-after:avoid; |
| font-size:12.0pt; |
| font-family:"Times New Roman";} |
| h5 |
| {margin-top:12.0pt; |
| margin-right:0in; |
| margin-bottom:3.0pt; |
| margin-left:0in; |
| text-indent:0in; |
| font-size:11.0pt; |
| font-family:"Times New Roman"; |
| font-weight:normal;} |
| h6 |
| {margin-top:12.0pt; |
| margin-right:0in; |
| margin-bottom:3.0pt; |
| margin-left:0in; |
| text-indent:0in; |
| font-size:11.0pt; |
| font-family:"Times New Roman"; |
| font-weight:normal; |
| font-style:italic;} |
| p.MsoHeading7, li.MsoHeading7, div.MsoHeading7 |
| {margin-top:12.0pt; |
| margin-right:0in; |
| margin-bottom:3.0pt; |
| margin-left:0in; |
| text-indent:0in; |
| font-size:10.0pt; |
| font-family:Arial;} |
| p.MsoToc1, li.MsoToc1, div.MsoToc1 |
| {margin-top:0in; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:0in; |
| font-size:12.0pt; |
| font-family:"Times New Roman";} |
| p.MsoToc2, li.MsoToc2, div.MsoToc2 |
| {margin-top:0in; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:12.0pt; |
| font-size:12.0pt; |
| font-family:"Times New Roman";} |
| p.MsoToc3, li.MsoToc3, div.MsoToc3 |
| {margin-top:0in; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:24.0pt; |
| font-size:12.0pt; |
| font-family:"Times New Roman";} |
| p.MsoNormalIndent, li.MsoNormalIndent, div.MsoNormalIndent |
| {margin-top:0in; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:.5in; |
| font-size:12.0pt; |
| font-family:"Times New Roman";} |
| p.MsoHeader, li.MsoHeader, div.MsoHeader |
| {margin-top:0in; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:0in; |
| font-size:12.0pt; |
| font-family:"Times New Roman";} |
| p.MsoFooter, li.MsoFooter, div.MsoFooter |
| {margin-top:0in; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:0in; |
| font-size:12.0pt; |
| font-family:"Times New Roman";} |
| p.MsoToaHeading, li.MsoToaHeading, div.MsoToaHeading |
| {margin-top:6.0pt; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:0in; |
| font-size:12.0pt; |
| font-family:Arial; |
| font-weight:bold;} |
| p.MsoTitle, li.MsoTitle, div.MsoTitle |
| {margin-top:12.0pt; |
| margin-right:0in; |
| margin-bottom:3.0pt; |
| margin-left:0in; |
| text-align:center; |
| font-size:16.0pt; |
| font-family:Arial; |
| font-weight:bold;} |
| p.MsoBodyText, li.MsoBodyText, div.MsoBodyText |
| {margin:0in; |
| margin-bottom:.0001pt; |
| line-height:12.0pt; |
| font-size:9.0pt; |
| font-family:Arial; |
| color:black; |
| layout-grid-mode:line;} |
| a:link, span.MsoHyperlink |
| {color:blue; |
| text-decoration:underline;} |
| a:visited, span.MsoHyperlinkFollowed |
| {color:purple; |
| text-decoration:underline;} |
| p.MsoPlainText, li.MsoPlainText, div.MsoPlainText |
| {margin-top:0in; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:0in; |
| font-size:10.0pt; |
| font-family:"Courier New";} |
| p.MsoAcetate, li.MsoAcetate, div.MsoAcetate |
| {margin-top:0in; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:0in; |
| font-size:8.0pt; |
| font-family:Tahoma;} |
| p.XMLText, li.XMLText, div.XMLText |
| {margin-top:0in; |
| margin-right:0in; |
| margin-bottom:6.0pt; |
| margin-left:0in; |
| font-size:8.0pt; |
| font-family:"Courier New";} |
| /* Page Definitions */ |
| @page Section1 |
| {size:8.5in 11.0in; |
| margin:1.0in 1.25in 1.0in 1.25in;} |
| div.Section1 |
| {page:Section1;} |
| /* List Definitions */ |
| ol |
| {margin-bottom:0in;} |
| ul |
| {margin-bottom:0in;} |
| --> |
| </style> |
| |
| </head> |
| |
| <body lang=EN-US link=blue vlink=purple> |
| |
| <div class=Section1> |
| |
| <p class=MsoTitle>DTP Connectivity: Data Source Explorer</p> |
| |
| <p class=MsoTitle>Design Document</p> |
| |
| <p class=MsoTitle><a name="_Toc113792296">Version 0.</a>5</p> |
| |
| <p class=MsoTitle><a name="_Toc113792297">10/19/2005</a></p> |
| |
| <p class=MsoTitle><a name="_Toc113792298">Brian Fitzpatrick</a></p> |
| |
| <p class=MsoToaHeading>Table of Contents</p> |
| |
| <p class=MsoToc1><span class=MsoHyperlink><a href="#_Toc117497251">1.<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â </span>Introduction<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>2</span></a></span></p> |
| |
| <p class=MsoToc1><span class=MsoHyperlink><a href="#_Toc117497252">2.<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â </span>Requirements<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>2</span></a></span></p> |
| |
| <p class=MsoToc1><span class=MsoHyperlink><a href="#_Toc117497253">3.<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â </span>High-Level Design<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>2</span></a></span></p> |
| |
| <p class=MsoToc2><span class=MsoHyperlink><a href="#_Toc117497254">3.1<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â </span>Background<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>2</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497255">3.1.1<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>WSTÂ’s Database |
| Explorer<span style='color:windowtext;display:none;text-decoration:none'> </span><span |
| style='color:windowtext;display:none;text-decoration:none'>2</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497256">3.1.2<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>Sybase WorkSpaceÂ’s |
| Enterprise Explorer<span style='color:windowtext;display:none;text-decoration: |
| none'> </span><span |
| style='color:windowtext;display:none;text-decoration:none'>4</span></a></span></p> |
| |
| <p class=MsoToc2><span class=MsoHyperlink><a href="#_Toc117497257">3.2<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â </span>Data Source |
| Explorer<span style='color:windowtext;display:none;text-decoration:none'> </span><span |
| style='color:windowtext;display:none;text-decoration:none'>6</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497258">3.2.1<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>The Interface<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>6</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497259">3.2.2<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>Menu/Toolbar |
| Actions<span style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>8</span></a></span></p> |
| |
| <p class=MsoToc2><span class=MsoHyperlink><a href="#_Toc117497260">3.3<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â </span>Dependencies<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>9</span></a></span></p> |
| |
| <p class=MsoToc2><span class=MsoHyperlink><a href="#_Toc117497261">3.4<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â </span>Tasks<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>9</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497262">3.4.1<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>Create new Data |
| Source Explorer view based on either Platform or WTP extensible navigator.<span |
| style='color:windowtext;display:none;text-decoration:none'> </span><span |
| style='color:windowtext;display:none;text-decoration:none'>10</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497263">3.4.2<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>Create a Generic |
| JDBC profile<span style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>10</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497264">3.4.3<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>Create a |
| SQL/Database Model sub-profile<span style='color:windowtext;display:none; |
| text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>11</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497265">3.4.4<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>Create DSE actions<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>11</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497266">3.4.5<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>Create DSE filters<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>12</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497267">3.4.6<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>Create DSE |
| drag/drop capabilities<span style='color:windowtext;display:none;text-decoration: |
| none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>12</span></a></span></p> |
| |
| <p class=MsoToc2><span class=MsoHyperlink><a href="#_Toc117497268">3.5<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â </span>Additional Notes<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>12</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497269">3.5.1<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>SQL Model |
| Content/Label Providers<span style='color:windowtext;display:none;text-decoration: |
| none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>12</span></a></span></p> |
| |
| <p class=MsoToc3><span class=MsoHyperlink><a href="#_Toc117497270">3.5.2<span |
| style='color:windowtext;text-decoration:none'>Â Â Â Â Â Â Â </span>Common Components<span |
| style='color:windowtext;display:none;text-decoration:none'>. </span><span |
| style='color:windowtext;display:none;text-decoration:none'>13</span></a></span></p> |
| |
| <p class=MsoNormal> </p> |
| |
| <b><span style='font-size:16.0pt;font-family:Arial'><br clear=all |
| style='page-break-before:always'> |
| </span></b> |
| |
| <h1 style='margin-left:0in;text-indent:0in'><a name="_Toc113792299"></a><a |
| name="_Toc117497251">1.<span style='font:7.0pt "Times New Roman"'> |
| </span>Introduction</a></h1> |
| |
| <p class=MsoNormal>The purpose for this document is to describe the high-level |
| design of the Data Source Explorer for the DTP Connectivity project.</p> |
| |
| <h1 style='margin-left:0in;text-indent:0in'><a name="_Toc117497252"></a><a |
| name="_Toc113792300">2.<span style='font:7.0pt "Times New Roman"'> |
| </span>Requirement</a>s</h1> |
| |
| <p class=MsoNormal>The Data Source Explorer (DSE) should:</p> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>1)<span |
| style='font:7.0pt "Times New Roman"'> </span>Display |
| a list of connection profile (CP) instances.</p> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>2)<span |
| style='font:7.0pt "Times New Roman"'> </span>When |
| a CP is connectedÂ…</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>a)<span |
| style='font:7.0pt "Times New Roman"'> </span>Surface |
| capabilities of the CP (via context and view menu contributions and toolbar |
| contributions).</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>b)<span |
| style='font:7.0pt "Times New Roman"'> </span>Display |
| data source content (such as lists of stored procedures, functions, events, |
| tables, etc. for a database).</p> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>3)<span |
| style='font:7.0pt "Times New Roman"'> </span>Serve |
| as a mediator for drag and drop calls:</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>a)<span |
| style='font:7.0pt "Times New Roman"'> </span>Dragging |
| within the DSE (from one profile to another)</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>b)<span |
| style='font:7.0pt "Times New Roman"'> </span>Dragging |
| from the DSE to an outside target (such as to a view or editor)</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>c)<span |
| style='font:7.0pt "Times New Roman"'> </span>Dragging |
| from an outside source to a target inside the DSE</p> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>4)<span |
| style='font:7.0pt "Times New Roman"'> </span>Facilitate |
| import and export of CP instances and driver instances</p> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>5)<span |
| style='font:7.0pt "Times New Roman"'> </span>Be |
| extensible to support non-database CP if required by other projects</p> |
| |
| <h1 style='margin-left:0in;text-indent:0in'><a name="_Toc117497253">3.<span |
| style='font:7.0pt "Times New Roman"'> </span>High-Level |
| Design</a></h1> |
| |
| <h2 style='margin-left:0in;text-indent:0in'><a name="_Toc117497254">3.1<span |
| style='font:7.0pt "Times New Roman"'> </span>Background</a></h2> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497255">3.1.1<span |
| style='font:7.0pt "Times New Roman"'> </span>WSTÂ’s |
| Database Explorer</a></h3> |
| |
| <p class=MsoNormal>The current Database Explorer view that is contributed as |
| part of the WST project provides a method of creating a connection to a |
| database and displaying detailed information about that database. The screen |
| shot below shows an example that is connected to a local Sybase ASA database.</p> |
| |
| <p class=MsoNormal><img width=575 height=518 |
| src="DTP%20Connectivity%20DSE%20Design%200_5_files/image001.jpg"></p> |
| |
| <p class=MsoNormal>As you can see, the tree provides the following:</p> |
| |
| <ul style='margin-top:0in' type=disc> |
| <li class=MsoNormal>A list of connections</li> |
| <li class=MsoNormal>For each connected connection, it provides a list of |
| databases</li> |
| <li class=MsoNormal>For each database, it shows a list of schemas</li> |
| <li class=MsoNormal>For each schema, it shows the following:</li> |
| <ul style='margin-top:0in' type=circle> |
| <li class=MsoNormal>Dependencies</li> |
| <li class=MsoNormal>Stored Procedures</li> |
| <li class=MsoNormal>Tables</li> |
| <li class=MsoNormal>User-Defined Functions</li> |
| <li class=MsoNormal>Views</li> |
| </ul> |
| <li class=MsoNormal>For each table, it shows the following:</li> |
| <ul style='margin-top:0in' type=circle> |
| <li class=MsoNormal>Columns</li> |
| <li class=MsoNormal>Constraints</li> |
| <li class=MsoNormal>Dependencies</li> |
| <li class=MsoNormal>Indexes</li> |
| <li class=MsoNormal>Triggers</li> |
| </ul> |
| </ul> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497256">3.1.2<span |
| style='font:7.0pt "Times New Roman"'> </span>Sybase |
| WorkSpaceÂ’s </a>Enterprise Explorer</h3> |
| |
| <p class=MsoNormal>The Enterprise Explorer that is part of the Sybase WorkSpace |
| product also provides a method for connecting to a database and retrieving a |
| list of stored procedures. The screen shot below shows an example that is |
| connected to a local Sybase ASA database. The following is representative of |
| what the initial contribution for the Data Source Explorer was. It is intended |
| that this contribution be updated to reflect the above requirements and to |
| bring it in line with the capabilities of the WST Data Explorer.</p> |
| |
| <p class=MsoNormal><img width=358 height=784 |
| src="DTP%20Connectivity%20DSE%20Design%200_5_files/image002.jpg"></p> |
| |
| <p class=MsoNormal>As you can see, the tree provides the following:</p> |
| |
| <ul style='margin-top:0in' type=disc> |
| <li class=MsoNormal>A list of categories</li> |
| <li class=MsoNormal>A list of connection profiles for each category</li> |
| <li class=MsoNormal>A list of available database connection profiles for the |
| Databases category</li> |
| </ul> |
| |
| <p class=MsoNormal>For each JDBC profile, we provide:</p> |
| |
| <ul style='margin-top:0in' type=disc> |
| <li class=MsoNormal>A list of databases available for a given profile |
| connection (where available) (new to next version of Sybase WorkSpace)</li> |
| <li class=MsoNormal>A list of database schemas available for a given database |
| (new to next version of Sybase WorkSpace)</li> |
| <li class=MsoNormal>A list of Stored Procedures & Functions for the |
| connected profile</li> |
| <li class=MsoNormal>A list of parameters for each exposed Stored Procedure |
| & Function</li> |
| </ul> |
| |
| <p class=MsoNormal>Note: Though I suspect that the ability to inspect multiple |
| databases in certain DBMS systems is supported by the SQL model (via extending |
| the base database model), the old version of the Database Explorer from WTP |
| requires you connect to a specific database and I canÂ’t determine if it is |
| flexible enough to provide a list of databases and their resulting data trees. |
| We will hold an additional meeting to determine if this support can be added, |
| as Sybase ASE is not the only database that will need this functionality.</p> |
| |
| <h2 style='margin-left:0in;text-indent:0in'><a name="_Toc117497257">3.2<span |
| style='font:7.0pt "Times New Roman"'> </span>Data |
| Source Explorer</a></h2> |
| |
| <p class=MsoNormal>The Data Source Explorer is the main interface through which |
| the user will be interacting with other components in the DTP Connectivity |
| project. It will provide a method to create, maintain, and interact with |
| connection profiles (just databases initially, though the framework can support |
| other types of connections) in a single Eclipse view. </p> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497258">3.2.1<span |
| style='font:7.0pt "Times New Roman"'> </span>The |
| Interface</a></h3> |
| |
| <p class=MsoNormal>The Data Source Explorer (DSE) will be composed of a single |
| Eclipse view (accessible through the Window -> Show View menu or through a |
| perspective that opens the view automatically). The viewÂ’s tree will show a |
| hierarchy of categories, connection profiles, and database/SQL model |
| information.</p> |
| |
| <p class=MsoNormal>Question: Are we supporting refactoring of model objects? |
| For example, if a user wants to copy a table or stored procedure from one database |
| to another, do we support this? If not, what sort of refactoring will we |
| support?</p> |
| |
| <p class=MsoNormal>A sample tree might look something like the following:</p> |
| |
| <p class=MsoNormal><img width=360 height=867 |
| src="DTP%20Connectivity%20DSE%20Design%200_5_files/image003.jpg"></p> |
| |
| <h4 style='margin-left:0in;text-indent:0in'>3.2.1.1<span style='font:7.0pt "Times New Roman"'> |
| </span>Node Types</h4> |
| |
| <p class=MsoNormal>The following node types would be important to the Data |
| Source Explorer:</p> |
| |
| <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 |
| style='border-collapse:collapse;border:none'> |
| <tr> |
| <td width=175 valign=top style='width:131.4pt;border:solid navy 1.0pt; |
| background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Node Type</span></b></p> |
| </td> |
| <td width=415 valign=top style='width:311.4pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Description</span></b></p> |
| </td> |
| </tr> |
| <tr> |
| <td width=175 valign=top style='width:131.4pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Category</p> |
| </td> |
| <td width=415 valign=top style='width:311.4pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Category of Connection Profile. May be a parent or child |
| category, depending on depth.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=175 valign=top style='width:131.4pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Connection Profile</p> |
| </td> |
| <td width=415 valign=top style='width:311.4pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>The Connection Profile itself.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=175 valign=top style='width:131.4pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Other Nodes</p> |
| </td> |
| <td width=415 valign=top style='width:311.4pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>The Database & SQL model will contribute other nodes |
| (as appropriate) such as databases, schemas, stored procedures, tables, etc.</p> |
| </td> |
| </tr> |
| </table> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497259">3.2.2<span |
| style='font:7.0pt "Times New Roman"'> </span>Menu/Toolbar |
| Actions</a></h3> |
| |
| <h4 style='margin-left:0in;text-indent:0in'>3.2.2.1<span style='font:7.0pt "Times New Roman"'> |
| </span>Menus</h4> |
| |
| <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 |
| style='border-collapse:collapse;border:none'> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Node</span></b></p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Menu</span></b></p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Action</span></b></p> |
| </td> |
| </tr> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Category</p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>New</p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Opens the New Connection Profile wizard.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Connection Profile</p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Connect</p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Connects to the database and populates the SQL/Database |
| models.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal> </p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Disconnect</p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Disconnects from the database.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal> </p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Save Offline</p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Saves the SQL/Database models offline for use in |
| disconnected mode.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal> </p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Refresh</p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Repopulates the SQL/Database models (while connected).</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal> </p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Delete</p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Deletes the selected profile.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal> </p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Refresh</p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Refreshes the SQL/Database models from the connection or |
| offline instance.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal> </p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Duplicate</p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Copies the connection profile and creates a new instance |
| in the view.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal> </p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Rename</p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Allows renaming of the selected profile.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=197 valign=top style='width:2.05in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal> </p> |
| </td> |
| <td width=110 valign=top style='width:1.15in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Properties</p> |
| </td> |
| <td width=283 valign=top style='width:2.95in;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Opens the Properties dialog for the selected profile.</p> |
| </td> |
| </tr> |
| </table> |
| |
| <h4 style='margin-left:0in;text-indent:0in'>3.2.2.2<span style='font:7.0pt "Times New Roman"'> |
| </span>Toolbar Actions</h4> |
| |
| <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 |
| style='border-collapse:collapse;border:none'> |
| <tr> |
| <td width=187 valign=top style='width:1.95in;border:solid navy 1.0pt; |
| background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Button</span></b></p> |
| </td> |
| <td width=403 valign=top style='width:4.2in;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Action</span></b></p> |
| </td> |
| </tr> |
| <tr> |
| <td width=187 valign=top style='width:1.95in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Home</p> |
| </td> |
| <td width=403 valign=top style='width:4.2in;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>If currently drilled-into the view at a particular level, |
| this brings the user back to the top (root) level of the view.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=187 valign=top style='width:1.95in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Back</p> |
| </td> |
| <td width=403 valign=top style='width:4.2in;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>If currently drilled into the view at a level deeper than |
| the root, this moves back up a level in the hierarchy.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=187 valign=top style='width:1.95in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Go Into</p> |
| </td> |
| <td width=403 valign=top style='width:4.2in;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>If a container node is selected (i.e. a category), this |
| will drill into the hierarchy and make the selected node the root of the |
| view.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=187 valign=top style='width:1.95in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Collapse All</p> |
| </td> |
| <td width=403 valign=top style='width:4.2in;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Collapses all nodes in the view.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=187 valign=top style='width:1.95in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Export</p> |
| </td> |
| <td width=403 valign=top style='width:4.2in;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Exports one or more profiles to a file.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=187 valign=top style='width:1.95in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Import</p> |
| </td> |
| <td width=403 valign=top style='width:4.2in;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Imports one or more profiles from a file.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=187 valign=top style='width:1.95in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Show Categories Toggle</p> |
| </td> |
| <td width=403 valign=top style='width:4.2in;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>If set, the view will show a hierarchical view including |
| categories and subcategories. If not set, the view will show a simple, flat |
| list of profiles.</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=187 valign=top style='width:1.95in;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>New Connection Profile</p> |
| </td> |
| <td width=403 valign=top style='width:4.2in;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Opens the New Connection Profile wizard.</p> |
| </td> |
| </tr> |
| </table> |
| |
| <h2 style='margin-left:0in;text-indent:0in'><a name="_Toc117497260">3.3<span |
| style='font:7.0pt "Times New Roman"'> </span>Dependencies</a></h2> |
| |
| <p class=MsoNormal>We will be dependent on the following components:</p> |
| |
| <ul style='margin-top:0in' type=disc> |
| <li class=MsoNormal>WST Navigator Framework or Platform Extensible Navigator |
| Framework</li> |
| <li class=MsoNormal>SQL and Database Models</li> |
| <li class=MsoNormal>Profile Framework</li> |
| </ul> |
| |
| <h2 style='margin-left:0in;text-indent:0in'><a name="_Toc117497261">3.4<span |
| style='font:7.0pt "Times New Roman"'> </span>Tasks</a></h2> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>1)<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| new Data Source Explorer view based on either Platform or WTP extensible |
| navigator. </p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>a.<span |
| style='font:7.0pt "Times New Roman"'> </span>Use |
| the navigator framework to extend the Common Viewer. </p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>b.<span |
| style='font:7.0pt "Times New Roman"'> </span>Use |
| the new Profile Management tools in DTP Connectivity to populate the content |
| provider for the DSE.</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>c.<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| a label provider for the DSE. (Does the Profile framework manage icons?)</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>d.<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| a preference page for DSE preferences</p> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>2)<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| a Generic JDBC profile</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>a.<span |
| style='font:7.0pt "Times New Roman"'> </span>Use |
| the navigator framework to contribute a node for each profile</p> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>3)<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| a SQL/Database Model sub-profile</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>a.<span |
| style='font:7.0pt "Times New Roman"'> </span>Use |
| the navigator framework to contribute content from the Database/SQL models for |
| a given connection</p> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>4)<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| DSE actions</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>a.<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| Connect/Disconnect actions for profile nodes (use the connection management |
| tools available in Connectivity)</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>b.<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| Save and Work Offline actions for profile nodes (use persistence features of |
| SQL model)</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>c.<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| a Properties action for profile nodes</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>d.<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| a Refresh action for profile nodes</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>e.<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| an Export action (export wizard with the option to export driver instances)</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>f.<span |
| style='font:7.0pt "Times New Roman"'> |
| </span>Create an Import action (import wizard with the option to process |
| incoming driver instances (ignore/overwrite/rename/ignore all duplicates))</p> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>5)<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| DSE filters</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>a.<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| a filter that only shows database profiles</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>b.<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| a filter that only shows profiles for a given driver</p> |
| |
| <p class=MsoNormal style='margin-left:.5in;text-indent:-.25in'>6)<span |
| style='font:7.0pt "Times New Roman"'> </span>Create |
| DSE drag/drop capabilities</p> |
| |
| <p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'>a.<span |
| style='font:7.0pt "Times New Roman"'> </span>What |
| do we need to drag and drop?</p> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497262">3.4.1<span |
| style='font:7.0pt "Times New Roman"'> </span>Create new |
| Data Source Explorer view based on either Platform or WTP extensible navigator.</a> |
| </h3> |
| |
| <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 |
| style='border-collapse:collapse;border:none'> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Part</span></b></p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Dependency</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Risks</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Time to Complete (min/max)</span></b></p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Use the navigator framework to extend the Common Viewer.</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>WTP/DTP Navigator or Platform</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Will the Platform extensible navigator be available in M3?</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 day/3 days</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Use the new Profile Management tools in DTP Connectivity |
| to populate the content provider for the DSE.</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Connectivity Profile Framework</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>N/A</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 day/3 days</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Create a label provider for the DSE. (Does the Profile |
| framework manage icons?)</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Connectivity Profile Framework</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Icons</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 day/3 days</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Create a preference page for DSE preferences</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>None</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Unsure at this point what preferences this view will need</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 day/2 days</p> |
| </td> |
| </tr> |
| </table> |
| |
| <p class=MsoNormal> </p> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497263">3.4.2<span |
| style='font:7.0pt "Times New Roman"'> </span>Create a |
| Generic JDBC profile</a></h3> |
| |
| <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 |
| style='border-collapse:collapse;border:none'> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Part</span></b></p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Dependency</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Risks</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Time to Complete (min/max)</span></b></p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Use the navigator framework to contribute a node for each |
| profile</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>DSE</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>N/A</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 days/2 days</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Integrate with SQL/Database Model sub-profile</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>DSE & SQL/DB Model sub profile</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Understanding of the models</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>2 days/5 days</p> |
| </td> |
| </tr> |
| </table> |
| |
| <p class=MsoNormal> </p> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497264">3.4.3<span |
| style='font:7.0pt "Times New Roman"'> </span>Create a |
| SQL/Database Model sub-profile</a></h3> |
| |
| <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 |
| style='border-collapse:collapse;border:none'> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Part</span></b></p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Dependency</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Risks</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Time to Complete (min/max)</span></b></p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Use the navigator framework to contribute content from the |
| Database/SQL models for a given connection</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>DSE & SQL/DB Model sub profile</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Understanding of the models</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>2 days/5 days</p> |
| </td> |
| </tr> |
| </table> |
| |
| <p class=MsoNormal> </p> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497265">3.4.4<span |
| style='font:7.0pt "Times New Roman"'> </span>Create DSE |
| actions</a></h3> |
| |
| <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 |
| style='border-collapse:collapse;border:none'> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Part</span></b></p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Dependency</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Risks</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Time to Complete (min/max)</span></b></p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Create Connect/Disconnect actions for profile nodes (use |
| the connection management tools available in Connectivity)</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Connectivity Profile/ Connection Mgmt Framework</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Availability of connection management tools</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 day/3 days</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Create Save and Work Offline actions for profile nodes</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>SQL Model</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Availability of model persistence tools</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 day/2 days</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Create a Properties action for profile nodes</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Connectivity Profile Framework</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>N/A</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 day/2 days</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Create a Refresh action for profile nodes</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>DSE</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>N/A</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 day/1 day</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Create an Export action (export wizard with the option to |
| export driver instances)</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>DSE</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>N/A</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>2 days/3 days</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Create an Import action (import wizard with the option to |
| process incoming driver instances (ignore/overwrite/rename/ignore all |
| duplicates))</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>DSE</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>N/A</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>3 days/4 days</p> |
| </td> |
| </tr> |
| </table> |
| |
| <p class=MsoNormal> </p> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497266">3.4.5<span |
| style='font:7.0pt "Times New Roman"'> </span>Create DSE |
| filters</a></h3> |
| |
| <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 |
| style='border-collapse:collapse;border:none'> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Part</span></b></p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Dependency</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Risks</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Time to Complete (min/max)</span></b></p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Create a filter that only shows database profiles (by |
| category)</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>WTP/DTP Navigator or Platform and Connectivity Profile |
| Framework</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Filter capabilities in navigator framework</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 day/3 days</p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Create a filter that only shows profiles for a given |
| driver</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>WTP/DTP Navigator or Platform and Connectivity Profile |
| Framework and Driver Framework</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Filter capabilities in navigator framework</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>1 day/3 days</p> |
| </td> |
| </tr> |
| </table> |
| |
| <p class=MsoNormal> </p> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497267">3.4.6<span |
| style='font:7.0pt "Times New Roman"'> </span>Create DSE |
| drag/drop capabilities</a></h3> |
| |
| <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 |
| style='border-collapse:collapse;border:none'> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Part</span></b></p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Dependency</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Risks</span></b></p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border:solid navy 1.0pt; |
| border-left:none;background:navy;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal><b><span style='color:white'>Time to Complete (min/max)</span></b></p> |
| </td> |
| </tr> |
| <tr> |
| <td width=221 valign=top style='width:165.9pt;border:solid navy 1.0pt; |
| border-top:none;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>What do we need to drag and drop?</p> |
| </td> |
| <td width=98 valign=top style='width:73.5pt;border-top:none;border-left:none; |
| border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding:0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Unknown</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Unknown quantity at this point</p> |
| </td> |
| <td width=132 valign=top style='width:99.0pt;border-top:none;border-left: |
| none;border-bottom:solid navy 1.0pt;border-right:solid navy 1.0pt;padding: |
| 0in 5.4pt 0in 5.4pt'> |
| <p class=MsoNormal>Unknown</p> |
| </td> |
| </tr> |
| </table> |
| |
| <h2 style='margin-left:0in;text-indent:0in'><a name="_Toc117497268">3.5<span |
| style='font:7.0pt "Times New Roman"'> </span>Additional |
| Notes</a></h2> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497269">3.5.1<span |
| style='font:7.0pt "Times New Roman"'> </span>SQL Model |
| Content/Label Providers</a></h3> |
| |
| <p class=MsoNormal>The SQL Model Content and Label providers will be made |
| public so users have the ability to change them as necessary.</p> |
| |
| <h3 style='margin-left:0in;text-indent:0in'><a name="_Toc117497270">3.5.2<span |
| style='font:7.0pt "Times New Roman"'> </span>Common |
| Components</a></h3> |
| |
| <p class=MsoNormal>The DSE will provide several common components that can be |
| re-used and changed by DTP consumers. These include (more may be added):</p> |
| |
| <ul style='margin-top:0in' type=disc> |
| <li class=MsoNormal>Control to facilitate gathering of profile properties</li> |
| <li class=MsoNormal>New Connection Profile Wizard</li> |
| <li class=MsoNormal>Common wizard page using the common control to gather |
| profile properties</li> |
| <li class=MsoNormal>Common wizard page to collect profile name/description</li> |
| <li class=MsoNormal>Common property page to allow editing of profile |
| name/description</li> |
| <li class=MsoNormal>Common property page to allow editing of profile |
| properties</li> |
| <li class=MsoNormal>Generic dialog for connection profile selection</li> |
| <li class=MsoNormal>Control to display profile tree in various contexts |
| (property/preference/wizard pages, dialogs, etc.)</li> |
| <li class=MsoNormal>Common JDBC connection factory and connection classes</li> |
| <li class=MsoNormal>Common control to facilitate driver selection</li> |
| </ul> |
| |
| <p class=MsoNormal> </p> |
| |
| </div> |
| |
| </body> |
| |
| </html> |
