Author: blafond
Date: 2011-08-31 14:42:46 -0400 (Wed, 31 Aug 2011)
New Revision: 34445
Added:
trunk/documentation/whatsnew/teiid/images/create-source-function-dialog.png
trunk/documentation/whatsnew/teiid/images/generated-flat-file-diagram.png
trunk/documentation/whatsnew/teiid/images/generated-flat-file-view-table.png
trunk/documentation/whatsnew/teiid/images/genwarwithmtom.png
trunk/documentation/whatsnew/teiid/images/preview-data-decorators.png
trunk/documentation/whatsnew/teiid/images/show-sql-reserved-words-action.png
trunk/documentation/whatsnew/teiid/images/source-function.png
trunk/documentation/whatsnew/teiid/images/sql-reserved-words-view.png
trunk/documentation/whatsnew/teiid/images/teiid-designer-import-options.png
trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-configure.png
trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-page-1.png
trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-page-2.png
trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-parse-column.png
trunk/documentation/whatsnew/teiid/teiid-news-7.5.html
Log:
JBIDE-9626 Added what's new content from 7.5 community release
Added: trunk/documentation/whatsnew/teiid/images/create-source-function-dialog.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/create-source-function-dialog.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/generated-flat-file-diagram.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/generated-flat-file-diagram.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/generated-flat-file-view-table.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/generated-flat-file-view-table.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/genwarwithmtom.png
===================================================================
(Binary files differ)
Property changes on: trunk/documentation/whatsnew/teiid/images/genwarwithmtom.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/preview-data-decorators.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/preview-data-decorators.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/show-sql-reserved-words-action.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/show-sql-reserved-words-action.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/source-function.png
===================================================================
(Binary files differ)
Property changes on: trunk/documentation/whatsnew/teiid/images/source-function.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/sql-reserved-words-view.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/sql-reserved-words-view.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/teiid-designer-import-options.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/teiid-designer-import-options.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-configure.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-configure.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-page-1.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-page-1.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-page-2.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-page-2.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added:
trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-parse-column.png
===================================================================
(Binary files differ)
Property changes on:
trunk/documentation/whatsnew/teiid/images/teiid-metadata-file-import-parse-column.png
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/documentation/whatsnew/teiid/teiid-news-7.5.html
===================================================================
--- trunk/documentation/whatsnew/teiid/teiid-news-7.5.html (rev
0)
+++ trunk/documentation/whatsnew/teiid/teiid-news-7.5.html 2011-08-31 18:42:46 UTC (rev
34445)
@@ -0,0 +1,243 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html
xmlns="http://www.w3.org/1999/xhtml">
+<head>
+ <meta http-equiv="Content-Language" content="en-us">
+ <meta http-equiv="Content-Type"
+ content="text/html; charset=ISO-8859-1">
+ <link rel="stylesheet" href="../whatsnew.css">
+ <title>Teiid Designer What's New</title>
+ <script type="text/javascript">
+
+ var _gaq = _gaq || [];
+ _gaq.push(['_setAccount', 'UA-17645367-5']);
+ _gaq.push(['_trackPageview']);
+
+ (function() {
+ var ga = document.createElement('script'); ga.type =
'text/javascript'; ga.async = true;
+ ga.src = ('https:' == document.location.protocol ? 'https://ssl' :
'http://www') + '.google-analytics.com/ga.js';
+ var s = document.getElementsByTagName('script')[0];
s.parentNode.insertBefore(ga, s);
+ })();
+
+ </script>
+</head>
+<body>
+<h1>Teiid Designer 7.5 What's New</h1>
+<p align="right"><a href="../index.html">< Main
Index</a></p>
+<p>Last revised August 31, 2011</p>
+<p><b>Teiid Designer</b> is a graphical data modeling tool that
enables
+rapid definition, integration, management and testing of data services
+without programming using the <b>Teiid</b> runtime engine.</p>
+<p>For more details on <a
href="http://www.jboss.org/teiid.html">Teiid</a>
+and <a
href="http://www.jboss.org/teiiddesigner.html">Teiid
Designer</a>
+visit: <a
href="http://www.teiid.org">http://www.teiid.org</a></p>
+<table width="80%" border="0" cellpadding="10"
cellspacing="0">
+ <tbody>
+ <tr>
+ <td colspan="2">
+ <hr>
+ <h3><span style="font-size: 12pt;"><strong>Relational
Model
+Source Functions</strong></span></h3>
+ <hr> </td>
+ </tr>
+ <tr>
+ <td valign="top" align="left">
+ <p><b>Create Source Function<b> </b></b></p>
+ <b> </b></td>
+ <td valign="top">
+ <p> To improve ability to utilize database functions within View
+transformations, a new "<strong>New Child > Source
Function</strong>"
+
+action
+and
+wizard was added to assist in building a source procedure
+that conforms to a function structure, including input and output
+parameters. Prior to Teiid Designer 7.5, these functions were required
+to be modeled as User Defined functions.. (TEIIDDES-992)</p>
+ <p>To create a new Source Function, select a Relational Source
+Model in your workspace and select "<strong>New Child > Source
+Function</strong>". Enter your database function name, define input
+parameters including datatype and length, specify output parameter
+info, set options and click OK.</p>
+ <p>The resulting source function will be added to your model and
+will be represented by the <a
+
href="http://community.jboss.org/servlet/JiveServlet/showImage/102-1...
+ alt="source-function.png" class="jive-image"
+ src="images/source-function.png"
+ style="border: 0px solid ; width: 16px; height: 16px;"></a>
icon.</p>
+ <p><img style="border: 1px solid ; width: 449px; height:
551px;"
+ src="images/create-source-function-dialog.png"
+ alt="Create Source Function Dialog"><br>
+ </p>
+ <p><br>
+ </p>
+ </td>
+ </tr>
+ <tr>
+ <td colspan="2">
+ <hr>
+ <h3>New Flat File Import Wizard View</h3>
+ <hr> </td>
+ </tr>
+ <tr>
+ <td valign="top" align="left">
+ <p><b> <br>
+ </b></p>
+ </td>
+ <td valign="top">
+ <p>Teiid supports Flat Files as data sources. In release
+7.5, Teiid Designer introduces a new Import wizard designed to assist
+in creating the metadata models required to access the data in your
+flat files. As with Designer's JDBC, Salesforce and WSDL importers, the
+Flat File importer is based on utilizing a specific Data Tools
+Connection Profile. (TEIIDDES-1017)<br>
+ </p>
+ <p>The results of the importer will include a source model
+containing the three Flat File procedures supported by Teiid. Namely:</p>
+ <ul>
+ <li style="text-align: start;">getFiles()</li>
+ <li style="text-align: start;">getTextFiles()</li>
+ <li style="text-align: start;">saveFile()</li>
+ </ul>
+ <p>The importer will also create a new view model containing a
+view table for each of your selected flat file source files. Within
+these view tables will be generated SQL transformations containing the
+"getTextFiles()" procedure from your source model as well as the column
+definitions and parameters required for the Teiid TEXTTABLE() function
+used to query the data file. You can also choose to update an existing
+view model instead of creating a new view model.</p>
+ <p>The TEXTTABLE function, as defined in the Teiid documentation,
+processes character input to produce tabular ouptut. It supports both
+fixed and delimited file format parsing. The function itself defines
+what columns it projects. The TEXTTABLE function is implicitly a nested
+table and may be correlated to preceeding FROM clause entries.</p>
+ <p>TEXTTABLE(expression COLUMNS <COLUMN>, ... <span
+ class="error">[DELIMITER char]</span> <span
class="error">[(QUOTE|ESCAPE)
+char]</span> [HEADER <span class="error">[integer]</span>]
<span
+ class="error">[SKIP integer]</span>) AS name</p>
+ <p>Teiid Designer will construct the full SQL statement for each
+view table in the form:</p>
+ <p><strong>SELECT</strong></p>
+
<p><strong>
A.Name,
+A.Sport, A.Position, A.Team, A.City, A.StateCode,
A.AnnualSalary</strong></p>
+ <p><strong>
FROM</strong></p>
+
<p><strong>
(EXEC
+PlayerDataSource.getTextFiles('PlayerData.txt')) AS f, TEXTTABLE(f.file
+COLUMNS Name string, Sport string, Position string, Team string, City
+string, StateCode string, AnnualSalary string HEADER 2 SKIP 3) AS
A</strong></p>
+ <p>The import option is labeled "<strong>Flat File Source
+>> Source and View Model</strong>" and is show below in the
+Import wizard's first page under the Teiid Designer category.
<em>Note
+
+also
+that Designer's import labels have changed to reflect both a
+source (i.e. JDBC Database) and one or more target metamodels that will
+be created or updated during the import process.</em><br>
+ </p>
+ <p><img style="border: 1px solid ; width: 449px; height:
452px;"
+ src="images/teiid-designer-import-options.png" alt="Import
Options"><br>
+ </p>
+ <p>The first page of the wizard requires selection of an existing
+Flat File Source connection profile in order to locate the designer
+source file folder. Once selected (or created view "New..." button) the
+available data files will be displayed in the table.</p>
+ <p>Check each data file you wish to process. Each file will be
+used to construct a view table containing the required SQL
+transformation for retrieving your data and returning a result set.</p>
+ <p><img style="border: 1px solid ; width: 449px; height:
451px;"
+ src="images/teiid-metadata-file-import-page-1.png"
+ alt="Source Selection"><br>
+ </p>
+ <p>The first page of the wizard requires selection of an existing
+Flat File Source connection profile in order to locate the designer
+source file folder. Once selected (or created view "New..." button) the
+available data files will be displayed in the table.</p>
+ <p>Check each data file you wish to process. Each file will be
+used to construct a view table containing the required SQL
+transformation for retrieving your data and returning a result set.</p>
+ <p><img style="border: 1px solid ; width: 450px; height:
515px;"
+ src="images/teiid-metadata-file-import-configure.png"
+ alt="Parser Settings Dialog"><br>
+ </p>
+ <p>At any time you can select a data row in your <strong>File
+Contents Preview</strong> section and click the "<strong>Parse Selected
+Row</strong>" button. A dialog will be displayed showing the list of
+columns and the resulting column data. If your column data is not what
+you expected, you'll need to adjust your settings accordingly.<br>
+ </p>
+ <p><img style="width: 445px; height: 467px;"
+ alt="Parsed Column Data Dialog"
+ src="images/teiid-metadata-file-import-parse-column.png"><br>
+ </p>
+ <p>The last page of the wizard, the <strong>Target Models
+Definition</strong> page, contains two model definition sections. Both
+sections allow you to select a workspace location to place the
+generated model. In the case of the <strong>View Model Definition</strong>,
+you
+can select an existing view model via the "..." browse button and
+the "<strong>Update Existing Model</strong>" checkbox will be
selected.<br>
+ </p>
+ <p><img style="width: 449px; height: 478px;"
+ alt="Target Models Definition"
+ src="images/teiid-metadata-file-import-page-2.png"><br>
+ </p>
+ <p>This import operation will result in the generated source
+model shown below...<br>
+ </p>
+ <p><img style="width: 449px; height: 268px;"
+ alt="Flat File Source Procedures"
+ src="images/generated-flat-file-diagram.png"><br>
+ </p>
+ <p>... and generated view tables containing the completed SQL
+required to access the data in your flat file using the "getFiles"
+procedure above and the Teiid TEXTTABLE() function.<br>
+ </p>
+ <h3>Connection Management</h3>
+ <p><img style="width: 449px; height: 355px;"
+ alt="Generated Flat File View Table"
+ src="images/generated-flat-file-view-table.png"><br>
+ </p>
+ </td>
+ </tr>
+ <tr>
+ <td colspan="2">
+ <hr>
+ <h3>Teiid SQL Grammar Reserved Words View<br>
+ </h3>
+ <hr> </td>
+ </tr>
+ <tr>
+ <td valign="top" align="left">
+ <p><b>SQL Reserved Words View<b> </b></b></p>
+ <b> </b></td>
+ <td valign="top">Teiid supports a subset of various SQL reserved
+words. A full list of the supported reserved words is now available in
+a new SQL Reserverd Words view. You can open this view via
"<strong>Preferences
+>
+Other ... > Teiid Designer > SQ Reserved Words</strong>" or
+select the "<strong>Metadata > Show SQL Reserved
Words</strong>"
+action in the main toolbar shown below. (TEIIDDES-958)
+ <p><img style="border: 1px solid ; width: 331px; height:
227px;"
+ src="images/show-sql-reserved-words-action.png"
+ alt="Show SQL Reserved Words Action"><img style="border: 1px solid
;"
+ src="images/view-connection-info-dialog.png.png"
+ alt="View Connection Info Dialog"><br>
+ </p>
+ <p><img style="width: 449px; height: 200px;"
+ alt="SQL Reserved Words View"
src="images/sql-reserved-words-view.png"><br>
+ </p>
+ </td>
+ </tr>
+ <tr>
+ <td valign="top" align="left"><br>
+ </td>
+ <td valign="top"><br>
+ </td>
+ </tr>
+ <tr>
+ <td colspan="2">
+ <hr></td>
+ </tr>
+ </tbody>
+</table>
+</body>
+</html>
Property changes on: trunk/documentation/whatsnew/teiid/teiid-news-7.5.html
___________________________________________________________________
Added: svn:mime-type
+ text/plain