Home

JBoss Enterprise Data Services 5 Teiid Designer User Guide

1. Make All Lower Case Example SUPPLIERS gt suppliers lt Back Next gt Cancel Finish Figure 3 10 Import Options Finally choose the name for the model to be created defaults to profileName xmi The Into Folder field defines the target location for your new model Select the MyProject sources folder Now click Finish The source model has now been created your Model Explorer view should like like this 35 JBoss Enterprise Data Services 5 Teiid Designer User Guide E Model Explorer x Outline E x It amp amp MyProject v sources v Og TestMySOL xmi gt 4 i Package Diagram gt R Accounts ACCOUNT gt R Accounts CUSTOMER gt R Accounts HOLDINGS gt R Accounts PRODUCT gt m Data Source Figure 3 11 Model Explorer HS import declarations 2 5 Preview Data All execution capabilities in Designer Preview Data VDB execution require you to connect to a Server connection Once you are connected to a Teiid Server you can proceed with the following steps The Preview Data action allows you to preview a sample of data rows from your source In the Action Set list double click the action or select it then click Execute selected action In the dialog select the source table you want to preview as shown below Me Table or Procedure Selection allez Select table or procedure from workspace and click OK v i MyProject v source
2. Modeling Actions 7 Action Sets Execute selected action Consume SOAP Web Service oe Define Teiid Model Project 4 Create Web Services SOAP connection Generate relational models from WSDL Preview Data A Define VDB i Execute VDB Description Test a VDE by deploying to Teiid Server connecting to it via JDBC and executing queries against it via Datatools SQL Scrapbook Cheat Sheets Cheat sheets for Telid Designer use cases Create Model from JDBC Source Create Model from Flat File Source 2 Consume a SOAP Web Service Create Model from XML Local File Source Figure 3 17 Guides View To open the Cheat Sheet from the Guide View expand the Cheat Sheet section in the lower portion of the Guide View then select the Consume a SOAP Web Service link 2 Begin the Cheat Sheet The Consume a SOAP Web Service Cheat Sheet is shown below 39 40 JBoss Enterprise Data Services 5 Telid Designer User Guide Fi Cheat Sheets 2 ey oe Consume a SOAP Web Service This cheat sheet shows you how to consume a SOAP Web Service by creating source and view models based on the Web Service WSDL Click to Begin Create New Telid Model Project t Create SOAP Web Service Connection t Create Models From SOAP Connection Create VDB t Test VDB Figure 3 18 Consume SOAP Web Service Cheat Sheet To start the Cheat Sheet process
3. eee eee ennee C 1 Telid Designer Perspectives C 1 1 Telid Designer Perspective C 1 2 Opening a Perspective C 1 3 Further information C 2 Telid Designer Views C 2 1 Model Explorer View C 2 1 1 Selection Based Action Menus C 2 2 Outline View C 2 2 1 Outline Tree View C 2 2 2 Outline Thumbnail View C 2 3 Telid View C 2 4 Properties View C 2 5 Description View C 2 6 Problems View C 2 6 1 Toolbar Menu C 2 6 2 Context Menu C 2 7 Search Results View C 2 8 Datatype Hierarchy View C 2 9 Telid Model Classes View C 2 10 System Catalog View C 2 11 SQL Reserved Words View C 2 12 Model Extension Definition Registry View MED Registry View C 2 13 Guides View C 2 14 Status View C 2 15 Cheat Sheets View C 3 Editors C 3 1 Model Editor C 3 1 1 Diagram Editor C 3 1 1 1 Package Diagram C 3 1 1 2 Custom Diagram C 3 1 1 3 Transformation Diagram C 3 1 1 4 Mapping Diagram C 3 1 1 5 Mapping Transformation Diagram C 3 1 2 Table Editor C 3 1 2 1 Editing Properties C 3 1 2 2 Inserting Table Rows C 3 1 3 Simple Datatypes Editor C 3 1 4 Semantic Editor C 3 1 5 Source Editor C 3 1 6 Model Object Editors C 3 2 VDB Editor C 3 2 1 Editing Data Roles C 3 2 2 Editing Translator Overrides C 3 3 Model Extension Definition Editor C 4 Telid Designer Main Menu C 4 1 File Menu C 4 2 Edit Menu C 4 3 Refactor Menu C 4 4 Navigate Menu C 4 5 Search Menu C 4 6 Project Menu C 4 7 Metadata Menu C 4 8 Run Menu
4. s Step 3 Select File gt Save As action to open the Save Model As dialog Figure 8 5 Select Editor Tab 182 Chapter 8 Editing Models and Projects Save Model As Select a destination for the copy amp AllCustomerAccounts gt Og Northwind xmi gt Sources gt 3 BooksProject gt PartsProject gt t wSpLimportProject Enter the new model name Northwin d We st Ready to copy Cancel Figure 8 6 Save Model As Dialog e Step 4 Enter a unique model name in the new model name text field and click OK a Step 5 If dependent models are detected the Save Model As Import References dialog is presented to give you the opportunity to change any of the dependent models imports to reference the new model or not Save Model As Import References The following model files use or reference the model to be copied Select any that should be modified to use the new copy if AllCustomerAccounts CustomervViews xmi Select All Deselect All Cancel Figure 8 7 Save Model As Dialog 8 4 Clone Project Because each instance of of a model contains a unique ID and each object in each model contains a 183 JBoss Enterprise Data Services 5 Telid Designer User Guide unique ID copying a project is a delicate task For this reason the Clone Project action was created to manage the creation of exact structural copies of all models in the source project The following lists specific rules and limita
5. Model Size Warn If Model Size is Larger Than 30000 Relationship Options Show Role Names Show Multiplicity Restore Defaults Apply Figure B 3 Diagram Preferences Panel B 1 2 Diagram Printing Preferences Diagram print options are stored as preferences These can be accessed through this preference page by right click on diagram Page Setup action Or via the Modify Diagram Printing Preferences action located on the vertical diagram toolbar 206 User Preferences Diagram Printing co oo Diagram Print Orientation Portrait Landscape Scaling Atto One page Atto One page high as many as necessary wide Atto One page wide as many as necessary high Adjust to normal size Margins Top Left Right 0 0 iS Bottom Page Order Over then down Down then over Restore Defaults Apply Figure B 4 Diagram Preferences Panel B 1 3 Editor Preferences B 1 3 1 XML Document Preferences 207 JBoss Enterprise Data Services 5 Telid Designer User Guide Editor ov a XML Mapping Diagram Settings Auto expand tree when model has fewer than ral mapping classes Auto expand XML document tree to level 1 Hide Mapping Class Columns by Default XML Document Mapping Upper XML Recursion Limit 10 Remove Duplicate Attributes on Merge Figure B 5 XML Document Preferences Panel B 1 3 2 Table Editor Preferences information content fo
6. http terraservice usa ca mi http terraservice net terraservice2 asmx wsdl lt Back Next gt Cancel Figure 5 59 Namespace Resolution Dialog Step 6 The next page is titled Schema Workspace Location Selection This page lists all schemas imported by the WSDL along with any dependent schemas referenced within schemas as well as schemas embedded in the WSDL and indicates whether or not they are resolvable All resolved schemas will be created in a separate file and added to the workspace The editor panel allows you to change the default file name of the new schema file s If no errors select Next to proceed or Finish to complete with default option 110 Chapter 5 Importers Create Web Service from WSDL File WSDL Operations Selection Press the Next gt button to continue or the Anish button to finish Select the desired WSDL Operations w Ja Definitions file tmp terraservice23962930517375020849 wsdl v TerraServiceSoap ge ConvertLonLatPtloNearestPlace Deselect All 3 ConvertLonLatPtToUtmPt ge ConvertltmPtToLonLatPt i ConvertPlaceToLonLatPt 4 CountPlacesinRect a GetAreaFromPt i GetAreaFromRect i GetdreaFromTileld GetLatLonMetrics i GetPlaceFacts i GetPlaceList GetPlaceListinRect gg GetTheme a GetTileMetafromLonLatPt a GetTileMetaFromtTileld ae GetTile lt Back Cancel Figure 5 60 Namespace Resolution Dialog e Step 7 The last page titled XML Model Generation
7. 1 Kisselmeyer Abbiegale Tikvica 900005 Data line 2 Glore Diodie Vojvoda 9000060 G 71000 Dawson Pinckney Ostoja 9000061 6G 710 Waldrip lrix1ie Curic 9000062 G 57000 Kitchen 71 Lp ha Bulec 9000063 G 60000 N Parse Selected Row Edit Delimiter Character Edit TEXTTABLE function options Gg gt Column Information Column Name Datatype Fl LastName string Fl ArstName string E MiddleName string FY Empld string DELETE UP DOWN Generated SQL Statement SELECT A LastName A ArstName A MiddleName A Empld A Department A AnnualSalary A Title A HomePhone A Marld A Street A City A State A ZipCode FROM EXEC AAAA getTextRles EmployeeData txt AS f TEXTTABLE file COLUMNS LastName string ArstName string MiddleName string Empld string Department string AnnualSalary string Title string HomePhone string Mgrid string Street string City string State string ZipCode string HEADER AS A lt Back Cancel Anish Figure 5 13 Flat File Delimited Columns Options Page To aid in determining if your parser settings are correct you can select a data row in your File Contents Preview section and click the Parse Selected Row 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 69 70 JBoss Enterprise Data Services 5 Telid D
8. Succee SELECT FROM PartsSourceA Parts Oct 15 2010 Parts Teiid Connection PART ID PART_ NAME P300 Nut 2 P301 2 Bolt P302 Screw P303 Bolt P304 Cam Figure 9 13 SQL Results View 9 3 3 Deploy VDB from Model Explorer PART COLOR PART WEIGHT Red 12 2 Green 2 12 Blue 13 3 Green i Green You can also deploy your VDB first by selecting it in the Model Explorer and dragging dropping it onto a connected Telid instance in the Telid view or right click select Modeling gt Deploy action Once deployed you can select the VDB in the Telid View and right click select the Execute VDB action 194 Chapter 9 Testing Your Models there This will create a Telid Connection Profile specific for that VDB open the Database Development perspective and create a connection to your VDB Continue with Step s 2 and 3 above Note that if you do not have a Teiid instance defined or your default Telid instance is disconnected the following dialog will be displayed if the Modeling gt Deploy action is launched B No Teiid Instance x There is no connected default Teiid instance available A Create new Teiid instance or reconnect to existing Teiid and retry Deploy VDB Figure 9 14 No Teiid Instance Defined 9 3 4 Executing a Deployed VDB To execute a VDB that s been deployed manually follow the steps below To execute a VDB that s been deployed manually follow the steps below Step 1 Open the Database Devel
9. TORIES 1 error 1 warning 0 other Description lt Errors 1 item G SQL statement is w 4h Warnings 1 item a0 4 The type reference cone cree Ib 3 Delete Delete Select All Ctr A Showin Shift Alt w gt F i demi T Le ton mots ue H Properties Alt Enter Figure C 22 Problems View Context Menu Go To will open the appropriate editor and select the affected referenced object Show In Navigator Opens the Basic gt Navigator view if not open and expands file system tree and reveals applicable resource Copy Copies the problem information to the system clipboard Paste Pastes the problem information located in the system clipboard if applicable into the curor location for a specified text editor Delete Deletes the selected problem rows if applicable Select All selects all problems in the table Quick Fix Not yet implemented in T eiid Designer Properties displays a dialog containing additional information C 2 7 Search Results View Below is an example set of search results The view contains rows representing matches for your search parameters You can double click a entry and the object will be opened and selected in an editor and or the Model Explorer if applicable gt Ca Found 1 match PartsProject SampleViews xmi cv IB Found 7 matches PartsProject PartsVirtual xmi EY PART NAME PART _NAME ht
10. Transformation Diagram toolbar actions include amp Refresh Diagram Re draws diagram Show Parent Diagram Navigates to diagram for parent object if available E4 Preview Data Executes a simple preview query SELECT FROM i l Add Transformation Sources Add selected sources to transformation id Add Union Transformation Sources Add selected sources as union sources I Remove Transformation Sources Removed sources selected in diagram from transformation Clear Transformation Remove all sources from transformation Ea Open Transformation Reconciler dialog iH Save Diagram as Image Save the diagram image to file in JPG or BMP format Modify Diagram Printing Preferences Modify page layout information for printing diagrams Includes margins orientation etc Show Hide Page Grid Show current page boundaries as grid in diagram Context menus for the C 3 1 1 4 Mapping Diagram The Mapping Diagram represents a view of the mapping between virtual mapping class columns and XML document elements This mapping defines how source data is transformed from row based results into XML formatted text 243 JBoss Enterprise Data Services 5 Teiid Designer User Guide g kra ie bookCallection wv At sequence MC book wv ie book 4 isbn v 4 sequence ie title subtitle ie edition fe authors Ww if sequence MC author fe author je publishinglnformation ao E w AT sequence se publisher fet
11. lt undefined gt Figure 6 22 Function Panel Selected From the Category drop down list choose the type of function you want to add By default the Teiid Designer System offers the following categories Conversion for functions that convert one datatype into another Datetime for functions that handle date or time information a Miscellaneous for other functions Ti Numeric for mathematical and other numeric functions ol Ti String for string manipulation functions Any additional categories represent those containing user defined functions your site has created e Step 5 From the Function drop down list select the function you want The table beneath the drop down lists displays the number of arguments required for this function a Step 6 Click Apply a Step 7 Your function displays in the tree at the top Sub nodes display for each argument you need to set for this function 134 Chapter 6 Creating and Editing Model Objects Expression Builder Initial Expression undefined gt ee SOL View w CONCAT Books SourceB AUTHORS FIRSTNAME lt undefined gt Books SourceB AUTHORS FIRSTNAME 7 gt undefined gt Expression Editors Attribute Constant Function Choose Attribute below to replace selected lt undefined gt v E Books SourceB AUTHORS Books SourceB AUTHORS AUTHOR ID Books SourceB AUTHORS ARSTNAME Books SourceB AUTHORS LASTNAME Books SourceB AUT
12. 3 Balt 3 Green 17 Cam 2 Green 18 Figure 9 19 SQL Results View 5 Step 9 The query Execution Plan should also be displayed on the Teiid Execution Plan view tab The Execution Plan can also be generated without running the query In the SQL scrapbook rt click then select Telid_7 x gt Get Execution Plan Z SQL Results Teiid Execution Plan 3 Preview Data for myTbl SQL select fram vModel myTbl Text Plan Tree lt xml version 1 0 encoding UTF 8 standalone yes gt lt node name AccessNode gt lt property name Output Columns gt lt value gt INTKEY integer lt value gt lt Value gt STRINGKEY string lt value gt lt value gt INTNUM integer lt value gt lt Value gt STRINGNUM string lt value gt lt Value gt FLOATNUM double lt value gt lt vValue gt LONGNUM long lt value gt lt Value gt DOUBLENUM double lt value gt wrr mn DTEC IRA Sai ardea n m lA r Arline Figure 9 20 Teiid Execution Plan View 199 JBoss Enterprise Data Services 5 Telid Designer User Guide Chapter 10 Searching Designer provides multiple search actions located via Telid Designer sub menu in Eclipses Search menu The individual actions in the Telid Designer sub menu are described below Transformations Launches the Transformation Search dialog User can search models in the workspace for matching SQL text Search results appear in the dialog and user can select and view SQ
13. 4 1 1 Generate File Translator Procedures This builder option allows construction of a relational model containing one or more of the procedures required for accessing file based data via a file translator a Step 5 Select the model builder labeled Generate File Translator Procedures and click Next gt The Generate File Translator Procedures dialog will be displayed JBoss Enterprise Data Services 5 Telid Designer User Guide a Step 6 Check one ore more of the Available File Translator Procedures then click Finish 4 1 2 Generate Web Service Translator Procedures This builder option allows construction of a relational model containing one or more of the procedures required for accessing web service based XML data via a web s translator To create a new relational model containing web service based translator pror Pane complete Step 5 Select the model builder labeled Generate Web Service Translator Procedures and click Next gt The Generate Web Service Translator Procedures dialog will be displayed a Step 6 Check one ore more of the Available Web Services Translator Procedures then click Finish 4 1 3 Copy From Existing Model This builder option performs a structural copy of the contents of an existing model to a newly defined model You can choose a full copy or select individual model components for copy To create a new relational model by copying contents from another relational source meee complete
14. S p E Plug in Development gt E gt Run Debug gt E Team KE Teid Designer DDL Ale gt gt Source or View Model Designer Text Ale gt gt Source or View Models Eyr Ale Source Flat gt gt Source and View Model Eyr Ale Source XML gt gt Source and View Model JDBC Database gt gt Source Model ho Salesforce gt gt Source Model WSDL Ale or URL gt gt Source Model WSDL Ale or URL gt gt Web Service Model S XML Schemas gt E XML Cancel Figure 5 19 Import from XML File Source 75 i cc Cntarner ic A Vata Cr rN IHA nc D rT Qa i A NMacinn Ar lianr M IAN A Boss Enterprise Data Services 5 Telid Desi gnel User Guide L a Step 3 The next page of the wizard allows selection of the XML Import mode that specifies whether the XML file is local or remote The description at the top describes what operations this wizard will perform Select either the XML file on local file system or XML file via remote URL and click Next gt BL import From XML Ale Source XML Import File Options Select the desired XML Import Mode Description This wizard automates the construction of the source procedure and view table transformation necessary to query data fram your XML file source The view table transformation will contain a getTexthiles or invokeHTTP procedure and Utilize the XMLTABLE function The XML structure of your file will be presented to ald in selecting data elements to define your table column dat
15. Teiid Designer Ul Reference les F d4 bookCollection weft sequence MC book 2 7 id book ps isbn 7 i g input Sates ka bt S duernce K x a input Set tiia ry ish a C i r i i subtitle EN ISBM strimgl255 PUBLISHER ID int 2 edition subatle string E TITLE stringl2551 EJ MABE stringl255 ae ede Ay edition siting E SUBTITLE string 255 EY LOCATION string 255 T sequence MC author iti author e publishingirifarnaten ka ht Sequence te gubligher a2 publighDate 2 Diagram O Table Editor Figure C 42 Mapping Transformation Diagram Example Mapping Transformation Diagram toolbar actions include amp Refresh Diagram Re draws diagram I Show Parent Diagram Navigates to diagram for parent object if available WW Preview Data Executes a Simple preview query SELECT FROM a New Mapping Link Create a mapping link between selected mapping extent i e XML element or attribute and mapping class column a Remove Mapping Link Delete mapping link between selected mapping extent i e XML element or attribute and mapping class column i Add Transformation Sources Add selected sources to transformation id Add Union Transformation Sources Add selected sources as union sources Ed Remove Transformation Sources Removed sources selected in diagram from transformation t Clear Transformation Remove all sources from transformation a Open Transformat
16. The Model Editor contains sub editors which provide different views of the data or parts of data within an XMI model These sub editors specific to model types are listed below Diagram Editor All models except XML Schema models Table Editor All models 238 Simple Datatypes Editor XML Schema models only Semantics Editor XML Schema models only Source Editor XML Schema models only The VDB Editor is a single page editor containing panels for editing description model contents and data roles In addition to general Editors for models there are detailed editors designed for editing specific model object types These object editors include Transformation Editor Manages Transformation SQL for Relational View Base Tables Procedures and XML Web Service Operations Choice Editor Manages properties and criteria for XML choice elements in XML Document View models Input Editor Manages Input Set parameters used between Mapping Classes in XML Document View models Recursion Editor Manages recursion properties for recursive XML Elements in XML Document View models Operation Editor Manages SQL and Input Variables for Web Service Operations C 3 1 Model Editor The Model Editor is comprised of sub editors which provide multiple views of your data The Diagram Editor provides a graphical while the Table Editor provides spreadsheet like editing capabilities This section describes these various sub
17. Validation av Specify the Severity Level for validation related occurrences Relational XML Validation Control Settings XML Document Elements Attributes not referencing an XML Schema component Excluded Element from XML Document required by XML Schema XML document entity violates max occurs specified by its schema component Unmapped required XML element or attribute Excluded Elements Attributes from XML Document are mapped Mapped XML Element Attribute has fixed or default value Mapped XML Elements Attributes with zero minimum occurrences Mapped XML Elements Attributes with one maximum occurrence me XML Root Element mapped to Mapping Class Warning Mapped XML Elements Attributes Nillable Ignore Incompatible Datatypes for Column to Element Attribute Mappings Warning Restore Defaults Figure B 11 XML Document Model Validation Preferences Panel Validation ov v Specify the Severity Level for validation related occurrences Core Relational XSD Validation Control Settings lt gt XML Schema Document validation problems Ignore Figure B 12 XSD Schema Model Validation Preferences Panel Increasing the severity level to error will prevent you from testing your VDB or deploying a web service if violations of that preference are found during validation 212 Teiid Designer UI Reference Teiid Designer Ul Reference C 1 Telid Designer Perspectives A pers
18. string gt le publishingInformation BooksNS PublishingInformation IN_title string XPath for IN _ title bookCollection book title Figure 6 33 Edit Input Variables Dialog 6 3 Managing Model Object Extensions Extending a model adds extra properties to its model objects One good use of these extension properties is for passing data to a customized Data Services translator The Designer model extension framework consists of 6 3 1 Create New MED To create a new MED select the File gt New gt Other action to display the New wizard dialog Select the Telid Designer gt Telid Model Extension Defn option which displays the New Model Extension Definition dialog Browse and select existing project or project folder location for MED file and specify unique file name and press Finish Note if a project is already selected when wizard is launched the location field will be pre populated 144 Chapter 6 Creating and Editing Model Objects New Model Extension Definition New Model Extension Definition Press the Anish button to finish Folder Location ExtendedParts a Model Extension Definition Name ExtraParts Open in Extension Editor Cancel Figure 6 34 MED Editor Overview Tab 6 3 2 Edit MED To edit an MED file select an existing mxd file in your workspace and right click select the Open action On the Overview tab you can specify or change the Namespace Prefix Namespace
19. C 4 9 Window Menu C 4 10 Help Menu RCVISIONIMISLOLY wetoidseiigadaidacstevcsdeva avd abida aed ides Gene bichgueichesieteeue JBoss Enterprise Data Services 5 Teiid Designer User Guide Preface Preface 1 Document Conventions This manual uses several conventions to highlight certain words and phrases and draw attention to Specific pieces of information Liberation Fonts set is also used in HT ML editions if the set is installed on your system If not alternative but equivalent typefaces are displayed Note Red Hat Enterprise Linux 5 and later include the Liberation Fonts set by default 1 1 Typographic Conventions Four typographic conventions are used to call attention to specific words and phrases These conventions and the circumstances they apply to are as follows Mono spaced Bold Used to highlight system input including shell commands file names and paths Also used to highlight keys and key combinations For example To see the contents of the file my_next_bestselling novel in your current working directory enter the cat my_next_bestselling_novel command at the shell prompt and press Enter to execute the command The above includes a file name a shell command and a key all presented in mono spaced bold and all distinguishable thanks to context Key combinations can be distinguished from an individual key by the plus sign that connects each part of a key combination For example Press Enter to execute t
20. Description Property Value Base Tanslator Type Name 2 oracle Database Version Execution Factory Class name 7 org teiid translator jdbc oracle GracleExecutionFacton Is Immutable true Max number of dependent values across all IN F 50 Max number of IN predicate entries 1000 Max Prepared Insert Batch Size 2048 name translator oracle property Reguries Criteria false Supported Join Criteria 7 ANY Supports Full Outer Joins a false Figure C 56 VDB Translator Overrides Tab To override a specific translator type select the add translator action If a default Telid server instance is connected and available the Add Translator Override dialog below is presented the user selects an existing translator type and clicks OK Note that the override is only applicable to sources within the VDB so be sure and Select a translator type that corresponds to one of the VDB s source models The properties panel on the right side of the panel will contain editable cells for each property type based on the data type of the property i e boolean integer string etc 254 Teiid Designer Ul Reference Add Translator Override Choose the translator type whose properties you want to override loopback metamatrix modeshape mysql mysql5 olap oracle postgresql salesforce sqlserver sybase Cancel Figure C 57 Add Translator Override Dialog If no default Telid server instance is available the Add New
21. FRSLSE suppo lt columnm name ProductiD description Unique ID for this product datatype varcl lt columinm name ProductName datatype varchar length 60 nullable NULLABLE lt primary key name PK ProductiID namelnSource dbo products ProductData PK_P lt column name ProductiD gt lt column gt lt primary key gt lt table gt lt table name ProductSymbals namelnSource dbo products ProductSymbols cardin lt column name ProductiD description Unique ID for this product datatype varcl lt column name Symbold Type datatype numeric length 10 radix 10 precisio lt foreign key name FK_ProductiD uniqueKeyName PK ProductiD uniqueKeyTableN lt column nam e ProductiD gt lt column gt lt foreign key gt lt table gt lt procedure name getProductinfo namelnSource dbo products getProductinfo funct lt parameter name ID direction IN datatype numeric length 10 radix 10 p lt parameter gt lt parameter name productinfo dir ction RETURN datatype varchar length 98 lt parameter gt lt resultset name InfoResult gt lt colurmn name ProductiD datatype varchar length 10 nullable NO NULLS lt column nam e ProductName datatype varchar length 60 nullable NULLAE lt column name Producthype datatype varchar length L5 nullable NULLAB lt resultset gt lt procedure gt lt index name ProductiDindex autoupdate false nullable false unique true gt lt column name Pro
22. Text Plan Tree lt xml version 1 0 encoding UTF 8 standalone yes gt lt node name AccessNode gt lt property name Output Columns gt lt value gt INTKEY integer lt value gt lt value gt STRINGKEY string lt value gt lt value gt INTNUM integer lt value gt lt value gt STRINGNUM string lt value gt lt Value gt FLOATNUM double lt value gt lt Value gt LONGNUM long lt value gt lt Value gt DOUBLENUM double lt value gt wuss OYTOA IBA fata ete I ue Asli Figure 9 9 Teiid Execution Plan View 9 3 Testing With Your VDB In Telid Designer you can execute a VDB to test query actual data The requirements for VDB execution are A deployed VDB backed by valid deployed Data Sources An instance of a Teiid Connection Profile configured for the deployed VDB Telid Designer simplifies this process via Deploy VDB and Execute VDB actions Deploy VDB does just that deploy a selected VDB to a running Telid instance Execute VDB performs the VDB deployment creates a Telid Connection Profile opens the Database Development perspective and creates a connection to your VDB 9 3 1 Creating Data Sources The mechanism by which VDBs are able to query actual data sources is the Data Source These are deployed configurations backed by database or source connection jars Each source model referenced within a VDB requires a JNDI name representing a deployed Data Source When creating VDBs you do not need to have dep
23. amp Customer Create Web Service gt E Customel Generate SOL Relationships si Teiid P Ha Add To New Custom Diagram a Show Dependency Diagram Ctrl C bai Generate Dependency Report Figure 6 12 Modeling Sub Menu for Source Table Telid Designer also provides specialized object editors to handle complex model objects and their unique properties This section describes these editors in detail 6 2 1 Transformation Editor The Telid Designer s Transformation Editor enables you to create the query transformations that describe how to derive your virtual metadata information from physical metadata sources or other virtual metadata and how to update the sources The Transformation Editor provides a robust set of tools you can use to create these SQL queries You can use these tools or you can simply type an SQL query into the Transformation Editor To edit a transformation you can Double click Edit A relational view table or procedure in the Model Explorer or Diagram Editor A transformation node in a transformation diagram or mapping transformation diagram A mapping class in a mapping diagram or mapping transformation diagram Right click Edit action on selected object in the Model Explorer Diagram Editor or Table Editor A relational view table or procedure A transformation node in a transformation diagram or mapping transformation diagram A mapping class in a mapping diagram or mapping transformation diagram lf a Model Ed
24. data integration solution Telid Designer Telid Designer is a plug in for JBoss Developer Studio providing a graphical user interface to design and test virtual databases VDBs Connector Development Kit The Connector Development Kit is a Java API that allows users to customize the connector framework translators and resource adapters for specific integration needs ModeShape Tools ModeShape Tools is a set of plug ins for JBoss Developer Studio providing a graphical user interface to publish and manage Enterprise Data Services EDS artifacts such as VDBs and accompanying models in the ModeShape Metadata Repository 1 7 Administration Tools for EDS The following administration tools are available for administrators to configure and monitor a deployed EDS Service AdminShell AdminShell provides a script based programming environment enabling users to access monitor and control an EDS Service Admin Console The JBoss Enterprise Application Platform EAP Admin Console is a web based tool allowing system administrators to monitor and configure services deployed within a running EAP instance including Enterprise Data Services EDS JBoss Operations Network 14 Chapter 1 The Enterprise Data Services Platfo JBoss Operations Network JBoss ON provides a single interface to deploy manage and monitor an entire deployment of JBoss Enterprise Middleware applications and services including EDS Admin API EDS
25. different terminology that refers to that information They do so in a central location Our example enterprise information sources the address book database and the vendor supplied comma delimited text file reside in two different native storage formats and therefore have two Source Metadata models However they can represent one business need a pool of addresses for a mass mailing By creating a View Metadata model we could accurately show that this single View Table the AddressPool contains information from the two enterprise information systems The View Metadata model not only shows from where it gets the information but also the SQL operations it performs to select its information from its source models This View Metadata can not only reflect and describe how your organization uses that information but if your enterprise uses the Telid Designer Server your applications can use the View Metadata to resolve queries To create this View Metadata you create a view and define a transformation for that view a special query that enables you to select information from the source or even other view metadata models For more information see Section 6 2 1 Transformation Editor 2 3 6 3 Modeling Metadata Transformations Section on Modeling transformations Chapter 2 Introduction 2 3 6 3 1 Metadata Transformations By modeling View Metadata you can illustrate the business view of your enterprise information sourc
26. enter a unique valid view table name Press Finish to generate your models and finish the wizard Chapter 5 Importers Ou View Model Definition Press the Finish button to finish Import From XML Ale Source Selected Data File parts xml View Model Definition Location parts Name Paview S Model Status NEW MODEL New view tables will be created in a new view model PartView on FINISH New view table name PartsViewTable lt Back Cancel Figure 5 23 View Model Definition Page 5 5 Import From Salesforce You can create relational source models from your Salesforce connection using the steps below Depending the detail provided in the database connection URL information and schema Steps 5 through 7 may not be required Step 1 In Model Explorer choose the File gt Import action in the toolbar or select a project folder or model in the tree and choose Import Step 2 Select the import option Teiid Designer gt Salesforce gt gt Source Model and click Next gt Step 3 Select existing or previous connection profile from the drop down selector or press New button to launch the New Connection Profile dialog See Eclipse Data Tools documentation or Edit to modify change an existing connection profile prior to selection Note that the Connection Profile selection list will be populated with only Salesforce connection profiles 79 80 JBoss Enterprise Data Services 5 Tei
27. local or URL into a queryable relational procedures that represent your desired request and response web service structure defined through your WSDL s schema definition This importer is accessed by launching Eclipse s Import action and selecting the T elid Designer gt WSDL File or URL gt gt Source and View Model SOAP option Web Services Connection Profile defined by a WSDL file in your workspace or defined by a URL Designer will interpret the WSDL locate any associated or dependent XML schema files generate a physical model to invoke the service and generate virtual models containing procedures to build and parse the XML declared as the service messages To create relational models from WSDL use the steps below Step 1 In Model Explorer choose the File gt Import action in the toolbar or select a project folder or model in the tree and choose Import 92 Chapter 5 Importers e Step 2 Select the import option Telid Designer gt WSDL File or URL gt gt Source and View Model SOAP and click Next gt a Step 3 On the next page select an existing Web Service Connection Profile from the list or click the New Button to create a new profile J o Create Relational Model from Web Service Source and WSDL Operations Definition Press the Next gt button to continue Connection Profile CountryInfo gt WSDL URL or Location http ywww oorsprong org websamples countryinfo CountryinfoService wso
28. select the element you want to edit Step 2 Click Edit Criteria button to launch the Criteria Builder dialog Step 3 Use the Criteria Builder to create the conditions for which the Telid Designer Server will test to determine whether to choose this option in the XML instance document Step 4 Click OK The criteria you set displays both in the table and in the summary tab You must set a criterion for each option in your document unless you have selected to exclude that option or specify that option will be the default option 6 2 3 4 Setting Choice Element Order To edit the criteria for a choice element The Telid Designer Server evaluates the choice criteria in the order in which they appear and when one choice criteria is met the Telid Designer Server populates the XML instance document with that option The Telid Designer Server might not test all criteria for all options so their order matters a great deal JBoss Enterprise Data Services 5 Teiid Designer User Guide Therefore the order in which your options appear within the choice criteria often determines what information appears ultimately in your XML instance documents You can reorder the option list within the choice to set the order in which the Telid Designer Server tests the criteria A Rz _ To set this order select an element in the table and use the or button to move it into a new position in the table The new order displays both in the table and in the C
29. wa ext custom org teiid designer extension deprecated Relational 1 Designer 7 4 extension proper mymodelextension mymodelextension Relational 1 This is my model extension rest org teiid designer extension rest Relational 1 REST extended virtual procedu salesforce org teiid designer extension salesforce Relational 1 Salesforce extended relational y sourcefunction org telid designer extension sourcefunction Relational 1 Source Function properties Figure C 30 System Catalog View You can also open the view by selecting the MED Editor toolbar action in the right corner of shared sub editor header section For each registered MED the namespace prefix namespace URI extended model class version and description is shown In addition a flag indicating if the MED is built in is shown The Model Extension Registry view has toolbar actions that register a workspace MED file unregister a user defined MED and copy a registered MED to the workspace All these actions are also available via a context menu A MED registry keeps track of all the MEDs that are registered in a workspace Only registered MEDs can be used to extend a model There are 2 different types of MEDs stored in the registry Built In MED these are registered during Designer installation These MEDs cannot be updated or unregistered by the user User Defined MED these are created by the user These MEDs can be updated registered and unregistered by the user Note When a
30. whether the model exists or not Lastly enter a unique valid view table name Press Finish to generate your models and finish the wizard 71 72 JBoss Enterprise Data Services 5 Teiid Designer User Guide Import From Flat File Source View Model Definition Press the Anish button to finish Selected Data Ale PlayerData txt View Model Definition Location Name MyEmployeeViews xmi Model Status EXISTING MODEL New view tables will be created in your existing view model MyEmployeeViews xmi on FINISH New view table name P l aye rDataTable lt Back Cancel Figure 5 16 View Model Definition Page When your import is finished your source model will be opened in an editor and show a diagram containing the your getT extFiles procedure Chapter 5 Importers i Fa Figure 5 17 Generated Flat File Procedures In addition the view model will be opened in an editor and will show the generated view tables containing the completed SQL required to access the data in your flat file using the getT extFiles procedure above and the Teiid TEXTTABLE function The following figure is an example of a generated view table 73 JBoss Enterprise Data Services 5 Telid Designer User Guide VIEW SOURCES t pathAndExt string FJ file clob E filePath string p A A A A A A A A A A SELECT A LastName A FirstName A MiddleName A Empld A Department A AnnualSalary A Title A HomePh
31. Designer User Guide AS f 28a ea Mle s ET 4 Transformation Diagram Table Editor Transformation Editor T g amp cursor at 10 6 Be HASIA s T REATE VIRTUAL PROCEDURE BEGIN DECLARE integer VARIABLES insert_count 0 INSERT INTO RestfulBooks VirtualBooks RestfulBooks VirtualBooks ISBN RestfulBooks VirtualBooks TITLE RestfulBooks VirtualBooks SUBTITLE RestfulBooks VirtualBooks PUBLISHER RestfulBooks VirtualBooks PUBLISH_YEAR RestfulBooks VirtualBooks EDITION RestfulBooks VirtualBooks TYPE RestfulBooks VirtualBooks AUTHOR_ID VALUES RestfulBooks rputBook isbn_in RestfulBooks rputBook title_in RestfulBooks rputBook subtitle_in RestfulBooks rputBook publisher_in RestfulBooks rputBook publish_year_in RestfulBooks rputBook edition_in RestfulBooks rputBook type_in RestfulBooks rputBook author_id_in VARIABLES insert_count VARIABLES ROWCOUNT IF VARIABLES insert_count 1 BEGIN SELECT XMLCOMMENT Insert was successful AS result END ELSE BEGIN SELECT XMLCOMMENT Insert failed AS result END The input format for the REST procedure could be URI parameters an XML JSON document or some combination of both When using an XML document your root node should be lt input gt and the XML nodes should correspond to order of the procedure s input parameters For example here is the input for the above insert procedure lt input gt lt ISBN gt 0 13 014 714 1 99999 lt ISBN gt lt TITLE gt
32. Designer User Guide Import Database via JDBC Select Database Objects Press the Next gt button to continue F TestMySQL ED ACCOUNT ACCOUNT ACCOUNT ACCOUNT ACCOUNT ACCOUNT h Accounts ia TABLE ACCOUNT CUSTOMER HOLDINGS PRODUCT D 4 table object s selected to import Deselect All O Show Only Selected Schemas y Indexes Primary Key Imported Foreign gt O information schem TABLE CAT TABLE_SCHEM TABLE NAME COLUMN_NAME DATA ACCOUNT_ID SSN STATUS TYPE DATEOPENED DATECLOSED Se mer ee Figure 3 9 Select Database Objects On this page select the specific objects from the database that you want to import When finished click Next Chapter 3 Start Here Import Database via JDBC Specify Import Options Press the Next gt button to continue or the Finish button to finish Relational Model Definition _ _ _ _______________________________ Model Name TestMySQL xmi Into Folder MyProject sources m Make target a view model O Update if existing model selected Include Catalog For Fully Qualified Names Model Object Names Tables Procedures Columns etc Use Fully Qualified Names Example partssupplier dbo PARTS O Change Case For All Characters Case Options Make All Upper Case Example Suppliers gt SUPPLIERS
33. If you open the Expression builder your source functions will be selectable in the Function drop down selector for a Category named for the model as shown in the example below Expression Builder Initial Expression GETPRODUCTINFO ProductsOracle PRODUCTDATA INSTR_ID lige SQL View GETPRODUCTINFO Products Oracle PRODUCTDATA IN s1TR_ID ProductsOracle PRODUCTDATA INSTR_ID Expression Editors Attribute Constant Function Category PRODUCTSORACLE Function Argument Name Value PRODUCTID l ProductsOracle PRODUCTDATA INSTR_ID Cancel Figure 7 4 Source Function In Expression Builder 152 Chapter 7 Metadata specific Modeling 7 1 2 Create Relational Table Wizard In Telid Designer 7 6 a new action New Child gt Base Table was added to aid in creating tables complete with all of it s child entities This action replaces the original New Child gt Base Table which only created the empty table New Child Base Table Modeling gt Index Open fl Procedure Open With gt E View Copy t Base Table Ha Custom Diagram Figure 7 5 New Base Table Wizard Action Running the action will display the Create Relational Table wizard The wizard page contains 5 tabbed panels representing the various properties and components that make up the possible definition of a relational table Enter your table name define columns keys constraints and other options then click OK This wizard is desi
34. MEDs from the model click Finish to accept all of the changes Canceling the dialog will discard all changes and revert to the original model state 6 3 4 Setting Extended Property Values Extension properties are user defined properties available to any extended model object via the Properties View As shown below all extension properties are available up under the Extension category and are prefixed with a MED s namespace prefix If there is an initial value for an extension property it will be set to the default value using the property definition found in the MED Properties a E Description Property Value Extension mymodelextension Copyable true info Object URI Misc Cardinality Hid Logical Relationships Materialized i false Materialized Table l Name LA NewBaseTable Figure 6 40 Properties View For Extended Model Object 149 JBoss Enterprise Data Services 5 Telid Designer User Guide Chapter 7 Metadata specific Modeling This chapter discusses various features targeted at defining and managing metamodel specific objects 7 1 Relational Source Modeling 7 1 1 Source Function To improve ability to utilize database functions within View transformations a new New Child gt Source Function 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 Telid Designer 7 5 these functions were required to b
35. Match ctri flat m PA abe 4 Previous Match Ctri na E PARTS http _ al a Expand All PartsSource Ore EJ PART_WEIGH copy ctri c elal E SUPPLIER_P eG Remove Match sei Found 1 match b id W Remove Selected Matches Delete gt GA Found 7 matche gt a do id de Remowe All Matches ouni matet Search Again FS Figure C 24 Search Results Context Menu C 2 8 Datatype Hierarchy View TO open Teiid Designer s Datatype Hierarchy view select the main menu s Window gt Show View gt Other and select the Telid Designer gt Datatypes view in the dialog 228 p E Model Expl ZE Outline fs Datatype 335 lt v O anySimplelype xs any Type O anyUR gt of base64Binary Lad BookEdition xs nonNegativelnteger O boolean O date O dateTime v O decimal O bigdecimal xs decimal O biginteger xs decimal v O integer xs decimal t E long xs integer P o nonNegativelnteger xs integer Datatype details Property Value Defined by whiteSpace collapse decimal fractionDigits 0 integer maxinclusive 9223372036854775807 mininclusive 922337203685477580 pattern 0 9 integer Figure C 25 Datatype Hierarchy View Teiid Designer UI Reference The following table shows the mapping between Teiid Designer Types and Data Services Runtime Types 229 JBoss Enterprise Data Services 5 Telid Designer User Guide Table C 1 Corresponding Runtime Typ
36. Model Object Figure C 70 Search Menu The individual actions in the Telid Designer sub menu are described below Transformations Launches the Transformation Search dialog User can search models in the workspace for matching SQL text Search results appear in the dialog and user can select and view SQL as well as open desired transformations for editing _ Metadata Launches the Search dialog User can search for models in the workspace by specifying an Object Type and or a Data Type and or a property value Search results appear in the appropriate editor Find Model Object Launches the Find Model Object dialog which can be used to find an object in the workspace by specifying all or part of its name Selecting the object will open it in the appropriate editor 263 JBoss Enterprise Data Services 5 Teiid Designer User Guide Close Project Build Working Set gt Clean Build Automatically S Clone Project E Build Project Imports Build All Imports i Properties Figure C 71 Project Menu The individual actions in the Project menu are described below Open Project Launches the Open Project dialog Close Project Closes the currently selected project s 19 Build All Validates the contents of the entire workspace Any errors or warnings will appear in the Problems View Build Project Validates the contents of the selected project s Any errors or warnings will appear in the Pro
37. O UNION Query gt Flat File Local Source O XML File Local Source XML File URL Source SQL Template SELECT FROM TABLEA D Cancel Figure 7 17 SQL Templates Dialog A number of common SQL templates may be chosen using the dialog Depending on usage context the PROCEDURES tab may also be available in addition to the SELECT queries tab The SQL Template dialog can also be accessed in the Transformation Editor from the rt click context menu 7 3 XML Document Modeling 7 3 1 Create XML View Documents from schema You can create XML View Documents by selecting an element in the Model Explorer and selecting the Modeling gt Create XML View Documents action 165 JBoss Enterprise Data Services 5 Teiid Designer User Guide Las a d edar d baai a p cullen d tailed ition vw E Books xsd v 5 Books xsd 4_ BookDatatypes xsd i MetaMatrix Data Set Library Version 1 1 Boo t bibliography RaoksNS Riblinoranhy gt e bookListing New Child gt gt e bookCollectic New Sibling gt b bookSeiMixe New Association gt b Bibliography Modeling gt Create Scalar To XML Transformation b Bilbiographyt we Xs Create XML To Scalar Transformation gt Pasa d Undo Set org ecli to FK_Account_Accountld Create XM View Document i l Red D MII 5 KkFlat ae ae ee 2 4 it Add to Metadata Favorites b E BookSetN
38. SEARCHABLE Selectable lse true Updateable ee true w Misc Distinct Value Count T 1 Name TA SUPPLIER_NAME Name In Source TA SUPPLIER_NAME Null Value Count icp 1 v Type Datatype string Path http www w3 org 2001L KMLSc Native Type A varchar Nullable T NULLABLE Figure C 15 Properties View If the model for the object being edited is not open in an editor a dialog may appear confirming the attempt to modify the model and asking the user to confirm or cancel This dialog can be prevented by checking the preference Always open editor without prompting You can also check uncheck this property via the Telid Designer s main preference page ed Open Model Editor You must open this model in an editor tab before you can modify the property Value Do you want to open the editor Always open editor without prompting Cancel Figure C 16 Open Model Editor Dialog Properties can also be edited via a right click menu presented below 223 JBoss Enterprise Data Services 5 Telid Designer User Guide Value nt ea SUPPLIER NAi W Ca TA SUPPLIER_NA F9 CUE ka ma Copy lea Paste lel a string Path i Delete LA warchar F Select All Je T NULLABLE OL 2 Input Methods gt Us false Insert Unicode Control Character gt Inf live true rT synt Figure C 17 Open Model Editor Dialog The Properties toolbar contains the following actions E Show Categories toggles
39. Show Only Selected Schemas lt Back Next gt Cancel Anish Figure 5 7 Select Database Options Dialog e Step 7 On the Specify Import Options page specify desired Model Name as well as any other options used to customize the naming of your relational objects Press Finish to complete 63 JBoss Enterprise Data Services 5 Teiid Designer User Guide Import Database via JDBC Specify Import Options F Specify the name location and import options for the new relational model of Ji database PartsOraclell xmi Relational Model Definitio Model Name partsOraclell xmi Into Folder Parts Test Update if existing model selected Include Catalog For Fully Qualified Names Model Object Names Tables Procedures Columns etc Use Fully Qualified Names Example partssupplier dbo PARTS Change Case For All Characters Case Options Make All Upper Case Example Suppliers gt SUPPLIERS gt Make All Lower Case Example SUPPLIERS gt suppliers lt Back ext Cancel Anish Figure 5 8 Specify Import Options Dialog During the Finish processing a monitor will be displayed providing feedback on the import progress Progress Information Importing from JDBC database PartsOraclell Processing database object 1 of 5 creating BaseTable PARTS Figure 5 9 JDBC Import Progress Dialog 64 Chapter 5 Importers 5 3 Import From Flat File Source You can import metadata from
40. Step 3 The new relationship link is displayed in the diagram The Column Foreign Key Primary Key reference properties are properly set on the selected columns new primary key and new foreign key OR Step 1 Select a column in table Step 2 Drag the column to another table and drag over a column and drop onto this column The target column should highlight in Yellow Step 3 The new relationship link is displayed in the diagram The Column Foreign Key Primary 121 JBoss Enterprise Data Services 5 Telid Designer User Guide Key reference properties are properly set on the selected columns new primary key and new foreign key Step 1 Select two objects you wish to associate For example select columns in different base tables Step 2 Right click From the pop up menu select New Association gt Foreign Key Relationship Step 3 New Foreign Key and Primary Key objects will be added to the contents of their respective tabs in the Table Editor The Column Foreign Key Primary Key reference properties are properly set on the selected columns new primary key and new foreign key 6 2 Model Object Editors The primary actions for editing model objects are Cut Deletes the selected object s and copies it to the clipboard Copy Copies the selected object s to the clipboard Paste Pastes the contents of the clipboard to the selected context Clone Duplicates the selected object in the same location with the sam
41. Translator Override dialog is presented Enter a unique name for the translator override i e oracle_override a valid translator type name i e oracle and click OK The properties panel on the right side of the panel will allow adding editing and removing key value string based property sets When editing these properties all values will be treated as type string Add New Translator Override A Teiid server is not available so translator types are not available A translator name and translator type are both required when creating a translator override Press OK when finished Type PY Cancel Figure C 58 Add New Translator Override Dialog C 3 3 Model Extension Definition Editor The MED Editor is a multi tabbed editor and is used to create and edit user defined MEDs mxd files in the workspace The MED Editor has 3 sub editors Overview Properties and Source which share a common header section Here are the MED sub editor tabs Overview Sub Editor this editor is where the general MED information is managed This information includes the namespace prefix namespace URI extended model class and the description The Overview sub editor looks like this 255 JBoss Enterprise Data Services 5 Teiid Designer User Guide Overview Namespace Prefix myrmodelextension Namespace URI 9 mymodelextension Model Class Relational y Model Types Version 1 Description This is
42. WSDL Select Port CountryinfoServiceSoap v Binding SOAP11 Service Mode PAYLOAD hed Select the desired WSDL Operations Select All Operation B Deselect All W CountryName CurrencyName wf E FullCountryinfo E gt FullCountryinfoAllCountries E gt LanguagelSOCode LanguageName Selection Details peration CountryName binding CountrylnfoServiceSoapBinding port CountrylnfoServiceSoap service CountryinfoService id http viwww oorsprong org websamples countryinfo CountryinfoServiceSoap Binding CountryName lt Back Next gt Cancel Finish Figure 5 39 WSDL Source Selection a Step 4 Select individual Web Service Operations to model The default behavior of this page selects all available operations in the tree Operations can be de selected if they are not being modeled The Selection Details panel displays static information about the operation such as the names of the input and output messages and faults thrown by the operation Click Next gt a Step 5 The next page entitled Model Definition requires both a model location i e folder or project and a valid model name for both source and view models Use the Browse button to select existing folders or models Click Next gt when all the information is defined 93 JBoss Enterprise Data Services 5 Telid Designer User Guide 94 O Create Relational Model from W
43. WSDL File XML Model Generation Ready to generate the Web service model Generate virtual XML document model Location WSDLimportProject XML Model OnHandWSRe sponses lt Back Vext gt Cancel Finish Figure 5 49 Namespace Resolution Dialog 101 JBoss Enterprise Data Services 5 Teiid Designer User Guide In order to successfully generate Web Services from WSDL the WSDL must be error free WSDL validation is performed during Step 3 above If errors do exist a error summary dialog will be displayed shown below and you will not be able to Finish the wizard until the WSDL problems are fixed or you re import and select a valid WSDL file Create Web Service from WSDL File Validation Problems amp One or more selected WSDL files have errors Please correct or remove the filel sito proceed WSDL Validation Panel message wsdl file X eve elt 1 Cannot find the declaration of element wsdl definitions http terraservice net terraservice2 asmx wsdl Figure 5 50 WSDL Validation Problems Dialog 5 8 2 Import WSDL From File System Location You can create a Web Service model by selecting a WSDL file from your local file system a Step 1 Choose the File Import choose the File gt Import action t in the toolbar or select a project folder or model in the tree and choose Import e Step 2 Select the import option Telid Designer gt WSDL File or URL gt gt Web Service Model and click Next gt a Step
44. War Generation Telid Designer allows you to expose your VDBs via a SOAP or REST interface JBoSSWS CXF or REST Easy wars can be generated based on models within your VDBs This section describes these wizards in detail 7 4 2 1 Generating a JBossWS CXF War The Telid Designer provides web service generation capabilities in the form of a JBoSSWS CXF war source you are ready to expose the web service using the generated war To generate a new JBoSSWS CXF war using the VDB Step 1 Right click on the VDB containing your web service model s and select the Modeling gt Generate JBoSSWS CXF War action b MarketDataView WE aaa gt ari abel b i MarketData CW X gorra z a on E PortfolioVDB vdb ee ia E RestfulBooks Open GElindateahleAankewe Open With gt Step 2 Fill in missing properties in Web Service War Generation Wizard shown below Create Web Service WAR File Create a WAR file to deploy as a Web Service Enter the required information then click OK to create the WAR file are WAR Creation Information Context Name PartfolioVDB Web Server Host localhost Web Server Port 8080 VOB JNDI Name PartfolioVDB Security When using HTTPBasic security a local Teiid connection is required using the PassthroughAuthentication property None HTTPBasic WS Security Username Token _HTTPBasic Options Realm Role WS Security Options Username Password General Options
45. XML documents from XML schema 4 3 1 Copy From Existing Model This builder option performs a structural copy of the contents of an existing model to a newly defined model You can choose a full copy or select individual model components for copy To create a new relational model by copying contents from another XML document view model 53 JBoss Enterprise Data Services 5 Telid Designer User Guide Step 5 Select the model builder labeled Copy from existing model of the same model class and click Next gt The Copy Existing Model dialog will be displayed Step 6 Select an existing relational model from the workspace using the browse button Step 7 Check the Copy all descriptions option if desired Click Finish 4 3 2 Build XML Documents From XML Schema This option creates an XML View document model based on a selected XML schema and its dependencies Step 5 Select the model builder labeled Build XML documents from XML schema and click Next gt The Select XML Schema dialog will be displayed Step 6 Select an existing schema model from the workspace using the browse button An existing model will be pre selected if an XSD model in the workspace is selected in the VDB explorer prior to starting the new model wizard The schema must be found in the workspace so if you need to get one or more into the workspace use the XSD Schemas on file system importer Step 7 Move the available schema root elements you want to become
46. a snapshot of a metadata model for the Telid Designer Server to use when resolving queries from your client applications This run time metadata represents a static version of design time metadata you created or imported This snapshot is in the form of a Virtual Database definition or VDB As you create this runtime metadata the T elid Designer derives the runtime metadata from a consistent set of metadata models creates a subset of design time metadata focusing on the technical metadata that describes the access to underlying enterprise information systems optimizes runtime metadata for data access performance You can continue to work with the design time metadata but once you have created a runtime metadata model it remains static 2 3 6 Source and View Metadata In addition to the distinction between business and technical metadata you should know the difference between Source Metadata and View Metadata Source and View metadata refer to what the metadata represents not its content Source Metadata directly represents metadata for an enterprise information system and captures exactly where and how the data is maintained Source Metadata sounds similar to technical metadata but Source Metadata can contain both technical and business metadata When you model Source Metadata you are modeling the data that your enterprise information systems contain View Metadata on the other hand represent tailored views that transform
47. allows you to change the name of the XML View model if the Generate virtual XML document model is checked Input desired name or use the default name provide Select Finish to complete 111 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Web Service from WSDL File Schema Workspace Location Selection All workspace schema locations are valid Click Next to continue Schema Location Information jy Namespace Source Ale Target Path 4 Editor http terraservice usa com Folder WSDLimportProject Name without file extension terraservice23962930517375020849 Figure 5 61 Namespace Resolution Dialog In order to successfully generate Web Services from WSDL the WSDL must be error free WSDL validation is performed during Step 3 above If errors do exist a error summary dialog will be displayed shown below and you will not be able to Finish the wizard until the WSDL problems are fixed or you re import and select a valid WSDL file 112 Chapter 5 Importers Create Web Service from WSDL File Validation Problems amp One or more selected WSDL files have errors Please correct or remove the filelsito proceed WSDL Validation Panel message wsdl file X ewe elt 1 Cannot find the declaration of element wsdl definitions http terraservice net terraservice2 asmx wsdl Figure 5 62 WSDL Validation Problems Dialog 5 9 XSD Schema File You can import XML Schema fil
48. apply to the current session or services that need restarting before an update will apply Ignoring a box labeled Important will not cause data loss but may cause irritation and frustration Warnings should not be ignored Ignoring warnings will most likely cause data loss 2 Getting Help and Giving Feedback 2 1 Do You Need Help If you experience difficulty with a procedure described in this documentation visit the Red Hat Customer Search or browse through a knowledgebase of technical support articles about Red Hat products Submit a support case to Red Hat Global Support Services GSS access other product documentation JBoss Enterprise Data Services 5 Telid Designer User Guide Red Hat also hosts a large number of electronic mailing lists for discussion of Red Hat software and Click on the name of any mailing list to subscribe to that list or to access the list archives 2 2 Give us Feedback If you find a typographical error or know how this guide can be improved we would love to hear from you Submit a report in Bugzilla against the product JBoss Enterprise SOA Platform and the component doc Teiid_Designer_User_Guide The following link will take you to a pre filled bug Fill out the following template in Bugzilla s Description field Be as specific as possible when describing the issue this will help ensure that we can fix it quickly Document URL Section Number and Name Describe the issue Suggestio
49. as the datatypes defining permissible values in XML documents Web Services which define Web service interfaces operations and operation input and output parameters in the form of XML Schemas Function The Function metamodel supports the capability to provide user defined functions including binary source jars to use in custom transformation SQL statements 2 4 5 Models and VDBs Models used for data integration are packaged into a Virtual Database VDB The models must be ina complete and consistent state when used for data integration That is the VDB must contain all the models and all resources they depend upon VDB s are the transport mechanism to expose both the metadata to query against on a server and the corresponding references to the data sources and connections required to perform the actual DB queries Models and Connection Profiles A connection profile provides the connectivity to a data source and is defined by the Eclipse Data Tools Project DTP framework Designer utilizes this framework from withing it s JDBC Importer 2 4 6 Model Validation Models must be in a valid state in order to be used for data access Validation of a single model means that it must be in a self consistent and complete state meaning that there are no missing pieces and no references to non existent entities Validation of multiple models checks that all inter model dependencies are present and resolvable Models must always be val
50. between categorized properties and flat alphabetical properties list P Show Advanced Properties shows hide advanced properties if available E Restore Default Value for a selected property this action will reset the current to a default value if available C 2 5 Description View The Description View provides a means to display and edit add change or remove a description for any model or model object To show the Description View click Window gt Show View gt Other to display PRODUCTDATA table contains various stock attribute values including basic name primary business type etc Primary key ks PK_PD_INSTR_ID Figure C 18 Description View You can click the edit description action in the toolbar or right click select Edit in the context menu to bring up the Edit Description dialog edit actions 224 Teiid Designer UI Reference Properties PRODUCTDATA table contains various stock attribute values including basic name primary business type etc Primary key ks PK_PD_INSTR_ID Copy Select All A Find Bf Edit Ek Clear Input Methods BaseTable Products PRODUC Figure C 19 Description View Context Menu Edit Description for PRODUCTDATA PRODUCTDATA table contains various stock attribute values including basic name primary business type etc Primary key ks PK_PD INSTR_ID Cancel Figure C 20 Edit Description Dialog 225 JBoss Enterprise Data Ser
51. conditions are met that will halt the document instance being generated by the Telid Designer Server This fragment of the document model is called the recursive fragment The mapping transformation for this fragment is no different from the first except that you can access the first cycle s mapping class attributes plus you have the opportunity to specify the conditions that will halt the recursion You can recognize a mapping class located at the second recursive document fragment by the looping arrow button in the top left hand corner of the diagram object as shown below When you model a virtual document based on an XML Schema model containing recursion you can choose whether to treat the nested fragments as recursive You should only use recursion when the data access pattern from your data source s is also recursive in other words when the same query transformation should be executed over and over to generate and map the nested document s data content By default the Teiid Designer does not mark the recursive fragments in document models to execute recursively in the Telid Designer Server To take advantage of this behavior you must open the mark the transformation query as recursive and specify the recursion limit properties 6 2 4 1 The Recursion Editor 140 Chapter 6 Creating and Editing Model Objects The Recursion Editor lets you enable and limit recursion The Recursion Editor button only displays on mapping classes w
52. containing connection info After creating your new data source it should now be shown in the Data Sources folder of the corresponding T elid server 9 3 2 Execute VDB from Model Explorer If you have a Telid instance defined and connected in your Telid view you can Step 1 Right click a VDB in your Model Explorer select Modeling gt Execute VDB action This action will insure your selected VDB is deployed to Telid create a Telid Connection Profile specific for that VDB open the Database Development perspective and create a connection to your VDB 193 JBoss Enterprise Data Services 5 Teiid Designer User Guide v PartsProject gt G amp data gt gt readme Ce Parts5 ig Partss GB Partsvi p Og Sample Figure 9 11 Execute VDB Action Modeling Open Open With Aj Execute VDB Generate BossWS CXF War Step 2 Select your new Teiid connection profile and right click select Open SQL Scrapbook enter your designer SQL i e SELECT FROM T ableXXXX select all text and right click select Execute Selected Text O23 gt Q Parts vdb Connection p rofile e Teiid 7 1 SELECT FROM PartsSourceA Parts Figure 9 12 SQL Scrapbook Editor Parts Teiid Connecti Database lS Status Connected Auto Con Step 3 Results of query should be displayed in the SQL Results view on the Result1 tab SOL Results 3 Type query expression here Status Operation Date Connection Profile
53. editors C 3 1 1 Diagram Editor The Diagram Editor provides a graphical view of the a set of model components and their relationships Several types of diagrams are available depending on model type They include 1 Package Diagram Custom Diagram 4 Transformation Diagram Be Mapping Diagram a Mapping Transformation Diagram You can customize various diagram visual properties via Diagram Preferences Each diagram provides actions via the Main toolbar diagram toolbar and selection based context menus These actions will be discussed below in detail for each diagram type When a Diagram Editor is in focus a set of common diagram actions is added to the application s main toolbar p 100 v O A a 2s Figure C 36 Main Toolbar Diagram Actions r The actions include Zoomin se JBoss Enterprise Data Services 5 Telid Designer User Guide Zoom to Level P Zoom Out A Increase Font Size Decrease Font Size Perform Diagram Layout C 3 1 1 1 Package Diagram The Package Diagram provides a graphical view of the contents of a model container be it the model itself a relational catalog or schema Ca PartsOraclell xmi 83 g E SUPPLIER_ID string 10 El PART_ID string 4 A QUANTITY bigdecimal FK_SPLIER_PRTS SPLY SHIPPER ID bigdecimal K_SPLIER_PRTS_PRTS E FK_SPLIER PRTS_ SPLY F FK_SPLIER PRTS PRTS F PK_SUPPLIER_PARTS esse EY PART_ID string 4 SUPPLIER ID
54. existing connection profile the user will be queried for each missing password Missing Password Required Preview data requires password for model gt gt Products xmi Referenced connection profile gt gt AllProducts Cancel Figure 9 4 Missing Password 188 Chapter 9 Testing Your Models Testing Your Transformations When editing transformation SQL in the Transformation Editor a special SQL Results data action is provided in the editor tool bar Ye You can change your transformation SQL re validate and preview your the data for your modified SQL The following sections provide steps for previewing your data Note that all steps assume that all source models referenced by your models either directly or through dependencies are bound to connector bindings 9 2 1 Preview Relational Table or View To preview a relational table relational view or staging table it there Step 2 Right click select the Preview Data action 3 You can also select the same action in 9 2 2 Preview Relational Table With Access Pattern To preview a relational table or view with access pattern that contains an access pattern The table or view can be in a view model as well as a source model Step 2 Right click select the Preview Data action You can also select the same action in Step 3 Acolumn input dialog is presented Select each access pattern and enter a value for each required column Note that if data entered does no
55. i A Wi 2 Products A T rA ns Figure C 53 Change Translator or Data Source Actio If you have a default T eiid server instance defined and connected the translator and JNDI table cells will contain drop down lists of available translator and JNDI names available on that server C 3 2 1 Editing Data Roles Teiid Designer provides a means to create edit and manage data roles specific to a VDB Once deployed within a Teiid server with the security option turned on by default any query run against this VDB via a Teiid JDBC connection will adhere to the data access permissions defined by the VDB s data roles The VDB Editor contains a VDB Data Roles section consisting of a List of current data roles and New Edit and Remove action buttons Hee VDB Description Data Role Description NoAccountHoldingsAccess Client cannot access customer account holdings financial product info VirtualOnhy Client users can onhy access virtual layer Access requests to physical sources will be denied Figure C 54 VDB Data Roles Panel Clicking New or Edit will launch the New VDB Data Role editor dialog Specify a unique data role name add a optional description and modify the individual model element CRUD values by check or unchecking entries in the models section 252 Teiid Designer UI Reference New VDB Data Role New VDB Data Role Select Anish to save data role Name Invento ry Des
56. includes a Java API org telid adminapi that enables developers to connect to and configure an EDS Service at runtime from within other applications rm 15 JBoss Enterprise Data Services 5 Telid Designer User Guide Chapter 2 Introduction The Telid Designer User s Guide provides detailed descriptions of Teiid Designer features and functionality 2 1 What is Telid Designer Telid Designer is an Eclipse based graphical modeling tool for modeling analyzing integrating and testing multiple data sources to produce Relational XML and Web Service Views that expose your business data 2 2 Why Use Telid Designer Telid Designer is a visual tool that enables rapid model driven definition integration and testing of data services without programming With Telid Designer not only do you map from data sources to target formats using a visual tool but you can also resolve semantic differences create virtual data structures at a physical or logical level use declarative interfaces to integrate aggregate and transform the data on its way from source to a target format which is compatible and optimized for consumption by your applications This allows you to abstract the structure of the information you expose to and use in your applications from the underlying physical data structures With Telid Designer data services are defined quickly the resulting artifacts are easy to maintain and reuse and all the valuable work and relate
57. object in the appropriate specialized editor such as the Choice Editor or Recursion Editor Add Bookmark This command adds a bookmark in the active file on the line where the cursor is currently displayed Add Task This command adds a task in the active file on the line where the cursor is currently displayed C 4 3 Refactor Menu The Refactor menu provides T eiid Designer specific actions for file level changes to the models Figure C 67 Refactor Menu The Refactor menu contains the following actions Undo Undo the last refactor command Redo Redo the last undone refactor command Move Move a model from one container folder or project to another Rename Rename a model C 4 4 Navigate Menu Telid Designer currently does not contribute actions to the Navigate menu See Eclipse documentation for details Go To Open Spring Bean Shift Alt B GS Open Seam Component Shiftt Ctrl z Show In Shitt Alt w gt dD Back Alt Left gt Figure C 68 Navigate Menu C 4 5 Search Menu 262 Teiid Designer UI Reference The Search menu presents several specific search options A Search Ctrl H el File Ep Remote Pointcut Matches p Beans Text gt Teiid Designer gt Figure C 69 Search Menu Telid Designer contributes a sub menu i e Telid Designer gt to the main search menu as shown above Text l Teiid Designer Transformations gt SF as Metadata And
58. string 10 E PART _NAME string 255 E SUPPLIER_NAME string 30 PK SUPPLIER PK_PARTS PART_COLOR string 30 Ej SUPPLIER_STATUS bigdecimal iP E PART_WEIGHT string 255 Fj SUPPLIER _CITY string 30 SSS SST EJ SUPPLIER STATE string 2 P PK_PARTS _WJTH_ FK SPUER STATS F FK_SPLIER_STATS g 2 F PK_SUPPLIER STATUS ID bigdecimal PK STATUS E STATUS_NAME string 30 _ P PK_STATUS EY SHIPPER_ID bigdecimal l E SHIPPER_NAME string 30 F PK_SHIP_VIA Ha Package Diagram E Table Editor Figure C 37 Package Diagram Example Package Diagram toolbar actions include E9 Refresh Diagram Re draws diagram 1 Show Parent Diagram Navigates to diagram for parent object if available Preview Data Executes a simple preview query SELECT FROM lf Save Diagram as Image Save the diagram image to file in JPG or BMP format Modify Diagram Printing Preferences Modify page layout information for printing diagrams Includes margins orientation etc Show Hide Page Grid Show current page boundaries as grid in diagram Context menus provide a flexible means to edit model data especially from Package Diagrams Each Package Diagram represents the contents of some container i e Model Category Schema etc So New Child New Sibling and New Association actions are almost always available in addition to standard 240 Edit actions Delete Cut Copy Paste Rena
59. the OMG Below is an example of the partial contents of a model file 21 JBoss Enterprise Data Services 5 Telid Designer User Guide Dt Model files should never be modified by hand While it is possible to do so there is the possibility that you may corrupt the file such that it cannot be used within the T elid Designer system The fundamental models in Telid Designer define the structural and data characteristics of the information contained in data sources These are referred to as source models represented by Cis Teiid Designer uses the information in source models to federate the information in multiple sources so that from a user s viewpoint these all appear to be in a single source Model Internals Entity Metadata Entity Metadata Figure 2 1 Model Internals In addition to source models Teiid Designer provides the ability to define a variety of view models represented by T These can be used to define a layer of abstraction above the physical or source layer so that information can be presented to end users and consuming applications in business terms rather than as it is physically stored Views are mapped to sources using transformations between models These business views can be in a variety of forms Relational Tables and Views XML Web services Functions A third model type logical provides the ability to define models from a logical or structural perspective 2 4 2 How is a Model Defin
60. the Telid Designer in various view toolbars and context menus Previewable objects include Relational table or view including tables involving access patterns Relational procedure Web Service operation XML Document staging table If attempting to preview a relational access pattern a web service operation or a relational procedure with input parameters a dialog will request values for required parameters 2 4 8 Model Object Extensions Telid Designer in conjunction with Teiid provides an extensible framework to define custom properties for model objects over and above what is defined in the metamodel These custom property values are added to your VDB and included in your runtime metadata This additional metadata is available to use in your custom translators for both source query manipulation as well as adjusting your result set data being returned In the 7 6 release Teiid Designer introduces a new Model Extension Definition MED framework that will replace the current EMF based Model Extension metamodel in a later 8 0 release This new MED framework provides the following improvements Eliminate need for separate EMF metamodel Simpler approach including reduction of extendable metamodels and metamodel objects Relational Web Services XML Document User Defined Functions and replacing EMF terminology with basic object types Allows metamodels to be extended by multiple MEDs MEDs are stored in models so no added dependenc
61. the expression select a row in the Attribute Symbol table then click the Function button The Expression Builder Dialog will display allowing you to define any type of Expression Builder SQL Display The current transformation SQL is shown at the bottom of the Reconciler dialog As you add remove SQL symbols and make other changes you can see the SQL display change to reflect those changes When you OK the dialog this SQL will be your new transformation SQL If desired the SQL Display can be hidden by un checking the Show SQL Display checkbox Once you are finished defining the bindings and resolving datatypes click OK to accept the changes JBoss Enterprise Data Services 5 Teiid Designer User Guide The transformation SQL will change to reflect your edits 6 2 1 2 Using the Datatype Resolver offers you a quick way to resolve datatype conflicts between a target attribute and its SQL Symbol The Datatype Resolver Dialog is shown below Resolve Datatype Conflicts Datatype Status One or more of the Bindings has a type conflict Attribute SQL Bindings Virtual Target Attributes SOL Symbol A SHIPPER ID biginteger SHIPPER ID bigdecimal EDIT Virtual Target Attribute EY SHIPPER ID Runtime Type o biginteger o integer xs decimal SQL Symbol SHIPPER_ID Runtime Type bigdecimal Converted Symbol convertiSHIPPER_ID biginteger AS SHIPPER_ID Warning this type conversion may result in lo
62. to complete with default option 105 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Web Service from WSDL File Schema Workspace Location Selection All workspace schema locations are valid Click Next to continue Schema Location Information dy Namespace Source Ale 4 Editor http localhost Share BSM Real Time Data Design Server ReallimeData port OnHand Folder WSDLUmportProject Name without file extension OnHand Cancel Fish Figure 5 54 Namespace Resolution Dialog s Step 7 The last page titled XML Model Generation allows you to change the name of the XML View model if the Generate virtual XML document model is checked Input desired name or use the default name provide Select Finish to complete Create Web Service from WSDL File XML Model Generation Ready to generate the Web service model Generate virtual XML document model Location WSDLimportProject XML Model OnHandWSRe sponses lt Back Vext gt Cancel Finish Figure 5 55 Namespace Resolution Dialog 106 Chapter 5 Importers In order to successfully generate Web Services from WSDL the WSDL must be error free WSDL validation is performed during Step 3 above If errors do exist a error Summary dialog will be displayed shown below and you will not be able to Finish the wizard until the WSDL problems are fixed or you re import and select a valid WSDL file Create Web Service from WSDL F
63. undefined gt ite SOL View 7 gt wzundefined gt Expression Editors Attribute Constant Function Choose Attribute below to replace selected lt undefined gt PartsSourceA SUPPLIER_PARTS El PartsSourceA SUPPLIER_PARTS SUPPLIER_ID El PartsSourceA SUPPLIER_PARTS PART ID El PartsSourceA SUPPLIER PARTS QUANTITY El PartsSourceA SUPPLIER_PARTS SHIPPER_ID gt E PartsSourceB SUPPLIER Figure 6 21 Expression Builder The two tabs at the top Tree View and SQL View show the current contents of the expression you have built To build an expression you must specify the type of expression you want to build and populate it In most cases you will use the Expression Builder to construct a complex expression e Step 3 Click the Function radio button to add a function You can simply add constants and attributes as expressions by themselves using the Attribute or Constant radio buttons however the Expression Editor is most useful for functions 5 Step 4 The Expression Editor displays the Function editor 133 JBoss Enterprise Data Services 5 Teiid Designer User Guide Expression Builder Initial Expression lt undefined gt ig ee SQL View zundefined gt Expression Editors Attribute Constant Function Apply to replace selected lt undefined gt with Function below Category STRING Function Argument Name Value STRINGI lt undefined gt STRING
64. use the T elid Designer Server for data access your applications cannot directly query an Input Set Input Sets only display in the XML transformation diagram to which they belong Input Sets do not display on the as for source classes in other transformations To open the Input Set Editor either double click the input set in the Mapping Transformation Diagram or click the edit button on the Input Set in the diagram see below B lt lt Input Set gt gt Input Set isbn string Figure 6 25 Edit Input Set Button Input Set Editor Input Parameters Mapping Class Bindings 1 isbn string E book isbn string I isbn string EJ type string E title string Fa publisher string E publishDate string E edition string Figure 6 26 Input Set Editor Panel The Input Parameters table contains a list of mapping attributes within the input set and the mapping attributes bound to input set mapping attributes The tree on the right displays the parent mapping classes and the attributes available from each Using the Input Set Editor you can Add a mapping attribute from a parent mapping class to the Input Set In the tree on the right select the symbol for which you want to create an attribute and click New The item displays in the Input Parameters and Mapping Class Bindings table Delete a mapping attribute from the Input Set Click the row in the Input Parameters and Mapping Class Bindings t
65. your flat file data sources and create the metamodels required to query your data in minutes Using the steps below you will define your flat file data source configure your parsing parameters for the flat file generate a source model containing the standard T eiid flat file procedure and create view tables containing the SQL defining the column data in your flat file Telid Supports Flat Files as data sources Telid Designer provides an 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 The results of the importer will include a source model containing the getT extFiles procedures Supported by T eiid The importer will also create a new view model containing a view table for your selected flat file source file Within the view table will be generated SQL transformation containing the getT extFiles procedure from your source model as well as the column definitions and parameters required for the Telid TEXT T ABLE function used to query the data file You can also choose to update an existing view model instead of creating a new view model The TEXTT ABLE function as defined in the Teiid documentation processes character input to produce tabular output It supports both fixed and delimited file format parsing The function itself defines
66. 1 Transformation Editor 123 6 2 1 1 Using the Reconciler 126 6 2 1 2 Using the Datatype Resolver 128 6 2 1 3 Using the Criteria Builder 129 6 2 1 4 Using the Expression Builder 132 6 2 2 Input Set Editor XML 136 6 2 3 Choice Editor XML 138 6 2 3 1 Using the Choice Editor 139 6 2 3 2 Excluding Fragments 6 2 3 3 Editing Choice Criteria 6 2 3 4 Setting Choice Element Order 6 2 3 5 Setting a Default Choice Action 6 2 4 Recursion Editor XML 6 2 4 1 The Recursion Editor 6 2 5 Operation Editor 6 3 Managing Model Object Extensions 6 3 1 Create New MED 6 3 2 Edit MED 6 3 3 Extending Models With MEDs 6 3 4 Setting Extended Property Values Chapter 7 Metadata specific Modeling 0005 7 1 Relational Source Modeling 7 1 1 Source Function 7 1 2 Create Relational Table Wizard 7 2 Relational View Modeling 7 2 1 Create Materialized Views 7 2 2 Create Relational View Table Wizard 7 3 XML Document Modeling 7 3 1 Create XML View Documents from schema 7 4 Web Services Modeling 7 4 1 Create Web Service Action 7 4 2 Web Services War Generation 74 2 1 Generating a JBossWS CXF War 74 2 2 Generating a REST Easy War 74 2 3 Deploying Your Generated WAR File 74 24 Testing Your Generated WAR Files Chapter 8 Editing Models and Projects 0 00 ceca 8 1 Rename A Model 8 2 Move Model 8 3 Save Copy of Model 8 4 Clone Project Chapter 9 Testing Your Models ccc ee
67. 3 Input a valid name for your Web Service model and select the File System button Locate your file system WSDL file in the selection dialog and click OK gt 102 Chapter 5 Importers Create Web Service from WSDL File WSDL File Selection Q Press the Next gt button to continue Web Service Model Name OnHandws Ale System WSDL Ales a fhome blafond Test Designer Folder example files wsdls OnHand wsdl Figure 5 51 WSDL File Selection Dialog s If no WSDL is selected or specified then the importer will only create an empty Web Service model No XML Schema or XML View models will be generated Any referenced files WSDLs or schemas must either be embedded in the WSDL file or exist on your file system Step 4 The next page is titled Namespace Resolution This page identifies successful and errant WSDL namespace resolution The main WSDL document will essentially always be resolved since the workspace file chooser is used to obtain the path Problems will occur when the main WSDL file imports other WSDL files that cannot be resolved If no errors select Next to proceed or Finish if enabled to complete with default options 103 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Web Service from WSDL File Namespace Resolution All namespaces are resolved Select Next to modify the created schemas workspace locations Namespaces de Namespace Path http dladbo y l fhome blafo
68. 3 redhat JBoss Enterprise Data Services 5 Teiid Designer User Guide for Developers Edition 5 3 1 JBoss Enterprise Data Services 5 Telid Designer User Guide for Developers Edition 5 3 1 Red Hat Engineering Content Services Legal Notice Copyright 2013 Red Hat Inc This document is licensed by Red Hat under the Creative Commons Attribution ShareAlike 3 0 Unported License If you distribute this document or a modified version of it you must provide attribution to Red Hat Inc and provide a link to the original If the document is modified all Red Hat trademarks must be removed Red Hat as the licensor of this document waives the right to enforce and agrees not to assert Section 4d of CC BY SA to the fullest extent permitted by applicable law Red Hat Red Hat Enterprise Linux the Shadowman logo JBoss MetaMatrix Fedora the Infinity Logo and RHCE are trademarks of Red Hat Inc registered in the United States and other countries Linux is the registered trademark of Linus Torvalds in the United States and other countries Java is a registered trademark of Oracle and or its affiliates XFS is a trademark of Silicon Graphics International Corp or its subsidiaries in the United States and or other countries MySQL is a registered trademark of MySQL AB in the United States the European Union and other countries Node js is an official trademark of Joyent Red Hat Software Collections is not form
69. 3113 9000075 129 State St Hartford CT Garahana Jarrod Cvjetkovic 9000074 G 66000 Associate 620 430 1782 9000073 132 Stat Neely Petronella Goravica 9000075 G 80000 CEO 230 320 6330 9000076 134 State St L 2 lt Back CURES ene Figure 5 12 Data File Source Selection Page Step 5a Character Delimited Option The primary purpose of this importer is to help you create a view table containing the transformation required to query the user defined data file This page presents a number of options you can use to customize the Generated SQL Statement shown in the bottom panel for the character delimited option Specify header options Column names in header header line number and first data line number Parse selected row changed character delimiter and edit the TEXT TABLE function options See the Telid User s Guide for details on the TEXT TABLE function If columns names are not defined in a file header or if you wish to modify or create custom columns you can use the ADD DELETE UP DOWN to manage the column info in your SQL When finished with this page click Next gt Chapter 5 Importers E Import From Flat File Source x Flat File Delimited Columns Parser Settings Press the Next gt button to continue a Selected Data Ale EmployeeData tet Format Options __ File Contents Preview Column names in header LastName FirstName MiddLeName Empid De Header line
70. 6 19 Constants Panel Select the datatype for this constant from the Type drop down list and enter the value in the Value edit box Function to add a function If you click the Function radio button the Predicate Editor looks like this Attribute Constant Function Choose Function below to replace selected Attribute CONCAT PartsSourceA SUPPLIER_PARTS SHIPPER_ID PartsSourceB SUPPLIER SUPPLIER STATUS Figure 6 20 Functions Click the Edit button to use the Expression Builder to construct a function to use in the predicate of your SQL Criterion For more information about the Expression Builder see 131 JBoss Enterprise Data Services 5 Telid Designer User Guide Step 4 Set a value left side of the predicate and when necessary the right side of the predicate If the right side of the predicate does not require a value of some sort the Criteria Builder will not let you enter one Step 5 Click Apply Step 6 When you have created both a Left Expression and a Right Expression in the Predicate Editor click Apply to add the criterion to the tree view at the top of the dialog box The criteria clause displays in the Criteria tree You can create complex criteria by joining other criteria with this one To join criteria with this one select the criteria in the Criteria tree and click Delete to remove the selected criterion AND to create a new criterion that must also be true OR to create a new criterion th
71. Business and Technical Metadata 2 3 4 1 Technical Metadata 2 3 4 2 Business Metadata 2 3 5 Design Time and Runtime Metadata 2 3 5 1 Design Time Metadata 2 3 5 2 Runtime Metadata 2 3 6 Source and View Metadata 2 3 6 1 Modeling Your Source Metadata 2 3 6 2 Modeling Your View Metadata 2 3 6 3 Modeling Metadata Transformations 2 3 6 3 1 Metadata Transformations 2 3 6 3 2 SQL in Transformations 2 3 6 3 3 Mapping XML Transformations 2 4 It s all in the Modeling 2 4 1 What Are Models 2 4 2 How is a Model Defined 2 4 3 Guiding through the process 2 4 4 Model Classes and Types 2 4 5 Models and VDBs 2 4 6 Model Validation 2 4 7 Testing Your Models 2 4 8 Model Object Extensions 2 4 8 1 Model Extension Definition MED 2 4 8 2 Model Extension Definition Registry MED Registry Chapter SaStart Here c citen satus plies BREA SA es ee ee ee ha wed tae E ee ee eS 3 1 Guide Example oO O CO NN 10 11 11 11 12 13 14 14 16 16 16 16 17 17 17 18 18 18 19 19 19 19 20 20 21 21 21 21 21 22 22 23 23 23 24 24 24 25 26 3 1 1 Model a JDBC Source 26 3 2 Cheat Sheet Example 38 3 2 1 Consume a SOAP Web Service 38 Chapter 4 New Model Wizards ccc eee nee n eee ene ens 51 4 1 Creating New Relational Source Model 51 4 1 1 Generate File Translator Procedures 51 4 1 2 Generate Web Service Translator Procedures 52 4 1 3 Copy From Existing Model 52 4 2 Creating New Relati
72. C 1 NOT NULL WAS1OO0Component NUMERIC 1 NOT NULL AMEXINTComponent NUMERIC 1 NOT NULL PrimaryBusiness WARCHAR 30 GO generated from ProductSymbols lt Back Next gt Cancel Finish Figure 5 2 DDL Import Options 5 Step 4 If NEXT gt is pressed a difference report is presented for viewing or de selecting individual relational entities Press Finish to complete Chapter 5 Importers Import DBL Review Model Updates F Rewiew the changes that will be applied to your model to bring it up to date l 4 with the source metadata Uncheck any changes you do not wish to apply Only In Old Model aio fo Changes 4 fo Only In New Model nEw o v file home blafond Runtime Workspaces test_7 1 0 E ODLTest ProductsSQLS gt ProductData gt E ProductSymbals Selection Details Figure 5 3 Review DDL Updates Dialog 5 2 Import From JDBC Database You can create relational source models from your JDBC source schema data using the steps below Depending the detail provided in the database connection URL information and schema Steps 5 through 7 may not be required a Step 1 In Model Explorer choose the File gt Import action in the toolbar or select a project folder or model in the tree and choose Import e Step 2 Select the import option Metadata Modeling gt JDBC Database gt gt Source Model and click Next gt s Step 3 Select existing or previous connection profile from t
73. Create Relational View Table Create Relational View Table b No columns defined for table This wizard allows creating a complete relational view table including SQL definition z Properties Columns SQL Move Up Delete Column Name Move Down Data Type Length D Figure 7 15 Columns Tab The SQL tab allows editing of the SQL Transformation for the relational view The desired SQL can be entered directly into the text area or a SQL Template may be selected by clicking the Templates button 163 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Relational View Table Create Relational View Table No columns defined for table This wizard allows creating a complete relational view table including SQL definition Properties H Columns Start with a SQL Template or enter the desired SOL Templates Transformation SOL SELECT TABLEA COL1 TABLEA COL TABLEB COL1 FROM TABLEA TABLEB WHERE TABLEA COL1 TABLEB COL1 Figure 7 16 SQL Tab lf the Templates button is selected on the SQL tab the Choose a SQL Template dialog will display as shown below 164 Chapter 7 Metadata specific Modeling Choose a SQL Template Choose a SQL Template Choose a SQL Template from the available options Template Options SELECT Queries PROCEDURES Simple SELECT SELECT with Join Criteria
74. DB Editor You can manage your VDB contents by using the Add or Remove models via the buttons at the right Set individual model visibility via the Visibility checkbox for each model This provides low level data access security by removing specific models and their metadata contents from schema exposed in GUI 251 JBoss Enterprise Data Services 5 Telid Designer User Guide tools In order for a VDB to be fully queryable the Source Name Translator and JNDI Names must have valid values and represent deployed artifacts on your Teiid server If you have Designer runtime plugins installed and have a Telid server running you can select a source model in the VDB Editor and right click select Change Translator or Change JNDI Data Source which will allow you to select any applicable artifacts on your server SECES Other Ales Model Fath Source Name Translator _ Name oe te DataDictionargxsd T EU Customers xmi fAnancialsDemo DataSources Ce EU Customers DDC xmi Li EU Customers VBL xmi 2 FinancialsDemo VirtualBaseLayer 2 fAnancialsDemo EnterpriseDataLayer 2 EU Customers mysql FinancialsDemo EnterpriseDataLayer 7 loopback ISSA Kes metamatrix Ga Products xmi AinancialsDemo DataSources Products l modeshape be Products DDC xmi AnancialsDemo EnterpriseDataLayer npr EA Products VBL xmi ee i oe Ponte OD neste seri fGe serislaRaesanfDnteaen rian sabal soe
75. File Save Location home tejones Runtime Workspaces WARFiles Include RESTEasy Jars in lib Folder of WAR Restore Default Figure 7 28 Generate a REST WAR War File Dialog 176 Chapter 7 Metadata specific Modeling Table 7 3 Field Descriptions Field Name Description Name The name of the generated war file Connection JNDI Name The JNDI connection name to the deployed Teiid source VDB War File Save Location The folder where the generated WAR file should be saved Include REST Easy Jars in lib Folder of WAR If selected the REST Easy jars and there dependent jars will be included in the lib foled of the generated WAR If not selected the jars will not be included This should be de selected in environments where REST Easy is installed in the classpath of the server installation to avoid conflicts Step 6 Click OK to generate the REST war When war generation is complete a confirmation dialog should appear Click OK Figure 7 29 Generation Completed Dialog 7 4 2 3 Deploying Your Generated WAR File Once you have generated your war file you will need to deploy it to your JBoss AS instance There are a few ways to accomplish this From JBDS or JBoss Tools 1 Insure target JBossAS is configured and running 2 Select your WAR file in the Model Explorer view If you didn t generate your war to that location you can copy and paste it there 3 Right click on the WAR file and select Mark as Deplo
76. HORS MIDDLEINIT w El InputSet INPUT isbn v E Books SourceA BOOK AUTHORS FA Books SourceA BOOK_AUTHORS ISBN FA Books SourceA BOOK_AUTHORS AUTH Cancel Figure 6 23 New Blank Function Created You need to set an attribute or constant value for each sub node in the tree to specify the arguments this function needs You can also nest another function in the tree using the Function editor 135 JBoss Enterprise Data Services 5 Teiid Designer User Guide Expression Builder Initial Expression lt cundefined gt DOETE SOL View oe CONCAT Books SourceB AUTHORS FIRSTNAME Books SourceB AUTHORS LASTNAME Books SourceB AUTHORS FIRSTNAME Books SourceB AUTHORS LASTNAME Delete Expression Editors O Attribute Constant Function Value is unchanged Argument Name Value STRINGI Books SourceB AUTHORS FIRSTNAME STRING Books SourceB AUTHORS LASTNAME Figure 6 24 Nested Function Example e Step 8 Click each sub node in the tree and use the editors at the bottom of the dialog box to apply an attribute constant or function value to it a Step 9 When you have added values to all nodes as shown below click OK to add this expression to your query or Cancel to close the dialog box without inserting the expression If the OK button does not enable you have not added a value to all nodes in the tree You can also nest functions within your expressions by selecting an argument and selecting a funct
77. I or CURL JBoss Enterprise Data Services 5 Teiid Designer User Guide Chapter 8 Editing Models and Projects Telid Designer offers three basic model edit actions Rename Move and Save As and one project related action Clone Project These actions are described below 8 1 Rename A Model To rename a model in your workspace e Step 2 Right click select the Refactor gt Rename action 7 r AllCustomerAccounts ar Northwind xmi BE Books New gt BooksProaject noe New Child gt PartsProject er Modeling gt gt t wsDLimportProje Open Open With gt Copy TE Paste Ctrl V Paste Special Ctrl V Delete Refactor Undo Redo g g Import p Export Namespace URI Refresh Move Figure 8 1 Refactor Rename Action In Model Explorer a Step 3 Specify unique model name in the Rename Model File dialog Click OK Rename Model File Enter new name alle ustomers Cancel Figure 8 2 Rename Model File Dialog 180 Chapter 8 Editing Models and Projects Renaming a model that is a dependency to another model will automatically change the model imports for those models If source model CustomerSource is renamed to OldCustomerSource for instance the import statement for the view model CustomerAccounts which imports CustomerSource will be changed to reflect the new name 8 2 Move Model TO move a model in your workspace e Step 2 Right click select the Refactor g
78. L eee 2 Select the Port and Service Mode as desired 3 Select one or more operations under Select the desired WSDL Operations Click Next gt 4 Select the location and name for the Source and View Models to be created Click Next gt 5 For each operation define the request and response XML documents Select the Operation Select the Request tab then select desired element s under schema contents and Add to Element Info Select the Response tab then select desired element s under schema contents and Add to Column Info Select the Wrapper Procedure tab to view the generated procedure SQL 6 When all operation s have been defined click Finish t Create VDB t Test VDE Figure 3 23 Create Models from SOAP Connection The first page of the wizard is shown below 4 4 Chapter 3 Start Here ic Create Relational Model from Web Service Create Relational Model from Web Service Press the Next gt button to continue Connection Profil CountryIntoConn lt NWSDL URL or Location http www oorsprong org websamples countryinto CountryInfoService wso WSDL Validate WSDL Select Port CountryinfoServiceSoap Binding SOAP11 Service Mode PAYLOAD Select the desired WSDL Operation Select All f CapitalCity Deselect All O amp CountnesUsingCurrency O amp CountryCurrency at Selection Details Operation Capi
79. L as well as open desired transformations for editing Metadata Launches the Search dialog User can search for models in the workspace by specifying an Object Type and or a Data Type and or a property value Search results appear in the Search Results view and double clicking a result will open that model in the appropriate editor Find Model Object Launches the Find Model Object dialog which can be used to find an object in the workspace by specifying all or part of its name Selecting the object will open it in the appropriate editor 10 1 Finding Model Objects The Telid Designer provides a name based search capability to quickly locate and display model objects To find a model object Step 1 Open the Find Model Object dialog by either selecting the action on the main T eiid Designer tool bar or select the same action via the main menu s Search gt Find Model Object action Step 2 Begin typing a word or partial word in the Type Object Name field Wild card characters will be honored As you type the objects which match the desired name will be displayed in the Matching Model Objects list If there are more than one objects with the same name the locations or paths of the objects are displayed in the Locations list Step 3 If more than one object exists with the desired name select the one of the locations Step 4 Click OK If editor is not open for the object s model an editor will open The desired object
80. Model Add Gg TestMySOL xmi eMOoOvVe L Figure 3 14 New VDB shag B In the dialog select the target In Folder location where the VDB will be placed Enter a Name for the VDB for example myVDB Finally select the models that will be included in the VDB When finished click Finish The VDB will be created in your Teiid Model Project as shown in the following figure 37 JBoss Enterprise Data Services 5 Telid Designer User Guide Model Explorer x Outline g a x I amp ie v i MyProject gt sources gt views Figure 3 15 Model Explorer 7 Execute VDB Finally the Execute VDB action allows you to execute your VDB and run sample queries against it In the Action Set list double click the action or select it then click Execute selected action In the dialog select the VDB you want to execute then click OK The VDB will be deployed and executed and the perpective will switch to the Database Development perspective You can now run queries against the VDB as show in the following example Ga TestMySQL xmi 8 myVDB vdb B SQL ScrapbookO z Connection profile Type Teiid_7 x Name myVDB localhost Teiid Connection Database myVDB S Status Connected Auto Commit SELECT FROM Accounts ACCOUNT 5 SQL Results 2 Teiid Execution Plan x amp p Y Type query
81. Parts Virtu giii New gt New Child gt Modeling i Create Web Service Generate SOL Relationships Open Transformations Export SQL pen With gt 3 Transformations Import SQL Oe Teid r4 b Copy Figure 7 21 Create Web Service Action e Step 3 In the Create Web Service dialog specify file names for the generated Input Schema file Output Schema file and Web service model Change options as desired Click Finish when done 168 Chapter 7 Metadata specific Modeling Create Web Service Create Web Service Click Anish to generate Location _ _s _ _ _ _ ______________ Specify location for generated modells i e Project or Folder Output Schema Model Parts O Output Generate flat XSD Input Schema Modell __ Generate Parts 0 Input Generate flat XSD Web Service Model _____ Parts 0 WS Generate default SQL for XML mappings Cancel Anish Figure 7 22 Create Web Service Dialog Step 4 When model generation is complete a confirmation dialog should appear Click OK Generation completed successfully Generation completed successfully LET Model PartsVirtual Qutput xsd created New Model PartsVirtual Input xsd created New Model PartsVirtual Output View xmi created New Model PartsVirtual WS xmi created Figure 7 23 Generation Completed Dialog 169 JBoss Enterprise Data Services 5 Telid Designer User Guide 7 4 2 Web Services
82. Server gt Spring gt Team Teiid Designer Diagram Diagram Printing Editor Validation TestNG Validation gt Web gt Web Services gt XML Figure B 1 Preferences Dialog B 1 Telid Designer Preferences General Teiid Designer preferences include Always open editor without prompting To change edit a model it must be opened for editing Checking this box will automatically open the model in an editor if the user attempts to performa change in a model If unchecked the user will be informed that an editor will be opened before the operation is completed Open Designer perspective when model is opened If a model is opened via importing projects the New gt Telid Metadata Model menu and the Teiid Designer perspective is not open you may want to automatically open the perspective and begin working on your model This preference has 3 settings Always open which means always open the perspective without prompting never open which means do not open the Telid Designer perspective or prompt which will always ask you if you wish to open the Teiid Designer perspective Check and update imports during save occasionally editing a model may add or remove objects in one model that reference objects in another model Model Imports keep track of these dependencies within each model A validation error or warning may appear during a build Checking this box will automatically check and update imports during the save process This
83. TE Sa Criteria Builder Initial Expression PartsSourceA SUPPLIER_PARTS SUPPLIER_ID PartsSou aia SOL View PartsSourceA SUPPLIER PARTS SUPPLIER ID PartsSourceB SUPPLIER SUPPLIER_ID Delete AND R NOT Criteria Editors Attribute Constant Function Attribute Constant Function Value is unchanged Value is unchanged vo H PartsSourceA SUPPLIER_PARTS w E PartsSourceA SUPPLIER_PARTS A PartsSourceA SUPPLIER_PARTS SUPPLIER_ID FY PartsSourceA SUPPLIER_PARTS SUPPLIER_ID E PartsSourceA SUPPLIER_PARTS PART_ID FY PartsSourceA SUPPLIER_PARTS PART_ID El PartsSourceA SUPPLIER_PARTS QUANTITY FY PartsSourceA SUPPLIER_PARTS QUANTITY El PartsSourceA SUPPLIER_PARTS SHIPPER_ID FY PartsSourceA SUPPLIER_PARTS SHIPPER_ID wv E PartsSourceB SUPPLIER PartsSourceB SUPPLIER El PartsSourceB SUPPLIER SUPPLIER_ID A PartsSourceB SUPPLIER SUPPLIER_ID FY PartsSourceB SUPPLIER SUPPLIER_NAME Fl PartsSourceB SUPPLIER SUPPLIER_NAME FA PartsSourceB SUPPLIER SUPPLIER_ STATUS FA PartsSourceB SUPPLIER SUPPLIER_STATUS El PartsSourceB SUPPLIER SUPPLIER_CITY E PartsSourceB SUPPLIER SUPPLIER_CITY Figure 6 17 Editing String Property The two tabs at the top Tree View and SQL View show the current contents of the criteria you have built The Criteria Editor at the bottom allows you to build a criteria clause To build a criteria clause you must add information to the left side of the predicate select a comp
84. Table Editor Example C 3 1 2 1 Editing Properties You can edit properties for an object by double clicking a table cell For String properties the table cell will become an in place text editor field Teiid Designer UI Reference 247 JBoss Enterprise Data Services 5 Telid Designer User Guide Base Tables ry Columns F Foreign ation Mame Me CATEGORIES ft CUSTOMERCUSTOMERDEMO CL LUSTOMERDEMOGRAPHICS Cl CUSTOMERS tt EMPLOYEES Ef Figure C 45 Editing String Property If a property is of a boolean true or false type or has multiple selectable values a combo box will be displayed to change the value Supports U true true true true true true true ke Figure C 46 Editing Boolean Value i Searchability Current ALL_EXCEP false ALL_EXCEP false ALL_EXCEP false ARCHABLE _ False SEARCHABLE ALL EXCEPT LIKE ia LIKE ONLY UNSEARCAAGLE SEARCHABLE false SEARCHABLE false Figure C 47 Editing Multi Value Property For multi valued properties where the available values are dynamic i e can change based on available models or data a picker button will be displayed Datatype ink xsslong short stink long xstinkeger string Path http wana oroza long xssinkeger string string long xstinkeger Figure C 48 Editing Multi Value With Picker An example of of this type is the relational column datatype property Editing v
85. The XML Handbook lt TITLE gt lt SUBTITLE gt Updated Edition lt SUBTITLE gt lt PUBLISHER gt 16 lt PUBLISHER gt lt PUBLISH YEAR gt 2000 lt PUBLISH YEAR gt lt EDITION gt lt EDITION gt lt TYPE gt Hardback lt TYPE gt lt AUTHOR_ID gt 49 lt AUTHOR_ID gt lt input gt Figure 7 26 Sample XML Input When using a JSON document your values should match the order of your procedure input parameters as well Here is the input for the above insert procedure i ISBN 1 55615 484 4 TITLE Code Complete SUBTITLE A Practical Handbook of Software Construction PUBLISHER 5 PUBLISH_YEAR 1993 EDITION 1 TYPE Hardback AUTHOR ID 31 J 174 Chapter 7 Metadata specific Modeling Figure 7 27 Sample JSON Input Step 2 Now we need to identify our procedure as REST eligible To do this we add enable REST properties for the procedure s via the Modeling gt Enable context menu option New Child b New Sibling le New Association p Create Web Service 3 Enable REST for Procedures Preview Data for GetCustomerProc Modeling ie lt 2 Undo Disable REST for Procedures Z t Redo xy This will enable two new properties in the property tab for all procedures defined in the model The two required properties are defined in the table below Table 7 2 Required Extended Properties for RESTful Procedures Property Name Description Rest Method The HTTP method that will deter
86. To open Teiid Designer s SQL Reserved Words view select the main menu s Window gt Show View gt Other and select the Telid Designer gt SQL Reserved Words view in the dialog 232 Teiid Designer UI Reference Problems Alter Text any character any String Matching Reserved Words SEARCH SECOND SELECT SENSITIVE SESSION USER SET Figure C 28 System Catalog View You can also display the view by selecting the main menu s Metadata gt Show SQL Reserved Words action as shown below Telid Designer roject oo Run Window Help Update Model fram Source ae Show System Catalog fel Show Datatype Hierarchy Show SOL Reserved Words Convert to Enterprise Datatypes Show Model Statistics Build Model Imports Figure C 29 SQL Reserved Words Action C 2 12 Model Extension Definition Registry View MED Registry View To open Teiid Designer s MED Registry view select the main menu s Window gt Show View gt Other and select the Teiid Designer gt Model Extension Registry view in the dialog The Model Extension Registry view shows the currently registered MEDs Registered MEDs can be Extension Registry view looks like this 233 JBoss Enterprise Data Services 5 Teiid Designer User Guide cP Model Extension Registry 2 Problems Error Log E ag Built In Namespace Prefix Namespace URI Model Class Version Description
87. URI the Model Class you wish to extend Relational Web Service XML Document and Function and a description Note that version number is available but is not currently being used in release 7 6 After entering the basic MED info you can now switch to the Properties tab and begin creating your extended property definitions for specific model objects supported by selected model class 145 JBoss Enterprise Data Services 5 Teiid Designer User Guide 3 mymxd mxd O Properties 7 B a Extended Model Objects Manage the extended model objects that have extension properties BaseTable Extension Properties HE iE Manage extension properties for each extended model object ID Runtime Type Required Modifiable Advanced Masked Indexed Default Value Fixed Value Allowed Values Display Name Descrip copyable boolean w wr true false Copyable Indicat Overview Properties Source Figure 6 35 MED Editor Properties Tab Start by selecting the Add Extended Model Object toolbar button to display the Model Object Name selection dialog Select an object and press OK Add Model Object Name lt Model Ob j ect Name Choose the Model object that will have extension properties BasetTable Column PrimaryKey Foreignkey AccessPattern UniqueConstraint View Column AccessPattern Procedure ProcedureResult Column ProcedureParameter Index Cancel Figure 6 36 Sel
88. User Guide Chapter 3 Start Here We are going to dive right into a couple examples of common tasks in this section These examples will give you a quick introduction to the capabilities that are built into Designer to assist you with common design tasks Specifically we will introduce the following concepts Guides The Guides View is a good starting point for many common modeling tasks The view includes categorized Modeling Actions and also links to Cheat Sheets for common tasks The categorized Modeling Actions simply group together all of the actions that you ll need to accomplish a task You can launch the actions directly from the Guides view rather than hunting through the various Designer menus Cheat Sheets The Cheat Sheets go beyond even the categorized Action Sets and walk you step by step through some common tasks At each step the data entered in the previous step is carried through the process when possible After seeing the Guides and Cheat Sheets in action subsequent chapters will offer detailed explanations of the various concepts and actions 3 1 Guide Example In this section we introduce the Guides View by walking through a simple example For this example we will follow the Model JDBC Source Action Set The actions appear in the following order Define Teiid Model Project Create JDBC connection Create source model for JDBC data source Preview Data Define VDB Execute VDB 0O oF WN FB T
89. _ Enable MTOM Target namespace http teiid org WAR File Save Location Users macuser WARFiles Change i P Cancel OK 170 Chapter 7 Metadata specific Modeling Figure 7 24 Generate a JBossWS CXF War Web Service Dialog 171 JBoss Enterprise Data Services 5 Telid Designer User Guide Table 7 1 Field Descriptions Field Name Name Host Port VDB JNDI Name Security options Target namespace MT OM Message Transmission Optimization Mechanism War File Save Location Description The name of the generated war file The server host name or IP The server port The JNDI connection name to the deployed Telid source VDB None no username password required to connect to the VDB through the generated web service HTTP Basic the specified security realm and role will be used The default realm value is the realm that comes out of the box with Telid telid security The role needs to be defined in the appropriate security mechanism In the case of T eiid use the telid security roles properties file When using HTT PBasic a local T eiid connection using the PassthroughAuthentication property is required See the Telid user s manual for details on PassthroughAuthentication WS Security a password callback class will be generated for you which will validate that the username password values you specified in the war generator dialog are passed in This is meant to be a testin
90. a Select XML Import Mode XML file on local fle system O XML file via remote URL Cancel Figure 5 20 XML Import File Options Page Step 4 Select existing or previous connection profile from the drop down selector or press New button to launch the New Connection Profile dialog See Eclipe Data Tools documentation or Edit to modify change an existing connection profile prior to selection After selecting a Connection Profile the XML data file from the connection profile will be displayed in the Available Data Files panel Check the data file you wish to process The data from this file along with your custom import options will be used to construct a view table containing the required SQL transformation for retrieving your data and returning a result set Lastly enter the unique source model name in the Source Model Definition section at the bottom of the page or select an existing source model using the browse button Note the Model Status section which will indicate the validity of the model name whether the model exists or not and whether the model already contains the getT extFiles procedure In this case the source model nor the procedure will be generated When finished with this page click Next gt Chapter 5 Importers iS Import From XML Hle Source XML Data File Source Selection Press the Next gt button to continue Data File Source Parts XML File New Edit XML Data File Fold
91. a string string string i string textarea Searchable Updatable True True True True True True True True True True True True False False False 3 True Tue 3 True True 3 True Tue True Tue True Cancel Anish a Step 5 On the Target Model Selection page specify the target folder location for your generated model a unique model name and select desired import options Press Next gt or Finish if enabled 81 JBoss Enterprise Data Services 5 Telid Designer User Guide Create Relational Model from SalesForce Data Model x ee Target Model Selection Press the Next gt button to continue or the Anish button to finish Select Target Relational Model Model Name BillingSourceModel Browse Browse Location Salesfo rcelmportlest Select Import Options Model audit fields Selecting this option will cause the importer to model the Audit Relds for each SalesForce object Created By Created Date Last Modified By Last Modified Date System Modification Timestamp _ Do not gather Cardinalities Selecting this option will stop the importer from calculating and setting the cardinalities metadata For large salesforce applications this can become a long running operation Gather Column Distinct Value Count Selecting this option will cause the importer to calculate and set the distinct value count metadate Thi
92. a Step 5 Select the model builder labeled Copy from existing model of the same model class and click Next gt The Copy Existing Model dialog will be displayed a Step 6 Select an existing relational model from the workspace using the browse button Note An existing model will be pre selected fa relational model in the workspace is selected in Step 7 Check the Copy all descriptions option if desired Click Finish 4 2 Creating New Relational View Model Create New Relational View Model To create a new empty relational view model Step 1 Launch the New Model Wizard Step 2 Specify a unique model name Step 3 Select Relational option from Model Class drop down menu a Step 4 Select View Model from Model Type drop down menu e Step 5 Click Finish You can change the target location i e project or folder by selecting the Browse button and selecting a project or folder within your workspace In addition to creating a new empty relational view model the following builder options are available Copy from existing model of the same model class Chapter 4 New Model Wizards Transform from existing model 4 2 1 Copy From Existing Model This builder option performs a structural copy of the contents of an existing model to a newly defined model You can choose a full copy or select individual model components for copy To create a new relational model by copying contents from another
93. able that you want to delete and click Delete The Teiid Designer removes this row from the table and this mapping attribute from your Input Set Bind and Unbind Input Parameters Once you have created the mapping attributes within the Input Set that you need you can use the Input 137 JBoss Enterprise Data Services 5 Telid Designer User Guide Set Parameters within a mapping class transformation to produce mapping attributes you can map to your XML document 6 2 3 Choice Editor XML Within an XML Document model a choice compositor defines all possible document data structures sometimes called fragments that can appear at that location in an XML instance document When the Telid Designer Server populates an XML instance document at runtime based upon your virtual XML document it will choose the first fragment that matches the criteria you specify within the Choice Editor To view the choice editor right click on the choice node in the mapping diagram s XML Document tree view and select Edit from ne Lola click pop up menu g sequence oe title ode subtitle Figure 6 27 Opening The Choice Editor Choice Editor bookSetMixed choice pa tio Heme Inch Criteria 1 RG hardcoverBook Z E softcoverBook bw z R E E LI 48 audiobook w AudioBooks bookSetMixedDocument Mappingllasses bookSetMixed TYPE IN Books Edit Summar Figure 6 28 The Choice Editor The table on this panel displays fragment optio
94. acter delimited Axed width File Contents Preview LastName FirstName MiddLeName Empid Department AnnualSalary Title HomePhone Mgrid S KisselLmeyer Abbiegale Tikvica 9000059 G 64000 00 MGMT WannaBe 670 270 7947 9000073 Glore Diodie Vojvoda 9000060 G 71000 Associate 480 650 9750 9000073 127 State St Dawson Pinckney Ostoja 9000061 G 71000 Associate 110 400 3600 9000073 135 State St Waldrip Trixie Curic 9000062 G 57000 Newb1e 820 210 7045 9000073 136 State St ALb Kitchen Zilpha Buic 9000063 G 60000 MGMT WannaBe 660 390 3785 9000073 138 State St Wakeman Gerard Vlahovic 9000064 G 78000 Newbie 700 190 5880 9000073 1130 State St Ratferty Dock Korda 9000065 G 70000 Newbie 400 190 6192 9000073 128 State St Sacr Kersavage Zelda Mjesecevic 9000066 G 56000 MGMT WannaBe 802 930 1482 9000073 137 5 Zummer Gerda M lan 9000067 G 69000 Newb1 e 920 100 9701 9000073 131 State St Bango Davies Allwyne Rad c 9000068 G 61000 Associate 470 820 6096 9000073 126 State St Deanford Abe Skrabalo 9000069 G 67000 Associate 907 660 8233 9000073 124 State St Garcia Orsal Ucovic 9000070 ML 79000 CFO 480 490 7710 9000075 150 State St Phoen1 Fook Orson Bendevis 9000071 G 71000 Newbie 350 260 8654 9000073 133 State St Bost Rainier Adelaid Marinovic 9000072 G 67000 Newbie 316 550 3499 9000073 125 State St Nealon General 9000073 G 77000 COO 203 420
95. al documents fram the schema Build only first level of each document for large schema where many portions will not be used Mapping Options Build Mapping Classes Mapping Class Locations Locate at XML Schema iteration nodes max occurs gt 1 for schema compliant data access Locate at XML Schema complex types for semantic use only Mapping Class Column Datatypes Use XML types from the document Use String mapping type disables automatic output conversion to closest built in XSD type o lt Back Cancel Finish Figure 7 20 Build XML Documents From XML Schema Dialog 7 4 Web Services Modeling 7 4 1 Create Web Service Action This method is recommended for experienced users for consistent and rapid deployment of Web services designed to query relational sources It provides detailed control of all Web service interfaces operations and required transformations from XML Views 167 JBoss Enterprise Data Services 5 Teiid Designer User Guide To create a Web service model from relational models or objects a Step 1 Select any combination of relational models tables and or procedures in the Section C 2 1 Model Explorer View tree It is recommended that the user selects single source models which enables auto naming of input output schema and Web service models in Step 3 Step 2 Right click select Modeling gt Create Web Service action gt Ca PartsSourceB xmi gt ve
96. ally related to or endorsed by the official Joyent Node js open source or commercial project The OpenStack Word Mark and OpenStack Logo are either registered trademarks service marks or trademarks service marks of the OpenStack Foundation in the United States and other countries and are used with the OpenStack Foundation s permission We are not affiliated with endorsed or sponsored by the OpenStack Foundation or the OpenStack community All other trademarks are the property of their respective owners Abstract The Telid Designer User s Guide provides detailed descriptions of Telid Designer features and functionality Table of Contents POTAGE 225 Cried touts 2 Aina eae eat eee eee eee ake a a eee ee eRe bas ekdosab bes 1 Document Conventions 1 1 Typographic Conventions 1 2 Pull quote Conventions 1 3 Notes and Warnings 2 Getting Help and Giving Feedback 2 1 Do You Need Help 2 2 Give us Feedback Chapter 1 The Enterprise Data Services Platform 0 0 0 0 ccc cece 1 1 Data Integration 1 2 Enterprise Data Services 1 3 Insurance Use Case 1 4 Enterprise Data Services Overview 1 5 EDS Service 1 6 Design Tools for EDS 1 7 Administration Tools for EDS Chapter 2 INEFOGUCLION xii fae da dd nig wha Rh ne ld nie ed coi dactslict oasis 2 1 What is Telid Designer 2 2 Why Use Telid Designer 2 3 Metadata Overview 2 3 1 What is Metadata 2 3 2 Editing Metadata vs Editing Data 2 3 3 Metadata Models 2 3 4
97. an import type via the drop down menu shown below L Import Metadata From Text File Select Import Type Select the type of text file import desired Import Type EW e a a E EA w Relational Model MML Format Purpose Imp relational soy Relational Tables CSV Format Relational Virtual Tables CSV Format Sample Ale Fc Datatypes CSV Format lt relational model gt Ei lt table name ProductData namelnSource dbo products ProductData Figure 5 29 Import Wizard 84 Chapter 5 Importers These steps are required for each type are defined below Relation Model T ext Import Relational Table Text Import Virtual Table Text Import Datatype Table Text Import 5 6 1 Import Relational Model XML Format A To create relational tables from imported XML text file metadata Perform Steps 1 through 3 above and select the Relational Model XML Format import type then click Next gt 85 86 JBoss Enterprise Data Services 5 Telid Designer User Guide Import Metadata From Text File x Select Import Type Select the type of text file import desired Import Type Relational Model XML Format Purpose Imports relational tables views procedures and indexes from an XML Ale into a relational source model Sample Ale Format lt relational model gt lt table name ProductData namelnSource dbo products ProductData description Basic stocks or bond cardinality 100 materialized
98. and their contents within Designer G Northwind xmi 3 Discount float J EmployeelD integer LastName string 20 FirstName string 10 Title string 30 TitleOfCourtesy string 25 BirthDate timestamp HireDate timestamp Address string 60 City string 15 Region string 15 PostalCode string 10 EY Country string 15 A HomePhone string 24 J SupplieriD integer CompanyName string 40 ContactName string 30 ContactTitle string 30 Address string 60 City string 15 Region string 15 PostalCode string 10 Country string 15 Phone string 24 Fax string 24 HomePage string 1073741823 tis Package Diagram EJ Table Editor To show the Telid View click Window gt Show View gt Other to display the Show View dialog Choose 219 JBoss Enterprise Data Services 5 Telid Designer User Guide Teiid Designer gt Telid view and hit OK ag Teiid 32 N A mms 10 111 12 222 12345 A mms 11 11 111 11 31444 Data Sources i VDBs 44 mms localhost 31443 E gt Data Sources 1 BooksDB2 J PartsSourceB 0 PartsSOL2000 VDBs i PartsVDB Figure C 12 Teiid View To create a new Teiid instance either right click select New Teiid Instance action or click the same action button A in the toolbar You ll get the New Teiid Instance dialog shown below 220 Teiid Designer UI Reference New Tetid Instance Enter Te
99. andinput output message OnHandOutput Fault names none http dladbO7 Share BSM Real Time Data Design Server RealTimeData p lt Back ext gt Cancel Finish Figure 5 47 Namespace Resolution Dialog Step 6 The next page is titled Schema Workspace Location Selection This page lists all schemas imported by the WSDL along with any dependent schemas referenced within schemas as well as schemas embedded in the WSDL and indicates whether or not they are resolvable All resolved schemas will be created in a separate file and added to the workspace The editor panel allows you to change the default file name of the new schema file s If no errors select Next to proceed or Finish to complete with default option 100 Chapter 5 Importers Create Web Service from WSDL File Schema Workspace Location Selection All workspace schema locations are valid Click Next to continue Schema Location Information dy Namespace Source Ale 4 Editor http localhost Share BSM Real Time Data Design Server ReallimeData port OnHand Folder WSDLUmportProject Name without file extension OnHand Cancel Fish Figure 5 48 Namespace Resolution Dialog s Step 7 The last page titled XML Model Generation allows you to change the name of the XML View model if the Generate virtual XML document model is checked Input desired name or use the default name provide Select Finish to complete Create Web Service from
100. arison operator and add a value to the right side a Step 3 The radio buttons on either side of the Predicate Editor let you choose what type of content to place in that side of your predicate Click the radio button of the type of content you want to place in your criteria You can click e Attribute to add an attribute to the predicate If you click the Attribute radio button the Predicate Editor looks like this Attribute Constant Function Value is unchanged E PartsSourceA SUPPLIER PARTS A PartsSourceA SUPPLIER_PARTS SUPPLIER_ID El PartsSourceA SUPPLIER_PARTS PART ID FA PartsSourceA SUPPLIER_PARTS QUANTITY FA PartsSourceA SUPPLIER PARTS SHIPPER_ID PartsSourceB SUPPLIER FA PartsSourceB SUPPLIER SUPPLIER _ID FA PartsSourceB SUPPLIER SUPPLIER_ NAME El PartsSourceB SUPPLIER SUPPLIER STATUS FA PartsSourceB SUPPLIER SUPPLIER_CITY oO LLP 1001 IED 1100 IED 130 Chapter 6 Creating and Editing Model Objects Figure 6 18 Attribute Panel From the tree select the attribute you want to add to the expression You can select an attribute from any of the source classes in the transformation Constant to add a hard wired constant value to the predicate If you click this radio button the Predicate Editor looks like this Attribute Constant Function Apply to replace selected Attribute with Constant below Type string Walye Figure
101. ass 4 4 1 Copy From Existing Model This builder option performs a structural copy of the contents of an existing model to a newly defined model You can choose a full copy or select individual model components for copy To create a new relational model by copying contents from another XML schema model complete e Step 5 Select the model builder labeled Copy from existing model of the same model class and click Next gt The Copy Existing Model dialog will be displayed Step 6 Select an existing relational model from the workspace using the browse button a Step 7 Check the Copy all descriptions option if desired Click Finish 4 5 Creating Web Service View Model Create Web Service View Model To create a new empty web service view model a Step 1 Launch the New Model Wizard Step 2 Specify a unique model name Step 3 Select Web Service option from Model Class drop down menu e Step 4 Select View Model from Model Type drop down menu Step 5 Click Finish You can change the target location i e project or folder by selecting the Browse button and selecting a project or folder within your workspace In addition to creating a new empty web service view model the following builder options are available a Copy from existing model of the same model class Build from existing WSDL file s or URL 4 5 1 Copy From Existing Model This builder option performs a structural copy of t
102. at can be true instead of the selected criterion NOT to establish negative criterion If you join a criterion to the one you just completed you build the expression the same way using the Expression Editors panel and the Predicate Editor panel You can create complex nested criteria by judicious use of the AND and OR buttons Once you have created the complete criteria you want click OK to add it to your transformation 6 2 1 4 Using the Expression Builder The Transformation Editor s Expression Builder offers you a quick graphical means to build expressions in your transformations This Expression Builder lets you create Attributes by selecting an attribute Constants by selecting the datatype and value Functions from both the standard T elid Designer SQL functions and your enterprise s custom user defined functions If you select a function before you launch the Expression Builder you can use the Expression Builder to edit the selected function otherwise you can create a new function from scratch The functions made available through the expression builder are described in the Data Services Telid Reference Guide To use the Expression Builder Step 1 In the Transformation Editor click the location where you want to insert the function Step 2 Click the Expression Builder button 3 The SQL Expression Builder displays 132 Chapter 6 Creating and Editing Model Objects Expression Builder Initial Expression lt
103. ate relational source models from your DDL using the steps below Step 1 In Model Explorer choose the File gt Import action t in the toolbar or select a project folder or model in the tree and choose Import a Step 2 Select the import option Teiid Designer gt DDL File gt gt Source or View Model and click Next gt o JBoss Enterprise Data Services 5 Telid Designer User Guide Step 3 Select existing DDL from either Choose from file system or Choose from workspace set the Model folder location enter or select valid model name set Model type Source Model or View Model set desired options and click NEXT gt or Finish if enabled Import DOL Provide DDL source F Update relational source model ProductsSQLServer using DDL file home d Ji blafond Runtime Workspaces test 7 1 0 E DDLTest Products50LSerwer ddl i Choose from file system DDL file fhome blafond Runtime Workspaces test w u u u u uaulululuylylyeyeylylylylylyeymelelSlS Sy Choose from workspace Model folder DDLTest Choose Model name ProductsS5SQLS5ervwer Choose Model type Source Model J Create model entities for DDL defined by unsupported DML e g Views DBL file contents CREATE TABLE ProductData ProductiD VARCHAR 10 NOT NULL ProductName VARCHAR 60 ProductType WARCHARI 1S ISSUER VARCHAR 10 EXCHANGE VARCHARI 10 D lComponent NUMERIC 1 NOT NULL SPS00Component NUMERI
104. ater JDBC ingres93 Ingres 9 3 or later JDBC db2 JDBC informix ldap JDBC loopback JDBC metamatrix JDBC modeshape olap JDBC access JDBC excel odbc JDBC sqlserver JDBC mysql5 mysql JDBC netezza JDBC oracle JDBC postgresql salesforce WS WS ws JDBC sybase JDBC teradata JDBC teiid ws ws Supported Data Sources Designer Import Option JDBC Importer File Importer JDBC Importer use DDL importer or perform modeling manually JDBC Importer JDBC Importer JDBC Importer JDBC Importer JDBC Importer use DDL importer or perform modeling manually use DDL importer or perform modeling manually JDBC Importer JDBC Importer use DDL importer or perform modeling manually JDBC Importer JDBC Importer JDBC Importer JDBC Importer JDBC Importer JDBC Importer JDBC Importer SalesForce Importer File Source XML Importer WSDL Importer JDBC Importer JDBC Importer JDBC Importer WSDL or URL Importer File Source XML Importer 203 JBoss Enterprise Data Services 5 Telid Designer User Guide User Preferences The Telid Designer provides options or preferences which enable customization of various modeling and UI behaviors Preferences can be accessed via the Edit gt Preferences action on the Main toolbar Preferences P JBoss lools a ModeShape gt Plug in Development Project Archives gt Remote Systems gt Run Debug gt
105. available If a Model Editor is open then the root of the displayed tree will be the model for the editor that is currently in focus in Teiid Designer tab on top C 2 2 1 Outline Tree View This tree view provides the same basic editing and navigation behavior as the Model Explorer One additional capability is the drag and drop feature which provides re ordering and re parenting of objects in a model iat Model Explorer BE Outline 3 gt a tet PartsVirtual xmi gt import declarations 4 fa Package Diagram gt El Supplierinfo partsByColor Figure C 10 Outline View 218 C 2 2 2 Outline Thumbnail View The Outline View also offers you a way to view a thumbnail sketch of your diagram regardless of its Teiid Designer UI Reference size To view this diagram thumbnail from the Outline panel click the Diagram Overview button at the top of the view The diagram overview displays in the Outline View tet Model Explorer 5 Outline 53 a Figure C 11 Outline View The view contains a thumbnail of your entire diagram The shaded portion represents the portion visible in the Diagram Editor view To move to a specific portion of your diagram click the shaded area and drag to the position you want displayed in the Diagram Editor view E Model Explorer Outline 5 C 2 3 Teiid View The Teiid View provides a means to display and manage Teiid server instances
106. blems View Build Working Set Validates the contents of the selected working set Any errors or warnings will appear in the Problems View Clean Launches the Clean dialog Build Automatically Sets the Build Automatically flag on or off When on a check mark appears to the left of this menu item When this is turned on validation of changes is done automatically each time a Save is done Clone Project Launches the Clone Project dialog Build Project Imports Reconciles all model import dependencies for models contained within the selected project Build All Imports Reconciles all model import dependencies for models contained within the workspace Build Packages TBD Validate Model Transformations Re validates all transformations for the selected view model Properties Displays the operating system s file properties dialog for the selected file C 4 7 Metadata Menu The Metadata menu provides Telid Designer specific actions Teiid Designer UI Reference daco Run Window Help ate Show System Catalog fs Show Datatype Hierarchy __ Figure C 72 Metadata Menu The Metadata menu contains the following actions Update Model from Source If the selected model is a relational source model that was originally created via JDBC Import then the model will be updated based on changes in the database schema Re resolve References Analyzes references within models to other model components Convert to Enterpr
107. cal metadata includes things such as datatype the name of the data in the enterprise information system and other information that describes the way the native enterprise information system identifies the meta object Using our example of an address book database the following represent the technical metadata we know about the ZIP code column Named Z IPCode Nine characters long A string Located in the StreetAddress table Uses SQL Query Language These bits of information describe the data and information required to access and process the data in the enterprise information system 2 3 4 2 Business Metadata Business metadata represents additional information about a piece of data not necessarily related to its physical storage in the enterprise information system or data access requirements It can also represent descriptions business rules and other additional information about a piece of data Continuing with our example of the ZIP Code column in the address book database the following represents business metadata we may know about the ZIP code The first five characters represent the five ZIP code numbers the final four represent the ZIP Plus Four digits if available or OOOO if not The application used to populate this field in the database strictly enforces the integrity of the data format Although the first might seem technical it does not directly relate to the physical storage of the data It represents a business ru
108. can now select the sibling object you would like to add 119 JBoss Enterprise Data Services 5 Telid Designer User Guide New Sibling Al Access Pattern New Association gt eee gt F Foreign Key lt 2 Undo Delete multiple objects Si cated ao W Unique Constraint Figure 6 7 New Sibling Action In Diagram Step 3 The new model object displays on the diagram and is highlighted for renaming Step 1 Select the row for the object to which you want to add a sibling For example you can add a column sibling to a column Step 2 Right click on a row From the pop up menu select New Sibling You can now select the Sibling object you would like to add A PartsDB2 mi 24 k tay PartsViews xmi Location Name Name In Source Syste mo c ardinality Supports Up i Materialized Lo gic PARTS false New Child gt SHIP VI SHIP VI me Sis S New Sibling gt Base Table 3 sila 3 Saami New Association gt amp Catalog SUPPLIER SUPPLIER Modeling gt HI index SUPPLIER_PARTS SUPPLIER lt Undo Delete multiple objects L Logical Relationship E Procedure Schema of Cut Ctrl X E view Copy Ctrl C 4a Custom Diagram ble Paste Figure 6 8 New Sibling Action In Table Editor Step 3 The selected tab in the Table Editor changes to the tab for the child object type the new model object row is displayed and the row s nam
109. ces 1 4 Enterprise Data Services Overview A complete Enterprise Data Services EDS solution consists of the following 12 EDS Service The EDS Service is positioned between business applications and one or more data sources It coordinates integration of these data sources so they can be accessed by the business applications at runtime Design Tools Various design tools are available to assist users in setting up an EDS Service for a particular data integration solution Administration Tools Various management tools are available for administrators to configure and monitor a deployed EDS Service Chapter 1 The Enterprise Data Services Platform Business Applications JBoss Enterprise SOA Platform Enterprise Data Services SA Access Layer Administration Design Tools Tools Te d Designer ms F Virtual Database Adminshell Connector Development Query Engine Kit Admin Console t Connector JBoss Gi y e Framework Operations Network rx Data Sources Figure 1 1 Enterprise Data Services Overview 1 5 EDS Service The EDS Service is positioned between business applications and one or more data sources and coordinates the integration of those data sources for access by the business applications at runtime An EDS Service manages the following components Virtual Database A virtual database VDB provides a unified view of data r
110. context menu Cut Copy Paste Clone Delete Rename Insert Rows Paste information from your clipboard into the table Print your tables When a Table Editor is in focus the Insert Table Rows action is added to the application s main toolbar A few Table Editor actions are contributed to the right click menu for selected table rows These actions described and shown below include Table Paste Paste common spreadsheet data like Microsoft Excel to set object properties Table Editor Preferences Change table editor preferences including customizing visible properties Insert Rows Create multiple new sibling objects amp Refresh Table Refreshes the contents of the current Table Editor to insure it is in sync with the model 246 Name Name In Source Syste PA Fe eer New Child New Sibling New Association Modeling F F Fi Fa tT mm im H Un g E Reda of Cut Ctrl X Copy Ctrl C Diagr E Table Paste Clone z 9 h Copy Name ol Delete E part Rename 2 PS dled idled Open idled li dler ce dodel E Model F Model F Model F Hodel F dled dled w Add to Metadata Faworites if t Open in Relationship Navigator Run As Debug As Profile As Validate a Mark as Deployable c ce WW WW e Ee Team Compare With Replace With ART Guynor Table Editor Preferences Fl Insert Rows 1 8 KE 6 Refresh Table 5 L1 JPEG image Tue OF Sep 201 Figure C 44
111. could add a test query to your VDB connection s ds xml file This will insure you get a valid connection after redeploying your VDB The syntax for the test query is as follows lt check valid connection sql gt some arbitrary sql lt check valid connection sql gt Step 3 3 If you have not already done so you will need to create a data source for your VDB This can be done in the Telid View of Designer Right click on your deployed VDB and select Create Data Source The Generate REST WAR dialog will ask you for the JNDI name for your created source so that it can connect to your VDB Step 4 Right click on the VDB containing your virtual model s with REST eligible procedures and select the Modeling gt Generate REST Easy War action If there are no procedures that are REST eligible the Generate REST Easy War option will not be enabled i Ls MYSYL GUUKS XITII BOURSRESIVVEDS sh wy New P gt ksToo xmi _IBooksR Webs uM Modeling 2 A Deploy m TA Em open OK Execute VDB M Open With gt Generate JBossWS CXF War Generate RESTEasy War lis Re J Maras Step 5 Fill in missing properties in the REST War Generation Wizard shown below Create REST WAR File Create a REST WAR file to deploy as a REST Web Service Enter the required information then click OK to create the WAR file REST WAR Creation Informatio Context Name BooksREST VDB JNDI Name REPLACE WITH VDB_JNDI NAME REST WAR
112. create an ODA Web Service connection profile using the WSDL URL and end point information v Launch Create SOAP Connection Profle 4 Wizard 1 Specify unique name and optional w description and click Next gt 2 Enter a WSDL URL or Browse to select a local WSDL 3 Click Test Connection to verify connectivity 4 Click Finish Create Models From SOAP Connection t Create VDE Test VDB Figure 3 20 Create SOAP Connection Profile The first page of the wizard is shown below 41 42 JBoss Enterprise Data Services 5 Teiid Designer User Guide New Connection i Profile all lez New Connection Profile Create a SOAP Web Service connection profile Connection Profile Types 2 filter text Web Services Data Source SOAP as CountryInfoConn Description optional Cd pect Next gt cancel Finish Figure 3 21 Create SOAP Connection Profile The Web Services Data Source SOAP profile type will be selected Enter CountryInfoConn for the profile name then click Next The next page of the wizard is shown below Chapter 3 Start Here G New connection profile R Web Service Connection Properties 2 Click Next or Finish Properties Profile Name CountryInfoConn Connection URL or File Path http www oorsprong org websamples countryinfo CountryInfoService wso 7WSDL workspace Ele system URL Description The URL defined for this connection profile provides t
113. cription Allow usage of temporary tables Apply this role to All Users Mapped Role Names Preeti rrr rrr eee eee ee eee eee ee eee Ad Add Remove Models Model Create Read Update Delete Execute Alter WF ProductsSOL xmi E l gt amp ProductData gO A A CO A A gt H ProductSymbols oO aw a oO g o System Tables Access Allow this role to access SYSADMIN model inh Figure C 55 VDB Data Roles Tab C 3 2 2 Editing Translator Overrides Telid Designer provides a means to create edit and manage translator override properties specific to a VDB via the Translator Overrides tab A translator override is a set of non default properties targeted for a specific source model s data source So each translator override requires a target translator name like oracle db2 mysql etc and a set of non default key value property sets The VDB Editor contains a Translator Overrides section consisting of a List of current translator 253 JBoss Enterprise Data Services 5 Teiid Designer User Guide overrides on the left a properties editor panel on the right and Add and Remove action buttons on the lower part of the panel Sees Other Ales Model F Source Name Translator INDI Name Description F Products xmi fUpdateVGTest Products Products A Updates xmi UpdatevGTest Mi cathae Synchronize A Data Roles VOB Description Stelios ene Overridden Translators ae Gi
114. ctor Dialog PartsTest gt a Northwind xmi b gt Ca Parts Supplier xmi Q PartsTestVDB vdb gt EB PartsViewModel xmi gt G ProductsOracle xmi New Model Name MaterializedParts Click OK to create the relational model Properties Cancel s Step 3 Click OK to create relational tables corresponding to your selected view tables and 160 Chapter 7 Metadata specific Modeling automatically set the Materialized property to TRUE and the Materialized Table reference value to your newly generated table When finished your view tables will be configured with their new materialized properties and the corresponding relational tables will be shown in their package diagram GA PartsViewModel xmi Ca MaterializedParts xmi 23 E fA PART _ID string 50 EY SHIPPER_ID bigdecimal E PART_NAME string 255 SHIPPER_NAME string 30 Ej PART_COLOR string 30 EY PART WEIGHT string 255 E3 F ta Package Diagram E Table Editor Figure 7 12 Materialized Table Properties 7 2 2 Create Relational View Table Wizard In Teiid Designer 7 7 a new action New Child gt Base Table was added to aid in creating relational view tables complete with its target columns and SQL transformation This action replaces the original New Child gt Base Table action which only created the empty table s J ME 7 O Index J Sta J sta n a Open With Jen To tes ji ta Custom Diagram Pa
115. d metadata are saved for later reference You can use Telid Designer to integrate multiple sources and access them using the common data access standards Web Services SOAP XML JDBC SQL ODBC SQL Telid Designer is an integral part of the Telid Designer enterprise class system for providing data services for service oriented architectures 2 3 Metadata Overview 2 3 1 What is Metadata Metadata is data about data A piece of metadata called a meta object in the Telid Designer contains information about a specific information structure irrespective of whatever individual data fields that may comprise that structure Let s use the example of a very basic database an address book Within your address book you certainly have a field or column for the ZIP code or postal code number Assuming that the address book services addresses within the United States you can surmise the following about the column or field for the ZIP code Named Z IPCode Numeric 16 Chapter 2 Introduction A string Nine characters long Located in the StreetAddress table Comprised of two parts The first five digits represent the five ZIP code numbers the final four represent the ZIP Plus Four digits if available or OOOO if not Formatted only in integer numeric characters Errors will result if formatted as 631410 00 or 6314q0000 This definition represents metadata about the ZIP code data in the address book database It abstracts info
116. d steps for each of these options is described below as well as a description of how the wizard handles WSDL errors 5 8 1 Import WSDL From Workspace Location You can create a Web Service model by selecting a WSDL file from your workspace Step 1 Choose the File Import choose the File gt Import action t in the toolbar or select a project folder or model in the tree and choose Import Step 2 Select the import option Telid Designer gt WSDL File or URL gt gt Web Service Model option shown below and click Next gt Step 3 Input a valid name for your Web Service model and select the Workspace button Locate your workspace WSDL file in the selection dialog and click OK gt Click Next gt to continue 97 98 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Web Service from WSDL File WSDL File Selection Press the Next gt button to continue Web Service Model Name lOnHandws Workspace Ale System UR Ider Test In JBDS JBDS_ H45 workspace WSDLIimportProject OnHand wsdl z Back o OnHand wsdl Cancel Figure 5 45 WSDL File Workspace Selection Dialog Chapter 5 Importers s If no WSDL is selected or specified then the importer will only create an empty Web Service model No XML Schema or XML View models will be generated s Any referenced files WSDLs or schemas must either be embedded in the WSDL file or exist on your file system T Step 4 The next page is
117. d then the importer will only create an empty Web Service model No XML Schema or XML View models will be generated Any referenced files WSDLs or schemas must either be embedded in the WSDL file or exist on your file system s Step 4 The next page is titled Namespace Resolution This page identifies successful and errant WSDL namespace resolution The main WSDL document will essentially always be resolved since the workspace file chooser is used to obtain the path Problems will occur when the main WSDL file imports other WSDL files that cannot be resolved If no errors select Next to proceed or Finish if enabled to complete with default options Chapter 5 Importers Create Web Service from WSDL File WSDL File Selection Press the Next gt button to continue Web Service Model Name TerraServicews Workspace Ale System WSDL Ales http terraservice net terraservice2 asmx wsdl lt Back Next Cancel Anish Figure 5 58 Namespace Resolution Dialog e Step 5 The next page WSDL Operations Selection allows customizing the resulting content of your Web Service model by selecting deselecting various operations and interfaces in the following dialog 109 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Web Service from WSDL File Namespace Resolution All namespaces are resolved Select Next to modify the created schemas workspace locations Namespaces 4 Namespace
118. d type in any query or SQL statement After creating your models you can test them by using the Preview Data action R By selecting a desired table object and executing the action the results of a simple query will be displayed in the Teiid Designer in various view toolbars and context menus There are two requirements for previewing your data 1 The selected object must be one of several previewable model object types 2 All source models within the model dependency tree must reference a connection profile Model objects that can be previewed include relational tables and views including tables involving access patterns relational procedures Web service operations and XML document staging tables Note that any virtual table view or procedure is previewable as long as all physical source models After selecting the Preview Data action Designer will insure that all source models are associated with connection profiles and that all required passwords are set If the model selected for preview is a source model and there is insufficient connection info for that model the following dialog will be displayed and the action terminated Preview Not Available Preview not available for model gt gt ProductsSOLServer xmi A Use Modeling gt Set Connection Profile action first then retry Figure 9 3 Preview Not Available If any of the source models in the corresponding project require a password that can t be retrieved from an
119. de within XML files For example Sample Financial Services shares an XML schema with its partners Example Mutual Insurance Illustrative Brokerage and FinancialPartners com The partners created the schema broadly to cover all possibilities for information they might need to interchange As such the customer information XML document might include a choice compositor based on a list of all products all companies offer However Sample Financial does not offer a credit card so it could exclude those elements from the XML documents its Telid Designer Server creates since it will never have credit card information for an XML document The table on the Choice Editor contains the Include column By default all elements specified by the schema are included You can click to remove the check mark beside any element you do not want to include within your XML documents generated by this virtual XML document metadata model By removing the check mark you are not removing the element from the XML Document model you are merely telling the T elid Designer Server that it will never use this element as part of the choice You cannot edit criteria for excluded elements However if you exclude an option for which you have established a criteria Telid Designer will retain the criteria if you want to include the option in the future 6 2 3 3 Editing Choice Criteria To edit the criteria for a choice element Step 1 In the table on the Choice Editor panel
120. delextension namespaceUri org my extension mymodelextension version 1 XS1i schemaLocation http org telid modelExtension 2011 modelExtension xsd xmins http org teiid modelExtension 2011 gt lt p description gt This is my model extension lt p description gt lt p extendedMetaclass name com metamatrix metamodels relational impl BaseTableImpl gt lt p property advanced false index true masked false name copyable required false type boolean gt lt p description locale en_US gt Indicates if table can be copied lt p description gt lt p display locale en_US gt Copyable lt p display gt lt p property gt lt p extendedMetaclass gt lt modelExtension gt The MED Registry is where the MEDs used by Designer are stored MED files can be edited by opening the mxd file in the Extension Editor 2 4 8 2 Model Extension Definition Registry MED Registry A MED registry keeps track of all the MEDs that are registered in a workspace Only registered MEDs can be used to extend a model There are 2 different types of MEDs stored in the registry Built In MED these are registered during Designer installation These MEDs cannot be updated or unregistered by the user User Defined MED these are created by the user These MEDs can be updated registered and unregistered by the user The MED Registry state is persisted and is restored each time a new session is started JBoss Enterprise Data Services 5 Teiid Designer
121. dering check the Lock Target Attributes checkbox This will lock the attributes in place Re Order Attributes To change the ordering of the target attributes use the Top Up Swap Down and Bottom controls beneath the table Select or multi select the table rows then click the desired action button Delete Attributes To delete one or more of the target attributes select the table row s you want to delete then click the Delete button Resolve Types If an Attribute SQL Symbol binding has a datatype conflict a message will be displayed To assist in resolving the datatype conflict a Datatype Resolver Dialog is provided Click on the table row then click the Type Resolver button to display the dialog See Unmatched SQL Symbols list This list is to the right of the attribute symbol binding table and shows the SQL symbols from the transformation SQL that are not bound to a target table attribute Here are a few things you can do in the list section Add SQL Symbols To Add SQL Symbols to the list click the Add button You will be presented with a dialog showing all available symbols from your transformation source tables Click on the symbols you want to add then click OK Remove or Clear Symbols To remove one or more of the SQL symbols select the list items then click the Remove button To clear the entire SQL symbols list click the Clear button Sort Symbo
122. ductiD tableName ProductData gt lt Back Next gt Cancel m Fir ti Figure 5 30 Select Import Type Relational Model XML Format Perform Steps 4 On the next page select the XML file on your local file system via the Browse button Select a target model to which the imported relational objects will be added via the second Browse button The dialog allows selecting an existing relational model or creating a new model Note the contents of your selected XML file will be display in the File Contents viewer Click Finish to create your new Chapter 5 Importers Import Metadata From Text File Select Source Text File and Target Relational Model Select Metadata Ale to Import and Destination Model or model folder Select Source Text Ale r Release 7 6 planning SampleRelationalXML xml Browse Target Location ProductsFromXMLtText xmi Browse Ale Contents lt xml version L 0 encoding UTF 8 gt lt re lational model name myRelationalModel xmins http www teiid org xsi schemaLocation http www teiid org file hame blafond Documents Teiid Designer Rele lt table name ProductData namelnSource dbo products ProductData description Basic stocks or bond data table amp xa second line Sea amp 9 Be cardinality 100 materialized true supportsUpdate true system true gt lt colurmm name ProductiD description Unique ID for this product namelnSource dbo product
123. e Actions available in this view include l New Teiid Instance Create a new instance of a running Telid server Teid Server Properties View and edit properties of an existing Telid instance E9 Reconnect Reconnect and refresh contents of the selected Teiid instance Delete Disconnect and delete the selected Teiid instance Execute VDB Creates a JDBC Teiid connection profile and opens the Data Tools Database Development perspective Hs Undeploy VDB Removes the selected VDB from the Telid instance oe Create Data Source Launches the New Data Source wizard 3 Delete Data Source Removes the selected Data Source from the Teiid instance If you chose the Use a custom label option the text entry field will enable as shown below New Tetid Instance Enter Teiid Instance Information Define the Teiid Instance connection information Host localhost Label Use host URL as label Use a custom label development server Figure C 14 Use a Custom Label Option C 2 4 Properties View The Properties View provides editing capabilities for the currently selected object in Telid Designer The selection provided by whichever view or editor is currently in focus will determine the its contents To edit a property click a cell in the Value column As in the Table Editor each cell provides a UI editor specific to the property type 222 Teiid Designer UI Reference Object URI Searchability
124. e XSD files using the steps below a Step 1 In Model Explorer choose the File gt Import action t in the toolbar or select a project folder or model in the tree and choose Import a Step 2 Select the import option Metadata Modeling gt XSD Schemas and click Next gt e Step 3 Select either Import XSD Schemas from file system or Import XSD Schemas via URL and click Next gt 5 Step 4a If importing from file system the Import XSD Files dialog is displayed Click on the Browse button to find the directory that contains the XSD file s you wish to import a To Select all of the XSD files in the directory click the checkbox next to the folder in the left panel To select individual XSD files click the checkboxes next to the files you want in the right panel 113 JBoss Enterprise Data Services 5 Teiid Designer User Guide Import XML Schema Files File system Import resources from the local file system From directory np testdata johndoe test data schemas book Browse fe amp books x BookDatatypes xsd fj Books xsd C x BooksInput xsd Deselect All Into folder Browse Options Create complete folder structure Create selected folders only Advanced gt gt Add Dependent Schema Ales lt Back ext gt Cancel Finish Figure 5 63 Select XSD From File System e Step 4b If importing from URL select the Import XML Schemas via URL option and click OK to display t
125. e C 51 Editing String Property C 3 1 4 Semantic Editor The Semantic Editor is a tree based editor for XML Schema elements and attributes C 3 1 5 Source Editor The Source Editor is a simple text editor which is aware of XML Schema formatting rules C 3 1 6 Model Object Editors 250 Teiid Designer UI Reference The Model Object Editors represent specialized sub editors which are available for specific model object types For details select a specific editor listed below C 3 2 VDB Editor A VDB or virtual database is a container for components used to integrate data from multiple data sources so that they can be accessed in a federated manner through a single uniform API A VDB contains models which define the structural characteristics of data sources views and Web services The VDB Editor provides the means to manage the contents of the VDB as well as its deployable validation state The VDB Editor shown below contains a upper and lower panels The upper panel contains the Models tab and an Other Files tab The lower panel contains tabs for managing Data Roles the VDB Description and Translator Overrides Models Other Ales 09 P source Name Translator INDI Name Description Ga Products xmi UpdateVGTest Products oracle Products tay Updates xmi Up dateVGTest vi E Data Roles VDE De scription Translator Overrides Data Role Description CustomerService Figure C 52 V
126. e modeled as User Defined functions Running the action will display the Create New Source Function dialog Enter your database function name define input parameters including datatype and length specify output parameter info set options and click OK re Wr PartsSupplier xmi d New gt gt import declarations 2 New Child gt amp Base Table ta Package Diagram FEET x odelin gt R PARTS a m Index gt HL SHIP_VIA ce E Procedure gt R SUPPLIER fe Source Function gt R SUPPLIER PARTS Copy gt getPartinfo aste v is Custom Diagram gt J Data Source Figure 7 1 New Source Function Action The resulting source function will be added to your model and will be represented by the icon 150 Chapter 7 Metadata specific Modeling Create Source Function Create New Source Function Press OK to finish getEmployeelnta Input Parameters Include Name employeelD integer string string string Return Parameter Name employeelnto Properties Descriptio Cancel Figure 7 2 Create New Source Function Dialog When finished the new source function will be displayed in your model s package diagram 151 JBoss Enterprise Data Services 5 Teiid Designer User Guide Figure 7 3 New Source Function In Package Diagram After saving your model your new source function will be available for use in your transformations
127. e name user is able to rename the new object right in the tree Delete Deletes the selected object s Rename Allows a user to rename an object These actions are presented in Telid Designer s main Edit menu and also in the right click context menus for model objects selected in the Model Explorer Dialog Editor and Table Editor Modeling Sub Menu In addition to the New Child Sibling Association menus available for object creation Designer provides a Modeling sub menu which presents various object specific actions which can be performed If you select a source table for instance the modeling menu below would be presented WF ET orthwind xmi gt import declarations 2 ta Package Diagram gt E Alphabetical list_of products Categori New Child gt B Categor New Sibling gt amp Current ed New Association gt HE Custome Modeling Create Web Service gt HE Custome gt E Custome ta Add To New Custom Diagram Figure 6 11 Modeling Sub Menu for Source Table If a view table is selected the menu would reflect the actions related to virtual operations 122 Chapter 6 Creating and Editing Model Objects as ia Customerviews mi b import declarations 3 Ha Package Diagram Alphabetical list_of_ products gt F b E Category New Child gt E Current oe gt gt E E New Association gt gt g BEREA Modein O OZO O O gt air Create Materialized Views gt
128. e table cell is highlighted for renaming 6 1 3 New Association Action Step 1 Select two objects you wish to associate For example select columns in different base tables Step 2 Right click From the pop up menu select New Association gt Foreign Key Relationship 120 v YS TwoSourceParts lt v PartsDB2 xmi Chapter 6 Creating and Editing Model Objects E SHIPPER_ID bigdecimal gt import declarations 2 Fr E SHIPPER NAME string 30 Ha Package Diagram PK SHIP VIA gt H PARTS l al v amp meirean New Child A El SHIPPER_NAME strin New Sibling F PK_SHIP_VIA v E STATUS Men assocaton gt Foreign Key Relationship Modeling gt Relationship E STATUS_NAME string lt Undo Delete multiple objects F PK_STATUS gt E SUPPLIER bo El SIIPPIIFR PARTS of Cut Ctrl x Figure 6 9 New Association Action In Model Explorer Step 3 The new relationship link is displayed in the diagram A SHIPPER_ID bigdecimal SHIPPER NAME string 30 F PK_SHIP_VIA 2 STATUS ID bigdecimal E STATUS NAME string 30 ERD TO MANY NewForeignkey _o ee SS Fi NewForeignkey P PE_STATUS Figure 6 10 New Association In Diagram Step 1 Select two objects you wish to associate For example select elumne in different base tables Step 2 Right click From the pop up menu select New Association gt Foreign Key Relationship
129. eb Service Models Definition Allinputs OK Click Next gt to define custom procedures Location SteckService see Name CountrylnfoService xmi aa Status Source model CountrylnfoService xmi does not exist and will be created and contain the required invoke web service Source Model Definition 2 _ procedure Location SteckService sia Name CountrylnfoServiceView xmi md Status View Model Definition __ ___ _ _ View model CountrylnfoServiceView xmi does not exist and will be created and contain your generated procedures Precedure Generation Options Userspecified Procedures Define user specified request and response procedures from your WSDL schema elements Legacy Procedures Generate legacy create and extract procedures lt Back a Cancel Finish M Figure 5 40 WSDL Source Selection Step 6 This wizard generates both request and response procedures that are used in the queryable wrapped procedure The next page Procedure Definition provides the means to define the details of your request and response structures In the Request tab select and double click the schema elements you wish to be input parameters for your request These will be added to the Element Info panel and the resulting generated SQL statement will be updated
130. ect Model Object Name Dialog 146 Chapter 6 Creating and Editing Model Objects Next select the model object in the Extended Model Objects section and use the actions and properties table in the lower Extension Properties section to add remove or edit your actual extended properties Selecting the add or edit extension properties actions displays a dialog containing sections to edit general properties value definition required masked allowed values as well as display name and description values which can be internationalized Edit Property Definition zi Property Definition Enter the property s general information value information descriptions and display names General Enter general property characteristics Model Object BaseTable Namespace Prefix mymodelextension ID copyable Runtime Type boolean Should only be modified by advanced users Will be used by Teiid server Value Definition Enter the characteristics of the property value A value is required Mask the property value when shown to user The value must be one of the following true false Use this initial value The value can only be this value Display Name ke t Description Ta Cancel OK Figure 6 37 Edit Property Definition Dialog 6 3 3 Extending Models With MEDs MEDs must be applied to a model in order for their extension properties to be available to that model s model objects To manage the applied MEDs for a specif
131. ed E3 Reconcile allows you to resolve any discrepancies between the transformation symbols and the target attributes Pressing this button will display the Reconcile Virtual Target Attributes dialog box in which you can resolve discrepancies Save Validate saves edits to the current transformation and validates the transformation 124 Chapter 6 Creating and Editing Model Objects SQL Any Warning or Error messages will be displayed at the bottom of the editor in the messages area If the SQL validates without error the message area is not displayed Criteria Builder allows you to build a criteria clause in your transformation The button will enable if the cursor position is within a query that allows a criteria Pressing the button will launch the Criteria Builder dialog If the Criteria Builder is launched inside an existing criteria that criteria will be displayed for edit otherwise the Criteria Builder will be initially empty Expression Builder allows you to build an expression within your transformation The button will enable if the cursor position is at a location that allows an expression Pressing the button will launch the Expression Builder dialog If the Expression Builder is launched inside an existing expression that expression will be displayed for edit otherwise the Expression Builder will be initially empty Expand Select allows you to expand a SELECT clause into a SELECT clause which contains all
132. ed Models are defined using Teiid Designer in various ways Created via importing source data characteristics Manual creation via New Models Transforming or copying from one model into another Various custom actions 2 4 3 Guiding through the process To make the process of using Teiid Designer to build models more as easy as posssible a guides view 22 Chapter 2 Introduction actions necessary to develop models for specific use cases Action sets are available for the following scenerios Consuming a SOAP Web Service Creating a REST WAR archive Creating a SOAP WAR archive Modelling from a Flat File Source a text file Modelling from a JDBC Data Source Modelling from a Local XML File Source Modelling from a Remote XML File Source Connecting to a Telid Server 2 4 4 Model Classes and Types Telid Designer can be used to model a variety of classes of models Each of these represent a conceptually different classification of models Relational Model data that can be represented in table columns and records form Relational models can represent structures found in relational databases spreadsheets text files or simple Web services XML Model that represents the basic structures of XML documents These can be backed by XML Schemas XML models represent nested structures including recursive hierarchies XML Schema W3C standard for formally defining the structure and constraints of XML documents as well
133. ed Input Variable declarations Procedure section providing SQL editing of the procedure 142 Chapter 6 Creating and Editing Model Objects q DookCollection WS xmi si P BooksXML xmi Em Operation Editor A Cursor at 1 1 E A Operations Input Variables Q bookCollection The variables representing values from the request document that are available to the selected operation s procedure if getbookCollection Add or Remove variables IN_ author string IN_ edition string IN_isbn string IN_publishDate string Procedure The body of the selected operation s procedure li e itis not necessary to include the CREATE or BEGIN END clauses CREATE VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES IN_isbn xpathvalue BOOKCOLLECTION WS BOOKCOLLECTION GETBOOKCOLLECTION bookCollectioninpu t P bookCollection book isbn DECLARE string VARIABLES IN title xpathvalue BOOKCOLLECTION WS BOOKCOLLECTION GETBOOKCOLLECTION bookCollectioninpu t bookCollection book title DECLARE string VARIABLES IN_ subtitle xpathvalue ta Package Diagram E Table Editor 7 Operation Editor Figure 6 32 Operation Editor The Operations section contains all interfaces and operations currently defined in the model Selecting an operation will display the variables related to the input parameter s content in the Input Variables section and the bod
134. ed object New gt Sibling This menu is created dynamically to support the creation of whatever types of Sibling objects can be created under the same parent as the selected object New gt Association This menu is created dynamically to support the creation of whatever types of associations can be created with the selected object Modeling gt This menu is created dynamically Various modeling operations are presented based on selected model object type Undo Reverses the effect of the most recent command gt Redo Reapplies the most recently undone command f Cut Deletes the selected object s and copies it to the clipboard S Copy Copies the selected object s to the clipboard Paste Pastes the contents of the clipboard to the selected context Paste Special Provides additional paste capabilities for complex clipboard objects Clone Duplicates the selected object in the same location with the same name User is able to rename the new object right in the tree Delete Deletes the selected object s Select All Select All objects in current view Rename Allows a user to rename an object in the tree Find Replace Launches dialog that can be used to search in the current text view such as a Transformation Editor 5 gt D CT io 8 JBoss Enterprise Data Services 5 Teiid Designer User Guide Open Opens the selected object in the appropriate editor Edit Opens the selected
135. edCustomerAccounts Use default location Cancel Figure 8 9 Clone Project In Project Menu Step 4 Optional If you wish to create your cloned project in a location other than your default workspace location uncheck the Use default location check box and specify type in or browse to a new directory location on your local file system Step 5 Click Finish to generate your new project 185 JBoss Enterprise Data Services 5 Telid Designer User Guide Chapter 9 Testing Your Models As described earlier you can test your models in Telid Designer by using the Preview Data action X or test your models via your deployable VDB These two options will be described in detail in this chapter as well as managing your required connection profiles 9 1 Manage Connection Profiles Telid Designer utilizes the Eclipse Data Tools Platform DTP Connection Profile framework for connection management Connection Profiles provide a mechanism to connect to JDBC and non JDBC sources to access metadata for constructing metadata source models Telid Designer also provides a custom T elid connection profile template designed as a JDBC source to a deployed VDB By selecting various Telid Designer Import options any applicable Connection Profiles you have defined in your Database Development perspective will be available to use as your import source From these import wizards you can also create new connection profiles or edit existing connection
136. er location jus rfshare tetid Data Ale Name 5 parts xmil Selected Data File parts xr Source Model Definition Location at Name PartxMiSource O O 00000 a Model Status NEW MODEL Source model ParttMLSource does not exlst Model with required getTextFiles procedure will be created on FINISH lt Back Cancel Figure 5 21 XML Data File Source Selection Page Step 5 The primary purpose of this importer is to help you create a view table containing the transformation required to query the user defined data file This page presents a number of options you can use to customize the Generated SQL Statement shown in the bottom panel The to panel contains an XML tree view of your file contents and actions buttons you can use to create column entries displayed in the middle Column Information panel To create columns select a root XML element and right click select Set as root path action This populates the root path value Next select columns in the tree that you wish to include on your query and select Add selection as new column button You can also modify or create custom columns by using the ADD DELETE UP DOWN to manage the column info in your SQL Note that the Path property value for a column is the selected element s path relative to the defined root path If no root path is defined all paths are absolute Each column entry requires a datatype and an optional default value See the Telid User s Guide
137. erprise Data Services 5 Teiid Designer User Guide Simple Datatype Editor Target Namespace http www metamatrix com XMLSchema DataSets Books BookDatatypes change Datatypes in BookDatatypes xsd Identification BookType Name ISBN change CommaSeparatedList Description ISBN using very simple formatting rules PublicatianDate PublicationYear e Inheritance Base datatype string http www w3 org 2001 MMLSchema change Create subtype of this datatype Prevent Restrictions C Atomic Open in Datatype Hierarchy view List Union Enterprise Information in this section is required in order to use this type in other models Enterprise Datatype Runtime type string C Axed F Use Default Inherited from string Hide Built in Datatypes TF ienwik Built in Datatypes anySimpletype F 0 Axed k Use Default anyURI Minimum Length C Axed W Use Default Add Description base64Binary Maximum Length fo f C Axed f Use Default Add Description Format bigdecimal biginteger blob boolean byte Enumerations Yajye Description Use Default char u Edit Whitespace Collapse 2 Axed Use Default clob date dateTime decimal double Remove Patterns value Description Use Default 0 9 X 10 13 Edit duration Remove ENTITY i float v Figur
138. es Teiid Designer Type anyURI base64 Binary bigdecimal biginteger blob boolean byte char clob date dateTime decimal double duration ENTITIES ENTITY float gDay gMonth gMonthDay gYear gYearMonth hexBinary ID IDREF IDREFS int integer language long Name NCName negativelnteger NMT OKENS NMT OKENS nonNegativelnteger nonPositivelnteger normalizedString NOTATION object positivelnteger 230 Java Runtime Type java lang String java lang String java math BigDecimal java math BigInteger java sql Blob a java lang Boolean java lang Byte java lang Character java sql Clob b java sql Date java sql Timestamp java math BigDecimal java lang Double java lang String java lang String java lang String java lang Float java math BigInteger java math BigInteger java sql Timestamp java math BigInteger java sql Timestamp java lang String java lang String java lang String java lang String java lang Integer java math BigInteger java lang String java lang Long java lang String java lang String java math BigInteger java lang String java lang String java math BigInteger java math BigInteger java lang String java lang String java lang Object java math BigInteger Teiid Designer UI Reference QName java lang String short java lang Short string java lang String time java sql Time timestamp java sql Timestamp token java lang String unsignedByte java lang Short unsignedint java lang Long uns
139. es View Metadata models not only describe that business view but also illustrate how the meta objects within the View Metadata models derive their information from other metadata models Let s return to the example of our address book database and the vendor s comma separated list We want to generate the View Metadata model Address Pool from these enterprise information systems The transformation that joins these metadata models to create the virtual Address Pool metadata model contains a SQL query called a union that determines what information to draw from the source metadata and what to do with it The resulting Address Pool contains not only the address information from our Address Book database but also that from our vendor supplied text file 2 3 6 3 2 SQL in Transformations Transformations contain SQL queries that SELECT the appropriate attributes from the information sources For example from the sources the transformation could select relevant address columns including first name last name street address city state and ZIP code Although the metadata models could contain other columns and tables such as phone number fax number e mail address and Web URL the transformation acts as a filter and populates the Address Pool metadata model with only the data essential to building our Address Pool You can add other SQL logic to the transformation query to transform the data information For example the address boo
140. esforce gt gt Source Model WSDL Ale or URL gt gt Source Model WSDL Ale or URL gt gt Web Service Model S XML Schemas Cancel Figure 5 10 Import from Flat File Source Step 3 Select existing or previous connection profile from the drop down selector or press New button to launch the New Connection Profile dialog See Eclipse Data Tools documentation or Edit to modify change an existing connection profile prior to selection Note that the Flat File Source selection list will be populated with only Flat File connection profiles After selecting a Connection Profile the file contents of the folder defined in the connection profile will be displayed in the Available Data Files panel Check the data file you wish to process The data from this file along with your custom import options will be used to construct a view table containing the required SQL transformation for retrieving your data and returning a result set Lastly enter or unique source model name in the Source Model Definition section at the bottom of the page or select an existing source model using the browse button Note the Model Status section which will indicate the validity of the model name whether the model exists or not and whether the model already contains the getT extFiles procedure In this case the source model nor the procedure will be generated When finished with this page click Next gt Chapter 5 Importers Import From Flat File So
141. esiding in multiple physical repositories A VDB is composed of various data models and configuration information that describes which data sources are to be integrated and how In particular source models are used to represent the structure and characteristics of the physical data sources and view models represent the structure and characteristics of the integrated data exposed to applications Access Layer The access layer is the interface through which applications submit queries relational XML XQuery and procedural to the VDB via JDBC ODBC or Web services Query Engine When applications submit queries to a VDB via the access layer the query engine produces an optimized query plan to provide efficient access to the required physical data sources as 13 JBoss Enterprise Data Services 5 Telid Designer User Guide determined by the SQL criteria and the mappings between source and view models in the VDB This query plan dictates processing order to ensure physical data sources are accessed in the most efficient manner Connector Framework Translators and resource adapters are used to provide transparent connectivity between the query engine and the physical data sources A translator is used to convert queries into source specific commands and a resource adapter provides communication with the source 1 6 Design Tools for EDS The following design tools are available to assist users in setting up an EDS Service for their desired
142. esigner User Guide Parsed Column Data The following list contains the parsed column data from the selected line Parsed Column Data lastName Glare ArstName Diodie MiddleName Vojvoda Empld 9000060 Department G AnnualSalary 71000 Title Associate HomePhone 480 650 9750 Mgrld 3000073 street 127 State St City Los Angeles state CA ZipCode 10005 Figure 5 14 Parse Column Data Dialog Step 5b Fixed Column Width Option The primary purpose of this importer is to help you create a view table containing the transformation required to query the user defined data file This page presents a number of options you can use to customize the Generated SQL Statement shown in the bottom panel for the fixed column width option Specify header options Column names in header header line number and first data line number Parse selected row changed character delimiter and edit the TEXT TABLE function options See the Teiid User s Guide for details on the TEXT TABLE function If columns names are not defined in a file header or if you wish to modify or create custom columns you can use the ADD DELETE UP DOWN to manage the column info in your SQL You can also utilize the cursor position and text length values in the upper left panel to determine what your column widths are in your data file When finished with this page click Next g
143. est of Cut Ctri x gt BookNested _ a Figure 7 18 Create XML View Documents Action The action will query you for a target XML Document model You can either select an existing XML Document model from your workspace or enter a unique model name and the wizard will create a new model for you Select or create XML View model BooksxXMLiest gt 3 BookDatatypes xsd C Books xsd Ea Booksinput xsd Pi Books XML xmi ka Parts Test gt G Northwind xmi gt G PartsSupplier xmi J PartsTestVDB vdb Cis ProductsOracle xmi O OO O 69 Enter name and click OK to create a new XML View Model in folder BooksXMLTest Properties Cancel Figure 7 19 Select or Create XML View Model Dialog After selecting or creating your new XML Document model the XML Document builder page will be Chapter 7 Metadata specific Modeling E Build XML Documents From XML Schema x Select XML Schema Select XML Schema file then select Schema Root Elements Or press Anish to create an empty XML Document XML Schema Ale yB ooksXMLTest Books xsd Select one or more Schema Root Elements to generate Virtual Documents Schema Root Elements Virtual Documents e bookCollection BooksNS BookSetNested e bibliography BooksNS Bibliography mn le bookListing BooksNS BookSetFlat A e bookSetMixed BooksNS BookSetMixed xa Keep sorted alphabetically Document Options Build full virtu
144. eters required for the Telid XMLT ABLE function used to query the data file You can also choose to update an existing view model instead of creating a new view model The XMLT ABLE function uses XQuery to produce tabular output The XMLT ABLE function is implicitly a nested table and may be correlated to preceding FROM clause entries XMLT ABLE is part of the 74 Chapter 5 Importers SQL XML 2006 specification XMLTABLE lt NSP gt xquery expression lt PASSING gt COLUMNS lt COLUMN gt AS name COLUMN name FOR ORDINALITY datatype DEFAULT expression PATH string Telid Designer will construct the full SQL statement for each view table in the form SELECT A entryDate AS entryDate A internalAudit AS internalAudit FROM EXEC CCC getTextFiles sample xml AS f XMLTABLE XMLNAMESPACES http www kaptest com schema 1 0 party AS pty pty students student PASSING XMLPARSE DOCUMENT f file COLUMNS entryDate FOR ORDINALITY internalAudit string PATH internalAudit AS A To import from your XML data file source follow the steps below Step 1 In Model Explorer choose the File gt Import action t in the toolbar or select a project folder or model in the tree and choose Import Step 2 Select the import option Telid Designer gt File Source XML gt gt Source and View Model and click Next gt Select Choose import source elect an import source de oe foie m ym i m oe r a
145. ews xmi Base Tables Fj Columns F Foreign Keys F Primary Keys ERNER Hame Name In Source system Cardinality Supports Uy New Child Cc a attern Pr Al Access Pattern New Sibling A m STATUS 7 A Column e New Association F Foreign Key Modeling SUPPLIER ary KE lt 2 Undo Delete multiple objects WW Unique Constraint Figure 6 5 New Child Action In Table Editor Step 3 The selected tab in the Table Editor changes to the tab for the child object type the new model object row is displayed and the row s name table cell is highlighted for renaming 6 1 2 New Sibling Action Step 1 Select the object to which you want to add a SnG For example you can add a column sibling to a column Step 2 Right click on that object From the pop up menu select New Sibling You can now select the sibling object you would like to add a Seagal S a v H PARTS 5 Eid FK GI IEC _ STATE m New Child i ae ls PART _ New Sibling W aa Pattern EY PART _ New Association A Column EY PART_ Modeling Fl mae F PK PA Foreign Key vo E SHIP_VIA lt Undo Delete multiple objects an E SHIPP W Unique Constraint El SHIPP Figure 6 6 New Sibling Action In Model Explorer Step 1 Select the object to which you want to add a bling For anole you can add a column sibling to a column Step 2 Right click on that object From the pop up menu select New Sibling You
146. expand the Introduction section then select Click to Begin The Create New Teiid Model Project section opens as shown Cheat Sheets 3 gq Consume a SOAP Web Service Create New Teiid Model Project Follow the steps below to create a Teiid Model Project Launch New Teiid Model Project Wizard p gt 1 Specify unique project name wf 2 Click Next gt twice to get to Model Project Options page 3 Check folders you wish the wizard to create in your project 4 Click Finish Create SOAP Web Service Connection Create Models From SOAP Connection Create VDB t Test VDB Figure 3 19 Create Model Project Note that each section of the sheet has basic instructions outlining what to do at each step Click Follow the wizard to create a new Model Project For this example we will use SOAPProj for our project name On the second page of the wizard select the sources and views folders Click Chapter 3 Start Here Finish The new project is created In the Cheat Sheet you can advance to the next step once the wizard has completed Click iv to advance to the next step Create SOAP Web Service Connection This section of the Cheat Sheet provides instructions for creating a connection profile for the SOAP Web Service as shown below Cheat Siesta g yoo Consume a SOAP Web Service v Introduction Create New Teiid Model Project v Create SOAP Web Service Connection Follow the steps below to
147. expression here Status Result1 Status Operation Date ACCOUNT_ID SSN STATUS TYPE DATEOPENED DATECLOSED Succe select fro Jun 8 2012 E ERE EERUN CST01002 Personal 1998 02 01 00 00 00 0 2 19980003 _CSTO1003 _ Personal Active 1998 03 06 00 00 00 0 2012 04 25 11 0 3 19980004 _CsTO1004 Personal Active 1998 03 07 00 00 00 0 2012 04 25 11 0 4 19980005 _CSTO1005 _ Personal Active 1998 06 15 00 00 00 0 2012 04 25 11 0 5 19980006 _CSTO1006 _ Personal Active 1998 09 15 00 00 00 0 2012 04 25 11 0 Figure 3 16 Execute VDB Example 3 2 Cheat Sheet Example In this section we introduce Cheat Sheets by walking through a simple example For this example we will follow the Consume a SOAP Web Service Cheat Sheet 3 2 1 Consume a SOAP Web Service This section shows how to consume a SOAP Web Service using a Cheat Sheet We will demonstrate connection to a publicly accessible web service You can use this process as an example for modeling other web services 38 Chapter 3 Start Here 1 Open the Cheat Sheet You can access the Cheat Sheet from the Designer Menu From the Designer main menu select Window gt Show View gt Other then select Help gt Cheat Sheets in the dialog Alternately you can access the Cheat Sheet from the Guide View A sample Guide view is shown below with the Consume a SOAP Web Service Action Set selected Guides 3 a
148. ferences Figure B 8 VDB Editor Preferences Panel B 1 4 Validation Preferences Validation Preferences provide a way to customize the severity of some of the rules checked during model validation The Validation preference pages shown below include the validation preferences for Core Relational XML and XSD XML Schema models 210 User Preferences Validation co Specify the Severity Level for validation related occurrences Relational Core Validation Control Settings Multiple EObjects with same uuid Ignore Ci String functions SUBSTRING LOCATE and INSERT 0 to 1 base check Warning Figure B 9 Core Model Validation Preferences Panel Validation ow v Specify the Severity Level for validation related occurrences Core Relati on al XSD EML Relational Validation Control Settings Missing length property on columns with string or character types Warning 2 Missing precision property on columns with numeric types Warning gt Columns of builtin type integer Warning Table missing name in source value Warning Name in source conflicts with sibling entities Ignore Indexes with columns from more than one table Warning Empty transformations Error Restrict name characters to valid unquoted SOL identifiers Ignore Figure B 10 Relational Model Validation Preferences Panel 211 JBoss Enterprise Data Services 5 Telid Designer User Guide
149. fine Teiid Model Project action launches the New Model Project Wizard In the Action Set list double click the action or select it then click Execute selected action The wizard is launched as shown below 27 28 JBoss Enterprise Data Services 5 Teiid Designer User Guide New Model Project New Model Project Create a new model project Project name Use default location Browse Location home mdnilin Runtime Workspaces 7_ 7 _x MyProject Working set O Add project to working sets Working sets a Select a Cama Figure 3 2 New Project Wizard Enter a project name e g MyProject for the name Then click Next The next page of the wizard is shown below Chapter 3 Start Here New Model Project Model Project Options Click Finish to create folders for your new project Create Folde TiL neme mii co Figure 3 3 New Project Folders Under Create Folders de select schemas and web_ services we won t need them for this example Now click Finish to exit the wizard The project has now been created your Model Explorer view should like like this i Model Explorer 0O Hn amp 7 amp MyProject sources views Figure 3 4 rer 3 Create JDBC connection 29 30 JBoss Enterprise Data Services 5 Teiid Designer User Guide The Create JDBC connection action will create the Connection profile for your database The c
150. for details on the XMLT ABLE function When finished with this page click Next gt 7 78 JBoss Enterprise Data Services 5 Telid Designer User Guide oS Import From XML File Source XML Data File Import Options Press the Next gt button to continue XML Ale pa rts xml MML File Contents __ Column Info 2 E partssupplier l Root Path partssupplier parts v E parts Column Name Default Val Add id E id 3 string El name name d string le color eT 7 E weight le parts E parts color i string AY weight 7 string le parts b b gt fe parts p b e parts Bj C Generated SQL Statement SELECT Aid AS id A name AS name A color AS color Aweight AS weight FROM EXEC PartxMLSource getTexthiles parts xml AS f XMLTABLE partssupplier parts PASSING XMLPARSE DOCUMENT f file COLUMNS id string PATH id name string PATH name text color string PATH color text weight string PATH weinhtirestil AS A lt Back Cancel Figure 5 22 XML File Delimited Columns Options Page Step 6 On the View Model Definition page select the target folder location where your new view model will be created You can also select an existing model for your new view tables Note the Model Status section which will indicate the validity of the model name whether the model exists or not Lastly
151. for each complex type The Figure 3 25 Consume SOAP Wizard On the Model Definition page the source and view model info section will be pre filled We will keep the names and location defaults for the source and view models Click Next to proceed to the next page as shown below Chapter 3 Start Here ale T Create Relational Model from Web Service Procedure Definition No columns are defined for the response procedure result set for the operation CapitalCity e lan 7 Operation CapitalCity gt O Overwrite existing procedures for this operation Request Response Wrapper Procedure Generated Procedure Name CapitalCity_request BODY HEADER Schema Contents SE v e Capitalcity 7 sequence Delete O sCountrylSOCode ig string Up Down eae SOL Statement CREATE VIRTUAL PROCEDURE BEGIN SELECT XMLELEMENT NAME CapitalCity XMLNAMESPACES DEFAULT http www oorsprong org lt Back Next gt Cancel Finish Figure 3 26 Consume SOAP Wizard On the Procedure Definition page the CapitalCity Operation will be selected since it is the only one used for this example On the Request tab select the sCountrylISOCode element then click the Add button This will add the selected element to the request Now select the Response tab as shown below 47 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Relati
152. g EY QUANTITY bigdecimal SUPPLIER_ID string SUPPLIER_NAME string SUPPLIER_STATUS bigdecimal SUPPLIER_CITY string SUPPLIER_STATE string PART_ID string QUANTITY bigdecimal El SHIPPER_ID bigdecimal SHIPPER_ID bigdecimal Remove Clear Sort Show SQL Display SELECT PartsDB 2 SUPPLIER SUPPLIER_ID SUPPLIER NAME SUPPLIER STATUS SUPPLIER_CITY SUPPLIER_STATE PART ID QUANTITY SHIPPER_ID PartsSQL SUPPLIER_PARTS PART ID Parts SOL SUPPLIER _PARTS QUANTITY PartsSQL SUPPLIER_PARTS SHIPPER_ID FROM PartsDB 2 SUPPLIER Parts 50L SUPPLIER PARTS P Cancel 4 Figure 6 15 Reconciler Dialog To summarize the different sections of the dialog Target Attributes SQL Symbol Table This table shows the target attributes in the left column and the SQL Symbols in the right column The SQL Symbols are the symbols that are projected from the SQL transformation A symbol is referred to as being bound to a target attribute when it is displayed next to the attribute 126 Chapter 6 Creating and Editing Model Objects lf a target attribute is unbound its row is highlighted in red The transformation is not valid until all attributes have a corresponding SQL symbol binding Here are a few things you can do in the table section Lock Target Attributes To lock the target attribute or
153. g mechanism for your WS Security enabled web service and your own security mechanism should be implemented in this class All source code is included in the generated war along with the compiled class files This is the target namespace that will be used in the generated WSDL and subsequent generated web service classes If selected MT OM will be enabled for the web service endpoint s You will also need to update your output schema accordingly by adding the xmins xmime http www w3 org 2005 05 xml mim schema and adding type xs base64 Binary xmime expectedContentT ypes application oc tet stream to the output element you wish to optimize The folder where the generated WAR file should be saved Step 3 Click OK to generate the web service war When war generation is complete a confirmation dialog should appear Click OK 172 Chapter 7 Metadata specific Modeling The WAR file PortfolioVDB was successfully created n i f j ri Figure 7 25 Generation Completed Dialog 7 4 2 2 Generating a RESTEasy War In Teiid Designer it is also possible to expose your VDBs over REST using a generated REST Easy war Also if your target virtual model has update insert and delete SQL defined you can easily provide CRUD capabilities via REST Accepted inputs into the generated REST operations are URI path parameters and or XML JSON JSON is exposed over a URI that includes json For example http host por
154. g name string category string quantity string Cancel Figure 7 7 Columns Tab The Primary Key tab allows editing of the name name in source and column definitions Note that un checking the box will clear the data The Unique Constraint tab contains the identical information 155 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Relational Table Create Relational Table Click OK to add new object to model This wizard allows creating a complete relational table including columns unique keys and foreign keys definition Ekcakunas IM Primary Key piLAinieue Kesatcaint Il iaminn Include PK Partinfo Name In Source PK Partinfo c ID Cancel Figure 7 8 Primary Key Tab The Foreign Keys tab allows creating editing and deleting multiple foreign keys 156 Chapter 7 Metadata specific Modeling Create Relational Table Create Relational Table Click OK to add new object to model This wizard allows creating a complete relational table including columns unique keys and foreign keys definition Properties Columns F Primary Key W Unique Constraint F Foreign Keys Foreign Key Name F FK_Supplier Cancel Figure 7 9 Foreign Keys Tab To create a new Foreign Key select the Add button and enter select the properties key references in the tables shown below Note the Select Primary Key or Unique Constraint table will display any PK UC existing in the selected relational
155. ges to print i e 2 through 8 Switch Workspace Opens the Workspace Launcher from which you can switch to a different workspace This restarts the Workbench Restart Exits and restarts the Workbench T Import Launches the Import Wizard which provides several ways to construct or import models LG Export Launches the Export Wizard which provides options for exporting model data Properties Alt Enter Opens the Properties dialog for the currently selected resource These will include path to the resource on the file system date of last modification and its writable or executable state Most Recent Files List Contains a list of the most recently accessed files in the Workbench You can open any of these files from the File menu by simply selecting the file name Exit Closes and exits the Workbench C 4 2 Edit Menu The Edit menu provides actions to manage the content structure and properties of your model and project resources The figure below represents the Edit menu presented when a metadata model is selected N Teiid Designer UI Reference New Child gt New Sibling gt New Association gt Modeling gt i Copy Ctrl C 2 Delete Delete Select All Ctri A Add Bookmark Add Task Figure C 66 Edit Menu The Edit menu contains the following actions New gt Child This menu is created dynamically to support the creation of whatever types of child objects can be created under the select
156. gned to provide feedback as to the completeness of the relational table information as well as the validation state of the table and it s components Note that although errors may be displayed during editing the wizard is designed to allow finishing with the construction of an incomplete table containing errors The first tab labeled Properties contains the input for the simple table properties including name name in source cardinality supports update and is system table properties 153 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Relational Table Create Relational Table l No columns defined for table This wizard allows creating a complete relational table including columns unique keys and foreign keys definition al Properties Columns P Primary Key Unique Constraint F Foreign Keys Model Ale SimpleRelational xmi Name Partsinto Name In Source PartsInfo Supports Update C Is System Table Cance Figure 7 6 Properties Tab The Columns tab allows creation and editing of basic relational columns This includes adding deleting or moving columns as well as changing the name datatype and length properties 154 Chapter 7 Metadata specific Modeling Create Relational Table Create Relational Table Click OK to add new object to model This wizard allows creating a complete relational table including columns unique keys and foreign keys definition Column Name Data Type ID strin
157. he action names are self explanatory We will create a new Model Project in the workspace then define our connection properties to a MySQL database We will then connect to the database and import the metadata creating a source model in Designer Next we will preview the database contents Finally we will define a VDB and then deploy it to a running Telid Server to execute 3 1 1 Model a JDBC Source This section shows how to Model a JDBC Source using the Guide View action set We will connect to a MySQL database for this example but you can use the same process to connect to any supported database 1 Open Guides View To open the Telid Designer s Guides view select the main menu s Window gt Show View gt Other and select the Teiid Designer gt Guides view in the dialog The Guides view is shown below with the Model JDBC Source Action Set selected Chapter 3 Start Here A Guides xN z Modeling Actions 7 Action Sets Model JDBC Source a Define Teiid Model Project Create JDBC connection Create source model for JDBC data source Preview Data A Define VDB G Execute VDB Description lt no action selected gt Cheat Sheets Cheat sheets for Telid Designer use cases Create Model from JDBC Source Create Model from Flat File Source Consume a SOAP Web Service Create Model from XML Local File Source Figure 3 1 Guides View 2 Define Teiid Model Project The De
158. he command Press Ctr1 A1Lt F2 to switch to a virtual terminal The first example highlights a particular key to press The second example highlights a key combination a set of three keys pressed simultaneously If source code Is discussed class names methods functions variable names and returned values mentioned within a paragraph will be presented as above in mono spaced bold For example File related classes include filesystem for file systems file for files and dir for directories Each class has its own associated set of permissions Proportional Bold This denotes words or phrases encountered on a system including application names dialog box text labeled buttons check box and radio button labels menu titles and sub menu titles For example Choose System Preferences Mouse from the main menu bar to launch Mouse Preferences In the Buttons tab select the Left handed mouse check box and click Close to switch the primary mouse button from the left to the right making the mouse Suitable for use in the left hand To insert a special character into a gedit file choose Applications Accessories IDiAcas CAAA ELA AR Mata CaANnrnnoe EK Tain Mnanciann rllocear C ina JBoss Enterprise Data Services 5 Telid Designer User Guide Character Map from the main menu bar Next choose Search Find fromthe Character Map menu bar type the name of the character in the Search field and click Next The character yo
159. he contents of an existing model to a newly defined model You can choose a full copy or select individual model components for copy To create a new relational model by copying contents from another web service view model complete e Step 5 Select the model builder labeled Copy from existing model of the same model class and 99 JBoss Enterprise Data Services 5 Telid Designer User Guide click Next gt The Copy Existing Model dialog will be displayed Step 6 Select an existing relational model from the workspace using the browse button Step 7 Check the Copy all descriptions option if desired Click Finish 4 5 2 Build From Existing WSDL File s or URL This builder option creates a Web service model based on a user defined WSDL file and its referenced schemas In addition applicable XML schema files and XML View document models optional are created To create a new relational model by copying contents from another web service view model complete 4 5 4 Build From XML Document View Models Web Service models and their corresponding Interfaces and Operations can be generated in Telid Designer from XML View model components Namely XML View Documents and XML View Document roots To create a new Web service model from XML components Step 1 Select either a single XML Document or single XML Document root in the Model Explorer View Step 2 Right click select Modeling gt Create Web Service action Step 3 Fill in m
160. he drop down selector or press New button to launch the New Connection Profile dialog See Eclipse Data Tools documentation or Edit to modify change an existing connection profile prior to selection Note that the Connection 59 JBoss Enterprise Data Services 5 Telid Designer User Guide Profile selection list will be populated with only JDBC Database connections Import Database via JDBC Select a JDBC source configuration Select the JOBC source configuration for the database to be imported into a relational model Connection Profile JDBC Metadata Processor Properties Driver URL User Name Password Figure 5 4 Select JDBC Source Configuration Dialog Because JDBC databases are different special processing of your metadata to be required in order to convert datatypes or to interpret your metadata The JDBC Metadata Processor drop down selector will be auto selected based on your selected connection profile Special processors are available for DB2 Modeshape ODBC Oracle PostgeSQL SQL Server and Sybase For all other DB s a default JDBC processor is available Step 4 After selecting a Connection Profile input password if not provided Press Next gt or Finish if enabled 60 Chapter 5 Importers Import Database via JDBC Select a JDBC source configuration Press the Next gt button to continue or the Anish button to finish Connection Profile PartsOrac
161. he final Add XML Schema URLs wizard page 114 Chapter 5 Importers Import XML Schema Files Add XML Schemas URLS XML schema URLs Into folder BooksProject Options Add Dependent Schema Ales lt Back Jext gt Cancel Figure 5 64 Add XML Schema URLs Dialog e Step 5 Click the Add XML Schema URL button Enter a valid schema URL Click OK Schema will be validated and resulting entry added to the list of XML Schema URLs XML Schema Url Enter XML schema URL http ns hr xml org 2_4 HR XML 2 4 StandAlone Resume xsd Optional User Name Password Verify Hostname HTTPS Cancel Figure 5 65 Add XSD Schema URLs 115 JBoss Enterprise Data Services 5 Teiid Designer User Guide The schema URL is now displayed in the XML Schema URLs list Import XML Schema Files Add XML Schemas URLs XML schema URLs http ns hr xml oarg 2 4 HR XML 2 4 StandAlone Resume xsd Into folder BooksP roject Optians Overwrite existing resources without warning Add Dependent Schema Ales A nish Figure 5 66 Add XSD Schema URLs e Step 6 Click Finish XSD files may have dependent files This importer will determine these dependencies and import these as well if Add Dependent Schema Files is checked 116 Chapter 6 Creating and Editing Model Objects Chapter 6 Creating and Editing Model Objects This section Summarizes Teiid Designer features for creating and editing existing
162. he form MaxInclusive TotalDigits FractionDigits Blank or zero values are ignored A sample of typical input data is shown below Sample Ale Format TYPETAG Name Description Base type Length MinLength MaxLength MinBound MinInclusive MaxBound Maxinclusive TotalDigits Fraction Digits TYPE Atomicl Description for Typel BType 5 1 10 1 2 1 2 5 2 TYPE Atomic Description for Type2 BType 5 1 10 1 2 1 2 5 2 Figure 5 37 Select Import Type Datatypes CSV Format 91 JBoss Enterprise Data Services 5 Telid Designer User Guide Step 4 In the next page you ll need to provide a source text file containing the metadata formatted to the specifications on the previous page Import Metadata From Text File Select Source Text File and Target Datatypes Model Select CSV Ale to Import and Destination Model or model folder Select Source Text Ale Browse Target Location Browse Ale Contents Cancel Figure 5 38 Select Source Text File and Datatypes Model Step 5 Select an existing datatype model as the target location for your new model components using the Browse button to open the Datatypes Model Selector Dialog Select a datatypes model from your workspace or specify a unique name to create a new model Step 6 Select any additional options and choose Finish 5 7 Import WSDL into Relational Models You can turn your WSDL file
163. he hook to inject the Endpoint property into a source model via the Modeling gt Set Connection Profile action This Endpoint value is required by the ws translator see Import gt Telid Designer gt WSDL File or URL gt gt Source and View Model SOAP Test Connection lt Back Next gt Cancel Finish Figure 3 22 SOAP Connection Properties The connection profile properties are entered on this page Click on the URL button then enter the following URL http www oo0orsprong org iwebsamples countryinfo CountrylnfoService wso WSDL Select None for SecurityT ype then click OK to complete the wizard In the Cheat Sheet you can now continue once the wizard has completed Click Iv to advance to the next step Create Models from SOAP Connection This section of the Cheat Sheet provides instructions for creating relational models using the previously created connection profile for the SOAP Web Service as shown below 43 JBoss Enterprise Data Services 5 Telid Designer User Guide B Cheat Sheets xo gy eo Consume a SOAP Web Service v Introduction v Create New Telid Model Project gt Create SOAP Web Service Connection Create Models From SOAP Connection Follow the steps below to create models using the previously defined connection profile v Launch the Consume SOAP Web Service Wizard gt L 1 Select the connection profile then press ie Validate WSD
164. he query reaches this limit You can only set this limit to a maximum supported by your T eiid Designer Server For more information about this limit contact your system administrator Step 3 Click the Action When Count Limit Exceeded drop down menu to instruct the Telid Designer Server what to do if it encounters more results for the query than the count limit before it reaches the limit condition a limiting condition for this recursion a Note The Teiid Designer Server will evaluate this condition each time it recursively performs this query lf this criteria clause evaluates false the Teiid Designer Server performs the query recursively again unless it has reached the Count Limit If the criteria evaluates true the Telid Designer Server performs the mapping for the current level and ends its recursive loop When you have created the criteria it displays in the Limit Condition box When the Teiid Designer Server dynamically populates your XML documents at runtime it will use the recursion specifications you entered here 6 2 5 Operation Editor Editing of Web Service Operation transformations is simplified via the Operation Editor When editing a Web Service model an additional editor tab labeled Operation Editor is available This editor shown below is comprised of Operations section showing a tree view of Interfaces and Operations contained within the Web Service model Input Variables section providing editing of desir
165. hich have recursive patterns For example if you have an element named Employee which contains a element named Supervisor which itself contains an Employee element nested within it you might need to limit the number of times the elements are nested within the document You can set the following conditions to limit the recursion A fixed number of results to the query An SQL based criteria limit condition A combination of both To open the Recursion Editor click on the Recursion Editor button on the displayed mapping class FEE Eo ATE FE CcMmpiL FEE asthame string Name string elnitial string p gt pa a t cS Es M T Ea pa Ea ba Ea Ea Ez Figure 6 30 Open Recursion Editor Button Recursion Editor Supervisor if Enable Recursion a x Count Limit 5 Action When Count Limit Exceeded THROW Limit Condition Edit EmploveeDocs EmploveeDocument MappingClasses Supervisor name Joe Smith Figure 6 31 Recursion Editor 141 JBoss Enterprise Data Services 5 Telid Designer User Guide To edit recursion properties Step 1 Click the Enable Recursion check box if you want the Telid Designer Server to perform the query you specify to generate the nested tags within the XML document Step 2 Click the arrows beside the Count Limit box to limit the number of times to recursively perform the query If you do not set a Limit Condition in the text area the recursion finishes when t
166. hich provides quick access to import various project examples into your workspace Report Problem A JBoss contributed action which provides simple problem reporting Check for Updates provides access to retrieve updates to installed Eclipse software Install New Software provides access to install new software into your workbench About JBoss Developer Studio Launches the About dialog JBoss Enterprise Data Services 5 Telid Designer User Guide Revision History Revision 5 3 1 3 402 Fri Oct 25 2013 Rudiger Landmann Rebuild with Publican 4 0 0 Revision 5 3 1 3 Mon Feb 11 2013 B Long Updated for 5 3 1 Revision 5 3 0 0 Wed May 2 2012 B Long Initial creation of book by publican Index feedback help 268
167. hoice Criteria box and reorders the XML document as well 6 2 3 5 Setting a Default Choice Action The default action represents the course the Telid Designer Server should take if none of the criteria you set evaluates to true You can set this default using the combo box available in the Choice Editor s toolbar to Any of the options within the table except those you have excluded from the document THROW to throw a Telid Designer Server exception RECORD to record the Teiid Designer Server exception DISCARD to place no element within the XML instance document Note You must set a default action for your choice criteria 6 2 4 Recursion Editor XML Some XML schemas define data structures that contain self referencing elements or datatypes When generating XML documents such data structures can produce an endless repetition of nested tags This self nesting pattern is Known as recursion When generating virtual documents from XML Schema the T elid Designer detects recursive data structures in the XML Schema model and halts the recursive nesting pattern after two cycles These two cycles serve different purposes when mapping the document The first cycle can be thought of as an entry condition for the recursion The mapping class located at this node defines a normal mapping transformation like that of any other in the document model The second cycle defines a mapping transformation that will be performed repeatedly until
168. ia the table cell and clicking 248 Teiid Designer UI Reference the button for datatype will display the following dialog Datatype int xsslong short stink long xstinkeger string Path http wana oroza long xssinkeger string string long xstinkeger ekrim Figure C 49 Editing Datatype Values C 3 1 2 2 Inserting Table Rows The Insert Rows action provides an additional way to create objects in a model Insert Rows action performs the same function as Insert Sibling action but allows you to create multiple children at the Same time All new rows will correspond to an object of the same type as the selected object and be located under the same parent as the selected object To Insert Rows in a table Step 1 Select a table row to insert rows after Step 2 Right click select Insert Rows action or select the Insert Rows action on the main toolbar The following dialog will be displayed Insert Table Rows Insert Rows Maximum of 1000 20 rows will be inserted Number of Rows 207 SY Figure C 50 Editing String Property Step 3 Edit the Number of Rows value in the dialog or use the up down buttons to change the value Step 4 Select OK in dialog The desired number of rows new model objects will be added after the original selected table row C 3 1 3 Simple Datatypes Editor The Simple Datatype Editor provides a form based properties view of XML Schema data 249 JBoss Ent
169. ic model select the model and right click select the Modeling gt Manage Model Extension Definitions action This will display a dialog listing the current applied MEDS and actions and buttons to add or remove MEDs from a model extract a MED froma model and save a copy of it locally as a mxd file and lastly update the version of MED in a model if it differs from a version in your MED registry 147 JBoss Enterprise Data Services 5 Telid Designer User Guide e oo Manage Model Extension Definitions Manage Model Extension Definitions Add or Remove Model Extension Definitions to be associated with this model Location Test Model View Current Model Extensions for the selected model Registered Different Namespace Prefix Version Description Add Remove Save Update Arar S Cancel Figure 6 38 Manage Model Extension Definitions Dialog Selecting the Add button displays a list of applicable MEDS based on model class e800 Available Model Extension Definitions Select the Model Extension Definition s to be added to the model Model Extension Definitions Namespace Prefix Version Description mymodelextension 1 This is my model extension rest 1 REST extended virtual procedure properties Select at least one Model Extension Definition Cancel T Cancel OK Figure 6 39 Add Model Extension Definitions Dialog 148 Chapter 6 Creating and Editing Model Objects a Note After adding removing
170. id Designer User Guide Create Relational Model from SalesForce Data Model SalesForce Credentials Validate the SalesForce Connection Profile Connection Profile EFS Properties URL lt default gt User Name joeBlowf bogus ortg Password J edesioigaiotgaiokgaiakaoak lt Back Next gt Cancel Anish Figure 5 24 Select Salesforce Credentials Dialog e Step 4 After selecting a Connection Profile input password if not provided Press Next gt to display the Salesforce Objects selection page Create Relational Model from SalesForce Data Model Select the SalesForce objects to Model Press the Next gt button to continue SalesForce Objects Account Account Partner Account Share Activity History Additional Directo Apex Class Apex Trigger Approval Approval Request Asset Assignment Rule Attachment Business Hours Deselect All Chapter 5 Importers Column Details 2 22 ee Visible Narne Name in Source Account ID 2 Id Deleted IsDeleted Master Record IE MasterRecordld Account Name Name Account Type Type Parent Account I Parentld Billing Street BillingStreet Billing City BillingCity Billing State Prot Billing State Billing Zip Posta BillingPostalCod Billing Country BillingCountry Shipping Street ShippingStreet Figure 5 25 Select Salesforce Objects Dialog Type id boolean reference string picklist reference textare
171. idated when they are deployed in a VDB for data access purposes Telid Designer will automatically validate your models whenever the user Saves Note the Project gt Build Automatically option must be checked When editing models the editor tabs will display a to indicate that the model has unsaved changes Py FY OU JBoss Enterprise Data Services 5 Telid Designer User Guide 2 4 7 Testing Your Models Designing and working with data is often much easier when you can see the information you re working with The Telid Designer s Preview Data feature makes this possible and allows you to instantly preview the information described by any object whether it s a physical table or a virtual view In other words you can test the views with actual data by simply selecting the table view procedure or XML document The preview functionality insures that data access behavior in the Teiid Designer will reliably match when the VDB is deployed to the Server Previewing information is a fast and easy way to sample the data Of course to run more complicated queries like what your application likely uses simply execute the VDB in the Telid Designer and type in any query or SQL statement After creating your models you can test them by using the Preview Data action By selecting a desired table object and executing the action the results of a simple query will be displayed in the Data Tools SQL Results view This action is accessible throughout
172. ignedLong java lang BigInteger unsignedShort java lang Integer XMLLiteral java sql SQLXML e a The concrete type is expected to be org telid core types Blob Type b The concrete type is expected to be org teiid core types Clob Type c The concrete type is expected to be org teiid core types XMLT ype C 2 9 Telid Model Classes View The Model Classes View provides a hiearchical EMF centric view of the various metamodel classes available within Telid Designer This view is primarily for informational purposes but can be used as a reference if creating relationships or searching your workspace for specific metamodel constructs iat Model Explorer n Outline Hh Teiid Model Classes EZ 5 H dee http www eclipse org emf 2002 Ecore dee http www eclipse org emf 2002 Mapping dee http www eclipse org uml2 3 0 0 UML dee http www eclipse org xsd 2002 X5D dee http www metamatrix com metamodels Compare dee http www metamatrix com metamodels Core dee http www metamatrix com metamodels Dependency dee http www metamatrix com metamodels Diagram dee Http www metamatrix com metamodels Extension dee http www metamatrix com metamodels DBC dee http www metamatrix com metamodels MetaMatrixFunction dee http www metamatrix com metamodels Relational d FFF FFF FFT gt H AccessPattern gt RelationalEntity com metamatrix metamodels r H BaseTable gt Table com metamatri
173. igner User Guide J downloadable text files Because these sources are maintained independently the tables have no standard column names and metrics For example some tables refer to Cost where others refer to Price and some costs are given per meter per m where others for the same materials are given per millimeter per mm The Solution Using the Teiid Designer tool developed to work with JBoss Enterprise Data Services EDS the information technology team at Acme Home Insurance created a virtual database VDB to integrate the data 1 They created source models for each of the required data sources by directly importing metadata from each source The flexibility of the connector framework enabled seamless integration of the different data source types for example Tenacicle IntegriSQL and plain text files 2 The team reconciled semantic differences regarding the meaning interpretation and intended use of data across the source models for example all of the integrated tables present the cost of materials as Cost per mm 3 They then created a series of customized views to present the integrated data in formats desired by the analysts The Result The analysts could access all of the data they required with a single API allowing them to focus their efforts on applying advanced analytical techniques without concern for the physical whereabouts or technical or semantic differences between the multiple data sour
174. iid Designer Creating models can be accomplished by either directly importing existing metadata or by creating them using one of several New Model wizard options This section describes these wizards in detail Use one of the following options to launch the New Model Wizard New Model Wizard Choose the File gt New gt Metadata Model action Select a project or folder in the Model Exploreer View and choose the same action in the right click menu Select the New button on the main toolbar and select the Metadata Model action Model names are required to be unique within Designer When specifying model names in new model wizards and dialogues error messages will be presented and you will prevented from entering an existing name 4 1 Creating New Relational Source Model Create New Relational Source Model To create a new empty relational source model e Step 1 Launch the New Model Wizard Step 2 Specify a unique model name Step 3 Select Relational option from Model Class drop down menu a Step 4 Select Source Model from Model Type drop down menu a Step 5 Click Finish ao Note You can change the target location i e project or folder by selecting the Browse button and selecting a project or folder within your workspace In addition to creating a new empty relational source model the following builder options are available a Copy from existing model of the same model class
175. iid Instance Information Define the Teiid Instance connection information Host localhost Label Use host URL as label O Use a custom label Tetid Admin Connection Info Port number 31443 User name admin Password kik save URL mms localhost 31443 SSL Set as default Teiid instance on Rnish Test Teiid JDBC Connection Info Port number 31000 User name user Password pte Save URL jdbc teiid lt vdbname gt mm localhost 31000 SSL Figure C 13 New Teiid Instance Dialog The dialog contains two three sections The top panel contains host name and an option to customize the new Telid instance label in the teiid view The second panel Telid Admin Connection Info pertains to the connection information required to connect to the admin URL of your installed Teiid instance The operations Designer exposes deal with deploying and undeploying VDBs as well as managing your test data sources required by those VDBs to successfully connect and query data through the T elid runtime engine The third panel Telid JDBC Connection Info provides for entering the connection information for that same Teiid instance This information is required for Designer to make JDBC connections during execution of the Preview Data feature Enter valid Host Port User name and Password information edit any options and click Finish 221 JBoss Enterprise Data Services 5 Telid Designer User Guid
176. ile Validation Problems amp One or more selected WSDL files have errors Please correct or remove the filel sito proceed WSDL Validation Panel message wsdl file X cvc elt 1 Cannot find the declaration of element wsdl definitions http terraservice net terraservice2 asmx wsdl Cancel Figure 5 56 WSDL Validation Problems Dialog 5 8 3 Import WSDL From URL You can create a Web Service model by selecting a WSDL file based on a URL Step 1 Choose the File Import choose the File gt Import action t in the toolbar or select a project folder or model in the tree and choose Import Step 2 Select the import option Telid Designer gt WSDL File or URL gt gt Web Service Model and click Next gt Step 3 Input a valid name for your Web Service model and select the URL button Enter a valid WSDL URL If the URL cannot be validated then an error will be displayed and the OK gt button disabled If the WSDL is protected by basic HT TP authentication then this option should be selected and the appropriate username and password entered Click OK gt to continue Click Next gt to continue 107 JBoss Enterprise Data Services 5 Teiid Designer User Guide 108 WSDL URL Enter WSDL Url http terraservice net terraservice2 asmx wsdl Security Type HTTPBasic User Name fus er Password leeee Cancel Figure 5 57 WSDL URL Dialog s If no WSDL is selected or specifie
177. ile and Target Relational Model Select CSV Ale to Import and Destination Model or model folder Select Source Text Ale Laas Browse Target Location Customerlnfo xmi Browse Ale Contents Options Use default datatype string 255 vi Ani 5 h Figure 5 34 Select Source Text File and Target Relational Model 89 JBoss Enterprise Data Services 5 Telid Designer User Guide Step 5 Select an existing relational model as the target location for your new relational components using the Browse button to open the Relational Model Selector Dialog Select a relational model from your workspace or specify a unique name to create a new model Step 6 Select any additional options and choose Finish 5 6 3 Import Relational View Tables CSV Format To create relational virtual tables from imported text file metadata Perform Steps 1 through 3 above and select the Relational Virtual Tables CSV Format import type then click Next gt T import Metadata From Text File Select Import Type Select the type of text file import desired Import Type Relational Virtual Tables WF Purpose Imports virtual relational tables and procedures from a CSV text file into a relational virtual model Table data is expected to be of the form gt gt TableName SOL Statement Description A sample of typical input data is shown below Sample Ale Format SELECT FROM PMod1 PTabl PMod1 PTable2 Descri
178. include SQL Support Guide and Eclipse Overview information Teiid Designer PartsProject PartsSourceA xmi Boss Developer Studio Ale Edit Refactor Navigate Search Project Metadata Run Window Help Figure C 63 Application Main Menu C 4 1 File Menu The File menu provides actions to manage your workspace resources 258 Edit Refactor Navigate Search New Open Ale Ctrl w Shift Ctrl w Close Close All Ctrl 5S Shitt Ctril S Refresh Convert Line Delimiters To Print Switch Workspace Restart gg Import p Export Properties 1 PartsSourceA xmi PartsProject 2 Parts vdb PartsProject 3 PartsSourceB xmi PartsProject Exit Figure C 64 File Menu Alt Enter Tetid Designer PartsProject Parts Project Me Shift Alt N gt Teiid Designer UI Reference The New gt sub menu provides specific actions to create various generic workspace resources as well as Telid Designer models and VDBs Edit Refactor Navigate Search Shift Alt N gt Open Ale Ctrl w Shift Ctril w Close Close All Ctrl S Shift Ctril 5 Figure C 65 File Menu Project Metadata Run Window Help Teiid Model Project F Project C Folder Teiid Metadata Model A Teiid VDB F Example c Other Ctril N 259 JBoss Enterprise Data Services 5 Teiid Designer User Guide The File menu contains the following actions New gt Model Project Create
179. ion Reconciler dialog lf Save Diagram as Image Save the diagram image to file in JPG or BMP format Modify Diagram Printing Preferences Modify page layout information for printing diagrams Includes margins orientation etc Context menus for Mapping Transformation Diagrams identical capabilities to the Transformation Diagram with the addition of managing and editing Input Sets C 3 1 2 Table Editor The Table Editor provides a table based object type structured view of the contents of a model The figure below shows a relational model viewed in the Table Editor Common object types are displayed in individual folders tables All base tables for instance are shown in one table independent of their parentage 245 JBoss Enterprise Data Services 5 Telid Designer User Guide Base Tables Fj Columns Location Name Name In Source System Cardinality Supports Up Materialized Logical Relat Materialized Object URI PARTS PARTS false 16 true false SHIP_VIA SHIP_VIA false 3 true false STATUS STATUS false 3 true false SUPPLIER SUPPLIER false 16 true false SUPPLIER_PA SUPPLIER PARTS false 227 true false ta Package Diagram Table Editor Figure C 43 Table Editor Example You can customize Table Editor properties via Table Editor Preferences These are the primary features of the Table Editor Edit existing properties Add remove or edit objects via the main Edit menu and
180. ion for that argument The nested function displays in the tree beneath your root function and its arguments display as well Using the Expression Builder and nested functions you can create complex logic within your query transformations 6 2 2 Input Set Editor XML The Input Set represents a special class that contains attributes from a parent mapping class When you create mapping classes for an XML Document model the Teiid Designer automatically adds an Input Set to all XML transformation diagrams for mapping classes beneath the highest node in the Document meta object The Input Set proves especially useful for information integration using the Telid Designer Server Through the Input Set you can access a row of data generated by any XML transformation in a mapping class higher in the XML document s hierarchy You can use Input Set attributes which are individual columns from the rows of data within the criteria of an XML transformation query of the child mapping class 136 Chapter 6 Creating and Editing Model Objects You cannot use the Input Set attributes within the SELECT portion of the XML transformation query To use an Input Set you must use the Input Set Editor to bind attributes from parent classes Once you have created an Input Set you can use the attributes within it as source material for the XML transformation diagram s query The Input Set only serves to enable data flow between nested mapping classes If you
181. ise Datatypes Adds an additional property to simple datatypes within your selected schema model to label them as enterprise datatypes Show Model Statistics Opens the Model Statistics dialog for the selected model Build Model Imports Reconciles all model import dependencies for the selected model C 4 8 Run Menu Telid Designer currently does not contribute actions to the Run menu See Eclipse documentation for details FN External Tools gt Figure C 73 Window Menu C 4 9 Window Menu The Window menu shown below contains no Telid Designer specific actions See Eclipse Workbench documentation for details 265 JBoss Enterprise Data Services 5 Telid Designer User Guide New Window New Editor Open Perspective gt Show View gt Customize Perspective Save Perspective As Reset Perspective Close Perspective Close All Perspectives Navigation gt Preferences Figure C 74 Window Menu The Preferences action launches the Preferences dialog which can be used to set preferences and default values for many features of Telid Designer Note that these menu items may vary depending on your set of installed Eclipse features and plugins If you wish to customize a perspective to include one or more Telid Designer views select the Show View gt Other action and expand the Teiid Designer category to show the available views Show View gt Team Teiid Designer
182. isplayed showing your new tables 83 JBoss Enterprise Data Services 5 Teiid Designer User Guide Ca AccountsSFModel xmi 3 m eee ZERO TO manv ee FA Accountld stringi l aa EJ Accounthrs J UserOrGroupld string 18 F AccountAccessLevel string 40 E OpportunityAccessLevel stringl40 FS CaseAccessLevel string 40 FK_ Account Accountld ZERO TO MANY E ContactAccessLevel string 40 E RowCause string 40 oat FI FK Accoun EJ IsDeleted boolean FK Accoun Id PK FK Account AccountFromid AccountTo EJ Opportuni ZERO_TO_MANY Role strii IsPrimary IsDeleted F FK_Account_Accountld F Id PK fj id string 18 EJ IsDeleted boolean E MasterRecordld string 18 E Name string 255 Ff Type stringl40 EJ Parentld string 18 E BillingStreet string 2 55 E BillingCity string 40 rea meth week lL E GOOO I n ta Package Diagram E Table Editor Figure 5 28 New Saleforce Tables Diagram 5 6 Import Metadata From Text File The Teiid Designer provides various import options for parsing comma delimited text file metadata into models This is accomplished via the Import gt Teiid Designer gt Designer Text File gt gt Source or View Models option a Step 1 In Designer choose the File gt Import action and choose Import a Step 2 Select the import option Telid Designer gt Designer Text File gt gt Source or View Models and click Next gt Step 3 Select
183. issing properties in Web Service Generation Wizard shown below Step 4 Click Finish to generate model When model generation is complete a confirmation dialog should appear Click OK Users can change the Web Service Model and Interface Name values via buttons to use existing Web service model components This will create a new operation in an existing model 56 Chapter 5 Importers Chapter 5 Importers The Import Wizard provides a means to create a model based on the structure of a data source to convert existing metadata i e WSDL or XML Schema into a source model or to load existing metadata files into the current VDB To launch the Import Wizard choose the File gt Import action or select a project folder or model in the tree and right click choose Import Select Choose import source Select an import source gt amp Plug in Development gt E Run Debug gt 2 Team f Teiid Designer DDL Ale gt gt Source or View Model Designer Text Ale gt gt Source or View Models Eyr Ale Source Flat gt gt Source and View Model Eyr Ale Source XML gt gt Source and View Model JDBC Database gt gt Source Model iy Salesforce gt gt Source Model WSDL Ale or URL gt gt Source Model WSDL Ale or URL gt gt Web Service Model S XML Schemas gt E XML Cancel Figure 5 1 Import Wizard 5 1 Import DDL Source relational models can be created by importing DDL You can cre
184. itor is not currently open for the selected object s model a Model Editor will be opened After the corresponding transformation diagram is opened in the Diagram Editor the Transformation Editor is displayed in the lower section of the Diagram Editor 123 JBoss Enterprise Data Services 5 Telid Designer User Guide Transformation Editor at Ey Cursor at 1 1 C Supports Update Eh SELECT PartsSourceA SUPPLIER_PARTS SUPPLIER_ID PART ID QUANTITY SHIPPER_ID SUPPLIER _NAME SUPPLIER_STATUS SUPPLIER_CITY SUPPLIER_STATE FROM PartsSourceA SUPPLIER PARTS PartsSourceB SUPPLIER WHERE PartsSourceA SUPPLIER_PARTS SUPPLIER_ID PartsSourceB SUPPLIER SUPPLIER _ID Figure 6 13 Editing String Property If this virtual class Supports updates the tabs on the bottom of the Transformation Editor allow you to enter SQL for each type of query this virtual class supports If this virtual class does not support updates only the SELECT tab is available You can enter separate SQL queries on each available tab to accommodate that type of query Within the Transformation Editor you can Disable specific update transformation types on this virtual class Start your transformation with a provided SQL Template Build or edit a criteria clause to use in your transformation Build or edit an expression to use in your transformation Find and replace a string within your transformation Validate the transformation to ensure its content contains no err
185. k database uses a nine character string that represents the ZIP Plus Four The transformation could perform any SQL supported logic upon the ZIPCode column to substring this information into the format we want for the Address Pool View metadata model 2 3 6 3 3 Mapping XML Transformations When you model View Metadata you can also create a View XML Document model This View Document lets you Select information from within your other data sources just like a regular View Metadata model but you can also map the results to tags within an XML document In this example the Address Pool View Metadata model still selects its information from the Address Book Database and the Vendor Text File but it also maps the resulting columns into tags in the Address XML document 2 4 It s all in the Modeling 2 4 1 What Are Models A model is a representation of a set of information constructs A familiar model is the relational model which defines tables composed of columns and containing records of data Another familiar model is the XML model which defines hierarchical data sets In Teiid Designer models are used to define the entities and relationships between those entities required to fully define the integration of information sets so that they may be accessed in a uniform manner using a single API and access protocol The file extension used for these models is xmi Example NorthwindOracle xmi which adheres to the XMI syntax defined by
186. kikkkkbkkbkkkkkkkkkkirere Figure C 61 Text Field With Error The MED sub editors share a header section The header is composed of the following Status Image an image indicating the most severe validation message error warning or info If there are no validation messages the model extension image is shown Title the title of the sub editor being shown Menu a drop down menu containing actions for 1 adding to and updating the MED in the registry and 2 for showing the Model Extension Registry View Validation Message this area will display an OK message or an error summary message When a summary message is shown the tooltip for that message will enumerate all the messages Toolbar contains the same actions as the drop down menu Below is an example of the shared header section which includes an error message tooltip 257 JBoss Enterprise Data Services 5 Telid Designer User Guide ti l ili i l h L m TERET nahk Tm a SS i DEL EE LAE wa Me os St eek OE ia a a em E m ia TI mmn __ aa e mm e e m m M p a EE a ir A rr 2 e m pree wa So ae gAn e TI e ee eee e m rEE Se oon lt lt SEE a a i C 4 Telid Designer Main Menu There are 8 categories of actions on Teiid Designer s main menu bar These categories
187. l be opened in a Model Editor Editing a property value for instance will require an open editor prior to actually changing the property Any number of editors can be open at once but only one can be active at a time The main menu bar and toolbar for Teiid Designer may contain operations that are applicable to the active editor and removed when editor becomes inactive Tabs in the editor area indicate the names of models that are currently open for editing An asterisk indicates that an editor has unsaved changes 237 JBoss Enterprise Data Services 5 Teiid Designer User Guide Cia PartsSourceA xmi Q Parts vdb Figure C 34 Editor Tabs By default editors are stacked in the editors area but you can choose to tile them vertically and or horizontally in order to view multiple models simultaneously Ga PartsSourceA xmi n GA PartsVirtual xmi 53 amp Ir l E Sa ee el E 3 ge al A A A A A A A Descriptio Model Model Synchronized Visible Source Name Translator INDI Name Description Ca PartsSourceA xmi PartsProject PartsSourceA Ca PartsSourceB xmi 2 PartsProject sqlserver PartsSourceB GR PartsVirtualxmi PartsProject Remove Other File MDB Data Role Ale Path Synchronized Description Data Role Description Add Remove Synchronize All Figure C 35 Viewing Multiple Editors The Telid Designer provides main editor views for XMI models and VDBs
188. layed by the system Aside from standard usage for presenting the title of a work italics denotes the first use of a new and important term For example Publican is a DocBook publishing system 1 2 Pull quote Conventions Terminal output and source code listings are set off visually from the surrounding text Output sent to a terminal is set in mono spaced roman and presented thus books Desktop documentation drafts mss photos stuff svn books_tests Desktop1 downloads images notes scripts svgs Source code listings are also set in mono spaced roman but add syntax highlighting as follows Preface package org jboss book jca ex1 import javax naming InitialContext public class ExClient public static void main String args throws Exception InitialContext iniCtx new InitialContext Object ref iniCtx lookup EchoBean EchoHome home EchoHome ref Echo echo home create System out println Created Echo system out println Echo echo Hello echo echo Hello 1 3 Notes and Warnings Finally we use three visual styles to draw attention to information that might otherwise be overlooked Note Notes are tips shortcuts or alternative approaches to the task at hand Ignoring a note should have no negative consequences but you might miss out on a trick that makes your life easier po on Important Important boxes detail things that are easily missed configuration changes that only
189. ld Datatypes Description w Metadata Favorites a Model Explorer aH Relationship Nawigator at System Catalog Tags tae Teiid wh Teiid Model Classes Cancel Figure C 75 Show View Dialog C 4 10 Help Menu The Help Menu shown below contains no Teiid Designer specific actions See Eclipse Workbench 266 Teiid Designer UI Reference documentation for details Welcome Help Contents co Search Dynamic Help Key Assist Shiftt Ctri l Tips and Tricks Cheat Sheets Project Examples Report Problem Red Hat Web Site Check for Updates Install New Software About JBoss Developer Studio Figure C 76 Help Menu The individual actions are described below Welcome Shifts to the Welcome perspective which contains links to documentation examples and how to starting points Help Contents 2 Launches the Help Window All of Designer s online documentation is accessible from there as well Search 2 Launches the Help Search view which can be used to search for phrases in the documentation Dynamic Help Opens the docked dynamic help view Key Assist Ctrl Shift L Launches a dialog describing existing key assist bindings Tips and Tricks Launches a dialog to select one of any contributed Tips and Tricks help pages Cheat Sheets Launches a dialog to select one of any contributed Eclipse cheat sheets Project Examples A JBoss contributed action w
190. le Dialog e Step 5 Select Next to view a summary of your new Telid Connection Profile 197 Summary JBoss Enterprise Data Services 5 Teiid Designer User Guide Tetid Profile Wizard Information gathered from previous pages Property N g mi e Description Value l Products Auto connect at startup false Auto connect on finish true Database Host Port Username SSL protocol Save password URL Products localhost 31000 admin false true jdbe teiid Products mm localhost 31000 Cancel Finish Figure 9 17 Teiid Connection Profile Summary a Step 6 Select Finish a Step 7 Select your new Telid connection profile and right click select Open SQL Scrapbook enter your designer SQL i e SELECT FROM T ableXXXX select all text and right click select Execute Selected Text Connection profile e Teid 7 1 a J Parts vdb E Parts Teiid Connecti gt Database gt Status Connected Auto Con SELECT FROM PartsSourceA Parts A Figure 9 18 SQL Scrapbook Editor e Step 8 Results of query should be displayed in the SQL Results view on the Result1 tab Chapter 9 Testing Your Models SOL Results 1 a x ie 7 E Type query expression here Status Operation Date Connection Profile lt Succee SELECT FROM PartsSourceA Parts Oct 15 2010 Parts Teiid Connection PART NAME PART COLOR PART WEIGHT Nut Red 12 2 Bolt 2 Green 2 12 2 Screw Blue 2 13
191. le applied to the contents of the column not the contents themselves The second of course represents some business information about the way the column was populated This information although useful to associate with our definition of the column does not reflect the physical storage of the data 2 3 5 Design Time and Runtime Metadata Telid Designer software distinguishes between design time metadata and run time metadata This distinction becomes important if you use the Telid Designer Server Design time data is laden with details and representations that help the user understand and efficiently organize metadata Much of that detail is unnecessary to the underlying system that runs the Virtual Database that you will create Any information that is not absolutely necessary to running the Virtual Database is stripped out of the run time metadata to ensure maximum system performance 18 Chapter 2 Introduction 2 3 5 1 Design Time Metadata Design time metadata refers to data within your local directory that you have created or have imported You can model this metadata in the Telid Designer adding Source and View metadata 2 3 5 2 Runtime Metadata Once you have adequately modeled your enterprise information systems including the necessary technical metadata that describes the physical structure of your Sources you can use the metadata for data access TO prepare the metadata for use in the Telid Designer Server you take
192. lell JDBC Metadata Processor Oracle Properties Driver Oracle 11 Thin Driver URL jdbc oracle thin db0025 www mydb com 1521 db25 User Name partssupplier Password ok Next gt Cancel Anish Figure 5 5 Select JDBC Source Configuration Dialog e Step 5 On the Select Database Metadata page select the types of objects in the database to import Press Next gt or Finish if enabled 61 JBoss Enterprise Data Services 5 Teiid Designer User Guide Import Database via JDBC Select Database Metadata Press the Next gt button to continue or the Anish button to finish Foreign Keys Table Types Indexes SYNONYM Unique Only Approximations Allowed Procedures z Back Cancel Finish Figure 5 6 Select Database Metadata Dialog a Step 6 On the Select Database Objects page view the contents of the schema or change selections Select which database schema objects will be used to construct relational objects Press Next gt or Finish if enabled 62 Chapter 5 Importers Import Database via JDBC Select Database Objects Select the objects to import from database PartsOraclell ParteOraclell Columns Imported Foreign 40 TABLE CAT TABLE SCHEM TABLE NAME COLUMN NAME DATA TYPE PARTSSUPPLIER PARTS PART ID PARTSSUPPLIER PARTS PART NAME PARTSSUPPLIER PARTS PART COLOR PARTSSUPPLIER PARTS PART WEIGHT vw PARTS SUPPLIER v TABLE SHIP_VIA STATUS SUPPLIER
193. loyed data sources on your Teiid server but if you wish to test your VDB the data sources need to be present Telid Designer provides a Create Data Source action so you can create compatible data sources for your source model If you wish to create a data source for a specific model you can select that source model in your workspace and select the Modeling gt Create Data Source action This will extract the connection profile data from your source model and create a corresponding data source on your default Telid server You can also create data sources from the T elid view Select a Telid server instance in the Telid view and right click select the Create Data Source action This will launch the Create Data Source Dialog shown below 192 Chapter 9 Testing Your Models Create Data Source Create Data Source All inputs are valid Select Anish to create data source Teiid Server mm fflocalhost 31443 Name BooksDB2 Connection Source Use Model Connection Info Model Use Connection Profile Info Connection Profile pooksDR Connection Properties Value password Poi user name books connection url jdbc db2 db000255 org mydbs com 50000 driver class com ibm db jcc OB2Driver Figure 9 10 Create Data Source Dialog You can either select and existing Connection Profile from the drop down list Use Connection Profile Info option or check the Use Model Info option and select an existing source model
194. ls By default the symbols are shown in the order that they appear in the SQL query To show them alphabetically in the list click the Sort button Binding Controls The Binding Controls are located between the Attribute Symbol table and the Unmatched SQL Symbols list Use these buttons to define the Attribute Symbol bindings Here are a few things you can do with the binding controls Bind This button will Bind an SQL Symbol to a target attribute Select an Unmatched SQL symbol and select a target attribute then click Bind to establish the binding Unbind This button will Unbind an Attribute Symbol binding Select an already bound attribute in the table then click Unbind The SQL Symbol will be released to the Unmatched Symbols list New This button will create a new target attribute using an Unmatched SQL Symbol Select an Unmatched Symbol from the list then click New A new target attribute will be added to the bottom of the Attribute Symbol table bound to the selected SQL symbol Null This button allows you to bind null to a target attribute instead of binding an SQL Symbol to it Select a row in the Attribute Symbol table then click Null The target attribute will be bound to null If it was originally bound to an SQL Symbol the symbol will be released to the Unmatched Symbol list Function This button allows you to define an expression instead of just an SQL Symbol for the binding To define
195. lues To search your models using metadata Step 1 Select Search gt Metadata action on the main Telid Designer toolbar which opens the Search dialog Step 2 Specify desired search options for Object Type Data Type and Properties Step 3 Click Search The search will be performed and the results will be displayed in the Search Results View If the view is not yet open it will be opened automatically 201 JBoss Enterprise Data Services 5 Telid Designer User Guide Supported Data Sources The matrix indicates for a given data source how a model can be created Desginer Import Option and how the data source is integrated Translator for data access NOTE The DDL Import option is an available option to build a source model for any data source Its only indicated below when there s no specific importer created for that specific data source type 202 Table A 1 Telid Designer Supported Data Sources DELEC Me lelelger Apache Derby Files General JDBC HDFS Hadoop HSQL H2 Ingres IBM DB2 Informix LDAP ActiveDirectory LoopBack MetaMatrix ModeShape JCR Mondrian MS Access MS Excel MS SQL Server MySQL Netezza Oracle PostgreSQL Salesforce com SAP Gateway SAP R 3 SAP Services Registry Sybase ASE Teradata Telid Web Services SOAP WSDL Web Services Rest OData Translator Type JDBC derby file JDBC jdbc simple hive JDBC hsql JDBC h2 JDBC ingres Ingres 2006 or l
196. me Clone A sample context menu for a relational base table is shown below New Child New Sibling New Association Modeling P Undo Delete multiple objects of Cut Copy Clone Copy Name Delete Rename Link Types Go Refresh Diagram Show Parent Diagram a Save Diagram To Ale Page Setup Show Page Grid Input Methods Ctrl x Ctr c h 1 a gt Figure C 38 Package Diagram Context Menu C 3 1 1 2 Custom Diagram Teiid Designer UI Reference The Custom Diagram represents a view of user defined model objects Unlike Package Diagrams Custom Diagrams can contain objects that are not only unrelated but can be from different containers and even models 241 JBoss Enterprise Data Services 5 Telid Designer User Guide Cg PartsOraclell xmi 23 IA PartsView xmi 3 gt E PartsOraclell PartsOraclell PART ID string 4 E PART NAME string 255 3 E SUPPLIER ID string 10 Y PART_COLOR string 30 PK_PARTS EJ PART ID stringl4 PART WEIGHT string 255 EY QUANTITY bigdecimal FR_SPUIER PRIS PRIS MA SHIPPER ID bigdecimal S PK_PARTS F FK_SPLIER_PRTS_SPLY F FK_SPLIER_PRTS_PRTS F PK_SUPPLIER_PARTS EDE ES EEA eee Custom Diagram E Table Editor Figure C 39 Custom Diagram Example Custom Diagram toolbar actions include amp Refresh Diagram Re draws diagram Show Parent Diagram Navigates to diagram for pa
197. mine the REST mapping of this procedure Supported methods are GET PUT POST and DELETE The resource path to the procedure For example if you use books isbn as your URI value for a procedure http host port war_context model_name books 123 would execute this procedure and pass 123 in as a parameter Here s what the above example would look like in the Property tab Property Value VExtension SSeS rest Rest Method GET rest URI books fisbn z Note that the generated URI will have the model name included as part of the path so full URL would look like this http host port war_context model_name books 123 If you wanted a REST service to return all books you would write your procedure just as it is above but remove the input parameter The URI property would then just be books or whatever you want and the URL would be http host port war_context model_name books Once you have added all of your procedures along with the required extended properties be sure and add the model to your VDB or synchronize if it s already included in the VDB You will then need to re deploy the VDB 175 JBoss Enterprise Data Services 5 Teiid Designer User Guide Sy Important If you redeploy your VDB during development you may receive an Invalid Session Exception due to a stale connection obtained for the pool This can be corrected by flushing the data source or alternatively you
198. mmary of the context menu actions 125 JBoss Enterprise Data Services 5 Telid Designer User Guide Cut Copy Paste Typical text editor actions to cut copy or paste text within the editor Undo Redo Allows you to Undo or Redo the previous action Find Displays a Find Replace Dialog which allows you to search and replace text within the transformation Apply Template Displays the Choose an SQL Template Dialog which allows you to choose a 6 2 1 1 Using the Reconciler The Transformation Editor s Reconciler offers you a quick graphical means to reconcile the Target View attributes and the Transformation SQL As you make changes the overall status will appear at the top of the dialog to assist you in successfully completing your edits To launch the Reconciler click on the Reconcile Transformation button 3 in the Transformation Editor The Reconciler Dialog is shown below Reconcile Virtual Target Attributes Reconciler Status B The SQL contains unmatched symbols Remove them or create new attributes SCOPE Reconciling Query Unmatched SOL Symbols Note The data types shown are the runtime data types PART ID QUANTITY Target Locked L Tara SHIPPER_ID Attribute SQL Bindings Virtual Target Attributes SOL Symbol BI SUPPLIER_ID string EJ SUPPLIER_NAME string El SUPPLIER_STATUS bigdecimal EJ SUPPLIER_CITY string EI SUPPLIER_STATE string EJ PARTID strin
199. model If no tables in that model contain a PK or UC then the table will be empty 157 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Foreign Key Create Foreign Key Enter valid name select a key or constraint select colurnn references and press OK Name FK Supplier Name In Source FK Supplier Foreign Key Multiplicity Unique Key Multiplicity Select Primary Key or Unique Constraint P Table A PK_A E Table A UCA Pl BEBB PK_BB BEBE UC BBB E TABLE X PKA Select Column References To FK C name L category L quantity Cancel Figure 7 10 Create Foreign Key Dialog 7 2 Relational View Modeling This section contains descriptions of various features related to creating and managing relational view model objects 7 2 1 Create Materialized Views For any relational view table you can enable it s materialized view option by setting the Materialized property to TRUE and setting the Materialized Table reference as shown in the figure below Note that you are required to have already created your relational tables 158 Chapter 7 Metadata specific Modeling E Properties Mi Description 9 Tags Kal E E Pr Property Value 0 iten Desc Misc Cardinality Ti 0 Logical Relationships Materialized Ir true If true the table can be materialized cached Only applies to virtual tables Materialized Table E PARTS Path PartsTest Mate
200. model objects contained in your models 6 1 Creating New Model Objects As discussed in the introduction Telid Designer provides a framework to model various types of metadata Each metamodel type has a set of parent child relationships that establish constraints on what can be created and where You cannot for example create a column attribute in a stored procedure nor can you create a mapping class column in a Web service operation s output message The Telid Designer provides a common set of actions to create new children of these models as well as children of children You can create new model objects directly in the Model Explorer view Diagram Editor or T able Editor using the following actions New Child Action New Sibling Action New Association Action 6 1 1 New Child Action Step 1 Select the parent object to which you want to add a child For example you can add a package to a package or an attribute to a class Step 2 Right click on a container object From the pop up menu select New Child You can now select the child object you would like to add 7 TE TwoSourceParts lt v Og PartsDB2 xmi b import declarations 2 Ha Package Diagram New Child gt E Access Pattern ew Siblin gt status nae s E Column ew Association CE gt E SUPPLIER E Foreign Key Modeling gt gt E SUPPLIER gt O Data Sour W Unique Constraint gt Og PartsSOLxm Figure 6 1 New Child Action In Model E
201. my model extension overview Properties Souree S S lt W Figure C 59 Overview Tab Properties Sub Editor this editor is where the MED extension properties are managed Each extension property must be associated with a model object type The Properties sub editor is divided into 2 sections Extended Model Objects and Extension Properties and looks like this 256 Teiid Designer UI Reference mymxd mxd 3 7 zy Properties BE Extended Model Objects Ta oF x5 Manage the extended model objects that have extension properties Baselable Extension Properties 6 Manage extension properties for each extended model object ID Runtime Type Required Modifiable Advanced Masked Indexed Default Value Fixed Value Allowed Values Display Name Descript copyable boolean val true false Copyable Indicat Overview Properties Source Figure C 60 Properties Tab Source this tab is a read only XML source viewer if you wish to view the details of your MED This source viewer is NOT editable The GUI components on the Overview and Properties sub editors will be decorated with an error icon when the data in that GUI component has a validation error Hovering over an error decoration displays a tooltip with the specific error message Those error message relate to the error messages shown in the common header section Here is an example of the error decoration PE bhhbibkkkbkbkkbikkkkkkbk
202. n the dropdown then the related actions for the selected category are displayed in the list below it Execute an action by clicking the Execute selected action link or double clicking on the action The lower Cheat Sheets section provides a list of available Cheat Sheet links which will launch the appropriate Cheat Sheet to guide you step by step through the selected process C 2 14 Status View To open Teiid Designer s Status view select the main menu s Window gt Show View gt Other and select the Telid Designer gt Status view in the dialog The Status view provides a quick overview status of the selected project Asample Status view for a project is shown below 235 JBoss Enterprise Data Services 5 Telid Designer User Guide A Guides W4 Status s F Project Status Enable Unange project Project TestProj Source Connections Sources XML Schema Views VDES Model validation OFF Test EECA A R Figure C 32 Status View The status view is broken down into common project areas Source Connections all Source Connections are fully defined Sources Source Models exist XML Schema XML Schemas exist Views View Models exist VDBs VDBs exist and are deployable Model Validation Status all Models pass validation Test all defined VDBs pass validation The status of each area is denoted by an icon A green check indicates OK a red x indicates errors and a warni
203. nd Test Designer Folder example files wsdls OnHand wsdl Cancel Anish Figure 5 52 Namespace Resolution Dialog e Step 5 The next page WSDL Operations Selection allows customizing the resulting content of your Web Service model by selecting deselecting various operations and interfaces in the following dialog 104 Chapter 5 Importers Create Relational Model from Web Service WSDL Operations Selection Press the Anish button to finish Select the desired WSDL Operations Ww Ja Share_BSM Real Time Data Design Server RealTimeData_portService ka Share BSM Real Time Data Design_Server_RealTimeData_portPort ad am Share BSM Real Time Data Design Server RealTimeData portBinding OnHand Selection Details nHand Operation id http dladbO7 Share BSM Real Time Data Design Server RealTimeData p input message _OnHandinput output message OnHandOutput fault names none lt Back Cancel Finish Figure 5 53 Namespace Resolution Dialog Step 6 The next page is titled Schema Workspace Location Selection This page lists all schemas imported by the WSDL along with any dependent schemas referenced within schemas as well as schemas embedded in the WSDL and indicates whether or not they are resolvable All resolved schemas will be created in a separate file and added to the workspace The editor panel allows you to change the default file name of the new schema file s If no errors select Next to proceed or Finish
204. ng icon indicates potential problems The project can be changed by selecting the Change Project button C 2 15 Cheat Sheets View To open Cheat Sheets view select the main menu s Window gt Show View gt Other and select the Help gt Cheat Sheets view in the dialog The Cheat Sheets view is a standard Eclipse Help concept Cheat Sheets provide step by step assistance for common process workflows Telid Designer has contributed to the Eclipse help framework to provide assistance for many common modeling tasks The Guides View see Cheat Sheet is shown below 236 Teiid Designer UI Reference a hes Lahestsa yoo Create Model from JDBC Source vo Introduction This cheat sheet shows you how to create a model from a JDBC source Click to Restart Create New Teiid Model Project Follow the steps below to create a Telid Model Project Launch New Teiid Model Project Wizard 1 Specify unique project name w 2 Click Next gt twice to get to Model Project Options page 3 Check folders you wish the wizard to create in your project 4 Click Finish Create New JDBC Source Connection Create Source Model From JDBC Connection Test JDBC Source Data Create VDB t Test VDB Figure C 33 Cheat Sheet Sample C 3 Editors Editors are the UI components designed to assist editing your models and to maintain the state for a given model or resource in your workspace When editing a model the model wil
205. ns for improvement Additional information Be sure to give us your name so that you can receive full credit for reporting the issue 10 Chapter 1 The Enterprise Data Services Platform Chapter 1 The Enterprise Data Services Platform 1 1 Data Integration Businesses increasingly need to access data residing in multiple disparate data sources Therefore we need to consider ways of making this information readily available for them to use Data integration provides a unified virtualized view of information combined from multiple disparate sources This enables users and applications to query and manage the integrated data as if it were located in a single database via a single uniform API Instead of copying or moving data a virtual database VDB is used to map physical data sources to integrated views At runtime queries submitted against these views are coordinated among the dependent physical data sources according to query criteria and the mappings defined by the VDB This approach minimizes information flow and avoids inconsistencies from duplication of data Data integration hides details about the physical data sources such as location structure API access language and storage technology This allows for more effort to be spent on data analysis and manipulation rather than on technical issues regarding the physical separation of the data 1 2 Enterprise Data Services JBoss Enterprise Data Services EDS is a data in
206. ns for the choice each represented by the top node of the document fragment The Summary tab shown below displays an SQL like version of the current choice criteria Choice Editor bookSetMixed choice Default 3 audiobook 1 hardcoverBook AudioBooks bookSethixedDocument Mappingclasses bookSetMixed TYPE Hardback 2 softcoverBook UCASE audiobooks bookSetMixedDocument Mapping Classes bookSetMixed TYPE LIKE SOF 3 audiobook AudioBooks bookSethixedDocument MappingClasses bookSetMixed TYPE IN Books on Tape Books on 8 Track Audio Books on CD Default 3 audiobook Edit Summary Figure 6 29 Choice Criteria Summary 138 Chapter 6 Creating and Editing Model Objects 6 2 3 1 Using the Choice Editor You should address each choice option by performing one of the following Specify a criteria statement for the Telid Designer Server to apply in order to determine which elements or elements to insert into the result document Exclude or include the option s fragment from the document Set the elements criteria test order Set a default action that occurs if none of the criteria you set is met 6 2 3 2 Excluding Fragments The XML Schema upon which you based the XML Document model determines the nature of the options available to the choice Aschema you share with other external sources Such as business partners might include information that you do not want to inclu
207. of the SELECT symbols The button will enable only if the cursor is within a query that contains a SELECT clause that can be expanded A Increase Font Size increases the font size of all editor text by 1 4 Decrease Font Size decreases the font size of all editor text by 1 Show Hide Messages toggles the display of the message area at the bottom of the transformation editor Optimize SQL when toggled ON will use the short names of all SQL symbols that can be optimized Some symbol names may remain fully qualified in the event of a duplicate name or if the optimizer is unable to optimize it When the action is toggled OFF all symbol names will be fully qualified res Import SQL Text allows you to import an SOL statement from a text file on your file system Pressing this button will display an import dialog in which you can navigate to the file bii Export SQL Text allows you to export the currently displayed SQL statement into a text file on your file system Pressing this button will display an export dialog in which you can choose the location for export Close X closes the transformation editor The Transformation Editor context menu can be displayed by clicking the right mouse button within the editor s text area The context menu is show below Transformation Editor of ERROR SOL SELECT UPDA fault DELETE Figure 6 14 Transformation Editor context menu Following is a Su
208. on controls Apply Button If the suggested CONVERT function is acceptable click Apply to apply the CONVERT function to the SQL Symbol Convert All Button If you wish to apply a CONVERT function to all of the SQL Symbols in the table so that their datatype is compatible with the corresponding attribute datatype click the Convert All button Once you are finished resolving datatypes click OK to accept the changes You are directed back to the Reconciler Dialog which will be updated to reflect your edits 6 2 1 3 Using the Criteria Builder The Transformation Editor s Criteria Builder offers you a quick graphical means to build criteria clauses in your transformations based on meta objects in your diagram If you launch the Criteria Builder with your cursor within an existing criteria in your transformation SQL the builder will open in Edit mode If your cursor is not in an existing criteria location the builder will open in create mode and allow you to create it from scratch This procedure provides an example of building a criteria clause using the Criteria Builder When building your own criteria you can mix and match the values and constants with whatever logic you need to build powerful and complex criteria To use the Criteria Builder Step 1 In the Transformation Editor click the Launch Criteria Builder button Step 2 The Criteria Builder displays JBoss Enterprise Data Services 5 Teiid Designer User Guide
209. onal Model from Web Service Procedure Definition Press the Finish button to finish Operations CapitalCity a St O Overwrite existing procedures for this operation Response Wrapper Procedure Generated Procedure Name CapitalCity response BODY HEADER Schema Contents Column Info eee v e CapitalCityResponse Root Path ns CapitalCityResponse w res SEQUENCE B CapitalCityResult ig string Ordinality Data Type Defaul TEn SOL Statement CREATE VIRTUAL PROCEDURE BEGIN SELECT t FROM Figure 3 27 Consume SOAP Wizard On the Response tab select the Body sub tab In the Schema Contents select the CapitalCityResult then click the Add button This will add the selected element to the response Select the Wrapper Procedure tab to see the full Generated Procedure SQL as shown below 48 Chapter 3 Start Here fe Create Relational Model from Web Service Procedure Definition Press the Finish button to finish Operations Capitalcity Overnwrite existing procedures for this operation Request Response Wrapper Procedure Generated Procedure Name Generated SOL Statement CREATE VIRTUAL PROCEDURE BEGIN SELECT t FROM TABLE EXEC CountrylnfoServiceView CapitalCity_reguest CountrylnfoServiceView CapitalCity sCountrylSOCode AS request TABLE EXEC CountryInfoService invoke SOAP11 null REQUEST xml_out null AS response TABLE EXEC CountryInfoSer
210. onal View Model 52 4 2 1 Copy From Existing Model 53 4 2 2 Transform From Existing Model 53 4 3 Creating XML Document View Model 53 4 3 1 Copy From Existing Model 53 4 3 2 Build XML Documents From XML Schema 54 4 4 Creating XML Schema Model 54 4 4 1 Copy From Existing Model 55 4 5 Creating Web Service View Model 55 4 5 1 Copy From Existing Model 55 4 5 2 Build From Existing WSDL File s or URL 56 4 5 3 Build From Relational Models 56 4 5 4 Build From XML Document View Models 56 Chapter 5 Importers 1 ee etn eee e nee e nee nnenaas 57 5 1 Import DDL 5 5 2 Import From JDBC Database 59 5 3 Import From Flat File Source 65 5 4 Import From XML Data File Source 14 5 5 Import From Salesforce 79 5 6 Import Metadata From T ext File 84 5 6 1 Import Relational Model XML Format 85 5 6 2 Import Relational Tables CSV Format 88 5 6 3 Import Relational View Tables CSV Format 90 5 6 4 Import Datatypes CSV Format 91 5 7 Import WSDL into Relational Models 92 5 7 1 Circular References in WSDL Schemas 96 5 8 Import WSDL Into Web Service 97 5 8 1 Import WSDL From Workspace Location 97 5 8 2 Import WSDL From File System Location 102 5 8 3 Import WSDL From URL 107 5 9 XSD Schema File 113 Chapter 6 Creating and Editing Model Objects 0 0 ccc eee 117 6 1 Creating New Model Objects 117 6 1 1 New Child Action 117 6 1 2 New Sibling Action 119 6 1 3 New Association Action 120 6 2 Model Object Editors 122 6 2
211. one A Marid A Street A City A State A ZipCode FROM EXEC EmployeeSource getTextFiles EmployeeData txt AS f TEXTTABLE ffile COLUMNS LastName string FirstName string MiddleName string Empld string Department string AnnualSalary string Title string HomePhone string Mgrid string Street string City string State string ZipCode string HEADER AS A L 1 Figure 5 18 Generated Flat File View Table 5 4 Import From XML Data File Source Teiid supports XML Files as data sources You can import from these data sources and create the metamodels required to query your data in minutes Using the steps below you will define your flat file data source configure your parsing parameters for the XML data file generate a source model containing the required Teiid procedure and create a view table containing the SQL defining the column data in your XML data file As with Designer s JDBC Salesforce and WSDL importers the XML File importer is based on utilizing a specific Data Tools Connection Profile The results of the importer will include a source model containing the getT extFiles procedure or invokeHT T P procedure which are both supported by T eiid The importer will also create a new view model containing a view table for your selected flat file source file Within the view table will be generated SQL transformation containing the getT extFiles procedure from your source model as well as the column definitions and param
212. onnection profile defines the properties and driver to be used when connecting to the database In the Action Set list double click the action or select it then click Execute selected action The wizard is launched as shown below New Connection Profile Connection Profile Create a MySQL connection profile l Connection Profile Types type filter text Ef Ingres Ef MaxDB fH ModeShape aa sms SSS Description optional Pt lt Back Next gt Cancel Finish Figure 3 5 Connection Profile Name and Type Select the type of database that you are connecting to e g MySQL and enter a name for the connection profile e g TestMySQL Click Next Chapter 3 Start Here New Connection Profile Specify a Driver and Connection Details gt Select a driver from the drop down and provide login details for the connection Drivers MySQL JDBC Driver S A Properties General Optional E URL jdbc mysaql localhost 3306 database O Save password Connect when the wizard completes Test Connection O Connect every time the workbench is started lt Back lt Back Next gt Cancel Canel Finish Finish Figure 3 6 Connection Profile properties Now select the driver and enter the login properties for your database Click Finish to complete the profile creation Create source model for JDBC data source The Create
213. opment perspective Step 2 Select the Database Connections folder and choose the New action to display the New Connection Profile dialog 195 JBoss Enterprise Data Services 5 Teiid Designer User Guide New Connection Profile Connection Profile Create a Teiid connection profile Connection Profile ypes type filter text Ingres MaxDB ES ModeShape Eg MySQL j Oracle E PostgreSQL E SOL Server E SQLite Ed Sybase ASA j Sybase ASE Name Products Description optional Cancel Anish Figure 9 15 New Connection Profile Dialog Step 3 Enter unique name for your profile select an existing connection profile type and hit Next s Step 4 Inthe Teiid Profile Wizard page select the New Driver Definition button to locate and select the Telid client jar on your file system Configure your URL using your VDB Name Host Port Username default admin and Password default telid 196 Chapter 9 Testing Your Models Tetid Profile Wizard Specify a Driver and Connection Details Select a driver fram the drop down and provide login details for the connection Drivers Teiid Server JDBC Driver General VDB Name Products localhost 31000 Username admin Password SSL Connection F ee ee ee Ok Connect when the wizard completes Test Connection Connect every time the workbench is started lt Back Next gt Cancel Finish Figure 9 16 Telid Connection Profi
214. ors Reconcile target attributes to ensure the symbols in your transformation match the attributes in your virtual metadata class You can also set preferences that impact the display of your Transformation Editor For more information see Section B 1 3 3 Transformation Editor Preferences The Transformation Editor toolbar actions are summarized below T Preview Virtual Data executes a Simple preview query for the target table or procedure of the transformation being edited Search Transformations provides a simple way select and edit another transformation based SQL text search criteria E Edit Transformation provides a simple way to change which transformation to edit without searching in a diagram or the Model Explorer Simply click the action and select from a list of views tables procedures or operations from the currently edited model Cursor at 1 1 Cursor Position line column shows the current line and column position of the insertion cursor For example Cursor Position 1 4 indicates that the cursor is presently located at column 4 of line 1 Supports Update Supports Update checkbox allows you to enable or disable updates for the current transformation target If Supports Update is checked the editor shows four tabs at the bottom for the Select Update Insert and Delete transformations If Supports Update is unchecked all updates are disabled and only the Select transformation is display
215. p no embedded quotes VTable SELECT FROM PMod1 PTab2 Descrip 2 with quotes sooc VTable3 SELECT FROM PMod1 PTab3 Descrip 3 Figure 5 35 Select Import Type Relational Virtual Tables CSV Format Step 4 In the next page you ll need to provide a source text file containing the metadata formatted to the specifications on the previous page 90 Chapter 5 Importers Import Metadata From Text File Select Source Text File and Target Virtual Relational Model Select CSV Ale to Import and Destination Model or model folder Select Source Text Ale nd Browse Target Location Browse Ale Contents Figure 5 36 Select Source Text File and Target Virtual Relational Model Step 5 Select an existing relational virtual model as the target location for your new model components using the Browse button to open the Virtual Model Selector Dialog Select a virtual relational model from your workspace or specify a unique name to create a new model Step 6 Select Finish 5 6 4 Import Datatypes CSV Format To create datatypes from imported text file metadata Perform Steps 1 through 3 above and select the Datatypes CSV Format import type then click Next gt Import Metadata From Text File Select Import Type Select the type of text file import desired Import Type Purpose Imports datatypes from a CSW text file into a datatype model Datatype data is expected to be of t
216. pective defines the initial set and layout of views and editors Within the application window each perspective shares the same set of editors Each perspective provides a set of functionality aimed at accomplishing a specific set of tasks Perspectives also control what appears in certain menus and toolbars They define visible action sets which you can change to customize a perspective You can save a perspective that you build in this manner making your own custom perspective that you can open again later C 1 1 Telid Designer Perspective The Telid Designer perspective provides access to fundamental model editing and management capabilities This perspective includes the following main UI components or groups of components Model Explorer View Teiid tree view of Model Objects Teiid View Telid Server instance view Provides view of contents for connected instances of installed Telid runtime Model Editors Custom editors targeted for xmi metadata model files Properties View Standard property values for selected workbench objects Guides View Guides and Status Views which enhance usability Miscellaneous Views Includes the Problems view Message Log view and the SQL Results view opened if Preview Data action is performed C 1 2 Opening a Perspective There are two ways to open a perspective Using the Open Perspective button E on the shortcut bar Choosing a perspective from the Window gt Open Perspective men
217. peration 190 The operation can be in a view model as well as a source model Step 2 Right click select the Preview Data action You can also select the same action in Step 3 An input parameter input dialog is presented Enter a valid value for each parameter Note that if data entered does not match the parameter datatype String integer etc an error message will be displayed in the dialog header When all required values are entered click the OK button to execute the query Chapter 9 Testing Your Models Preview Data To execute this procedure input values are required All parameter values are set Select OK to continue Input Parameters AUTHOR ID xslong 10022 cnal Figure 9 7 Procedure Parameter Input Dialog 9 2 5 Sample SQL Results for Preview Data Preview Data results are displayed in the Eclipse Datatools SQL Results view as shown below Note there are a number of display preference and filter options for this view via toolbar buttons and the dropdown menu E Problems 19 Message Log SOL Results XN K oe fal p E Type query expression here INSTR_ID NAME ISSUER EXCHANGE i PRD01088 Nowell Incorporated to 1 NasdaqNm NasdagqhM 2 NasdaghM l NasdagqNM NYSE 7 Toronto 2 NasdaghM l Toronta NasdagSC Status A Operation Date Connection Profile Succee select fror Aug 28 2010 Transient org teiid d w Succee select from Aug 28 2010 Transien
218. profiles without leaving the wizard VDB artifacts deployed there The Create Data Source action available on this view utilizes the available and applicable connection profiles 9 1 1 Set Connection Profile for Source Model Telid Designer integrates Data Tools Connection Profiles by persisting pertinent connection information in each source model This can occur through Importing process or through the Modeling gt Set Connection Profile action 9 1 2 View Connection Profile for Source Model In addition to setting the connection profile on a source model you can also view a source model s connection profile information via the Modeling gt View Connection Info action which displays the detailed properties of the connection 186 Chapter 9 Testing Your Models Model Connection Info Info The properties in the table below are currently stored in the source model PartsSourceB xmi Properties name value connectionProfileDescription connectionProfileCategory org eclipse datatools connectivitydb category connectionProfileProviderld org eclipse datatools enablement oracle connectionProfile connection url jdbc oracle thin englxdbs11 mm atl redhat com 1521 0RCL connectionProfileName PartsOraclell connectionProfilelnstancelD 3 org eclipse datatools enablement oracle connectionProfile driver class oracle jdbc OracleDriver translator name oracle username partssupplier Cancel Fig
219. publishDate E a ia i tt p ty 8 Mapping Diagram E Table Editor Figure C 41 Mapping Diagram Example Mapping Diagram toolbar actions include a Refresh Diagram Re draws diagram s I Show Parent Diagram Navigates to diagram for parent object if available a 8 Show Mapping Transformation Diagram Show detailed mapping transformation diagram for selected mapping class WF Preview Data Executes a simple preview query SELECT FROM gt Generate Mapping Classes Generate mapping classes for the selected XML document root element H New Mapping Class Insert new mapping class referenced to the selected XML document element or attribute EB New Staging Table Insert new staging table referenced to the selected XML document element or attribute ii Merge Mapping Classes Merge selected mapping classes ENE Split Mapping Class Split selected mapping class Display All Mapping Classes Show Mapping Class Columns P Filter Displayed Mapping Classes with Selection Context menus for Mapping Diagrams provide Edit capability to the mapping class in addition to mapping class manipulation actions i e Merge Mapping Classes Split Mapping Class etc C 3 1 1 5 Mapping Transformation Diagram The Mapping Transformation Diagram is identical to a Transformation Diagram except for displaying an Input Set and possibly Staging Tables as sources for the Mapping Class s transformation 244
220. r Telid Designer is based on UML notation Future releases may include alternate notations Routers The relationship link type for Package and Custom diagrams Foreign Key Primary Key relationships can be customized Available options include Orthogonal default Direct or Manual user defined breakpoints Font Settings Select font type style and size Background Color Settings Select a unique background color for each diagram type to help differentiate between types Model Size Displaying very large diagram may take a considerably long time This preference allows users to set an upper limit on the number of objects to display in a diagram If this limit is exceeded a warning is displayed to the user and the diagram is not constructed Relationship Options UML type relationships can be customized in a couple of ways Role Names and Multiplicity labels can be shown or hidden using the check boxes labeled Show Role Names and Show Multiplicity JBoss Enterprise Data Services 5 Telid Designer User Guide Diagram alle 2S General settings for Diagrams Notations Default Notation UML Routers Default Router Style Orthogonal Font Settings Font Type Sans Regular 8 View Change Background Color Settings Dependency Diagram Custom Diagram E Mapping Diagram Relationship Diagram m Tansformation Diagram C_ Custom Relationship Diagram a Package Diagram
221. r each model object type 208 Editor XML Document Mapping Settings Transformation Table User Preferences Preferences for a given table will only be present if the table editor tab for ithas been viewed After restoring defaults the table editor must be viewed again for the default preferences to become visible Table Base Tables Columns Foreign Keys Function Parameters Inputs Interfaces Operations Outputs Primary Keys roacedures Procedure Parameters Procedure Results Return Parameters Sample Messages Scalar Functions Schemas VIEWS Columns Column Visible Location Name Name In Source Native Type Length Length Axed Numeric Precision Numeric Scale Nullable Auto Incremented Default Value Minimum Value Maximum Value Format Character Set Name Yi Collation Name Restore Defaults Figure B 6 Table Editor Preferences Panel B 1 3 3 Transformation Editor Preferences diagram layout and default view entity properties 209 JBoss Enterprise Data Services 5 Telid Designer User Guide Editor oe XML Document Mapping Settings Tran sformationi Table SOL Clauses Start Clauses on New Line Indent Clause Content Auto expand default SELECT FROM on construction Diagram Layout View and Sources Tree Layout Miscellaneous Default String Length 10 Figure B 7 Transformation Editor Preferences Panel B 1 3 4 VDB Editor Pre
222. readme Q Parts vdb gt PartsSourceA xmi gt PartsSourceB xmi v B PartsVirtual xmi gt import declarations 4 fa Package Diagram gt E Supplierinfo gt A partsByColor gt Og SampleViews xmi Figure C 6 Model Explorer View The toolbar consists of nine common actions WW Preview Data Executes a simple preview query SELECT FROM Sort Model Contents Sorts the contents of the models based on object type and alphabetizing amp Refresh Markers Refreshes error and warning markers for objects in tree P Back Displays the last Go Into location See Eclipse Help gt Forward Displays the next Go Into location See Eclipse Help FA Up Navigates up one folder container location See Eclipse Help Collapse All Collapses all projects Link with Editor When object is selected in an open editor this option auto selects and reveals object in Model Explorer Additional Actions The additional actions are shown in the following figure 216 Teiid Designer UI Reference gt E a P Show all file types Show Imports Select Working Set Deselect Working Set Sort gt l Filters _ Link with Editor Figure C 7 Additional Actions If Show Model Imports is checked the imports will be displayed directly under a model resource as shown below v A PartsVirtual xmi w import declarations 4 4 PartsProject PartsSourceA xmi 4_ PartsProjec
223. relational view model complete Step 5 Select the model builder labeled Copy from existing model of the same model class and click Next gt The Copy Existing Model dialog will be displayed Step 6 Select an existing relational model from the workspace using the browse button Step 7 Check the Copy all descriptions option if desired 4 2 2 Transform From Existing Model This option is only applicable for creating a relational view model from a relational source model with the added feature of creating default transformations SELECT FROM SourceModel T able_X for each above There is an additional option in the second page of the wizard which can automatically set the relational table s supports update property to false If this is unchecked the default value will be true 4 3 Creating XML Document View Model Create XML Document View Model To create a new empty XML document view model Step 1 Launch the New Model Wizard Step 2 Specify a unique model name Step 3 Select XML option from Model Class drop down menu Step 4 Select View Model from Model Type drop down menu Step 5 Click Finish Note You can change the target location i e project or folder by selecting the Browse button and selecting a project or folder within your workspace In addition to creating a new empty XML document view model the following builder options are available Copy from existing model of the same model class Build
224. rent object if available E4 Preview Data Executes a simple preview query SELECT FROM Add To Diagram Add objects selected in Model Explorer to diagram Ed Remove From Diagram Removed objects selected in diagram from diagram Clear Diagram Remove all objects from diagram lfm Save Diagram as Image Save the diagram image to file in JPG or BMP format Modify Diagram Printing Preferences Modify page layout information for printing diagrams Includes margins orientation etc Show Hide Page Grid Show current page boundaries as grid in diagram Since Custom Diagrams do not represent represents the contents of container objects i e Model Category Schema etc its context menus are limited to adding removing objects from diagram and basic diagram related display options C 3 1 1 3 Transformation Diagram The Transformation Diagram represents a view of the relationships defined by the source inputs described in a view table s SQL transformation 242 Teiid Designer UI Reference Tl PartsVirtual xmi ms N ea VIEW SOURCES EY SUPPLIER_ID string 10 EY SUPPLIER_ID string 10 Ej PART_ID string 50 EJ SUPPLIER_NAME string 30 El QUANTITY short E SUPPLIER_STATUS short SHIPPER_ID short SUPPLIER _CITY string 30 l EJ SUPPLIER_STATE string 2 F FK_SPLIER_STATS F PK_SUPPLIER ma Transformation Diagram F Table Editor Figure C 40 Transformation Diagram Example
225. rializedParts xmi MaterializedParts Name ir PARTS Name In Source TA PARTS Supports Update Ir false ee live Fal System Lk false n BaseTable PartsViewModel PARTS Figure 7 11 Materialized Table Properties Designer includes a feature to assist in quickly creating materialized relational tables based on your existing view tables To create materialized views New Child New Sibling New Association a W W a3 Create Materialized Views Create Web Service Modeling LJ Salesforce LJ SearchProj LI SF_Testing LJ TestRels T a Undo Delete multiple objects Redo Ha Add To New Custom Diagram w Add to Metadata Faworites of Cut Ctrl x Copy Ctrl C Ta Paste Ctrl V f e Step 2 In the Create Materialized View Model dialog specify or select a target relational model for your generated relational tables 159 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Materialized View Model Create Materialized View Model All inputs OK Press Anish to create materialized view tables Materialization Model materializedParts Target Location MaterializedP arts Selected Virtual Tables PARTS SHIP VIA Cance Anis h e Step 2a Selecting the browse button displays the Relational Model Selector dialog where you select an existing relational model or specify a unique name for a new model Relational Model Sele
226. rmation from the database itself and becomes useful to describe the content of your enterprise information systems and to determine how a column in one enterprise information source relates to another and how those two columns could be used together for a new purpose You can think of this metadata in several contexts What information does the metadata contain What data does the metadata represent How will my organization use and manage this metadata 2 3 2 Editing Metadata vs Editing Data The Telid Designer helps you to create and describe an abstract graphic representation of your data structure of your data in the original data sources It also describes whether those data sources are composed of Relational databases text files data streams legacy database systems or some other information type The Telid Designer allows you to create edit and link these graphically represented meta objects that are really a description of your data and not the data itself So when this documentation describes the process of creating deleting or editing these meta objects remember that you are not in fact modifying the underlying data 2 3 5 Metadata Models A metadata model represents a collection of metadata information that describes a complete structure of data In a previous example we described the field ZIPCode as a metadata object in an address book database This meta object represents a single distinct bit of metadata informa
227. rsely select Hide T ext to only show icons To quickly switch between open perspectives select the desired perspective button Notice that the set of views is different for each of the perspectives Fy Teiid Desig lo Database D Figure C 4 Workbench Window Title Bar 214 Teiid Designer UI Reference C 1 3 Further information C 2 Telid Designer Views Views are dockable windows which present data from your models or your modeling session in various workspace selection This section summarizes most of the views used and available in Telid Designer The full list is presented in the main menu s Window gt Show View gt Other dialog under the Telid Designer category Show View gt E Team w o gt Teiid Designer fs Datatypes Description w Metadata Faworites t Model Explorer aH Relationship Navigator ae System Catalog Tags cae Teiid Wh Teiid Model Classes Cancel Figure C 5 Eclipse Show View Dialog C 2 1 Model Explorer View Telid Designer allows you manage multiple projects containing multiple models and any corresponding or dependent resources The Model Explorer provides a simple file structured view of these resources The Model Explorer shown below is comprised of a toolbar and a tree view 215 JBoss Enterprise Data Services 5 Telid Designer User Guide E z Outline 2 e La AllCustomerAccounts gt t BooksProject Fr S PartsProject gt data gt
228. s 9 1 Manage Connection Profiles 9 1 1 Set Connection Profile for Source Model 9 1 2 View Connection Profile for Source Model 9 1 3 Remove Connection Profile from Source Model 9 2 Previewing Data For a Model Testing Your Transformations 9 2 1 Preview Relational Table or View 9 2 2 Preview Relational Table With Access Pattern 9 2 3 Preview Relational Procedure 9 2 4 Preview Web Service Operation 9 2 5 Sample SQL Results for Preview Data 9 2 6 Execution Plans 9 3 Testing With Your VDB 9 3 1 Creating Data Sources 9 3 2 Execute VDB from Model Explorer 9 3 3 Deploy VDB from Model Explorer 9 3 4 Executing a Deployed VDB Chapter 10 Searching 0 ccc eee eens 139 139 139 140 140 140 142 144 144 145 147 149 150 150 153 158 158 161 165 165 167 167 170 170 173 177 178 180 181 182 183 186 186 186 187 187 189 189 189 190 190 191 191 192 192 193 194 195 10 1 Finding Model Objects 10 2 Search Transformation SQL 10 3 Search Models Via Metadata Properties Supported Data SourceS eee teens User Preferences ooo a een enn n nnn bbb nnn nnn B 1 Telid Designer Preferences B 1 1 Diagram Preferences B 1 2 Diagram Printing Preferences B 1 3 Editor Preferences B 1 3 1 XML Document Preferences B 1 3 2 Table Editor Preferences B 1 3 3 Transformation Editor Preferences B 1 3 4 VDB Editor Preferences B 1 4 Validation Preferences Telid Designer Ul Reference
229. s v Og TestMySOLxmi ai import declarations 2 t Package Diagram Accounts ACCOUNT gt E Accounts CUSTOMER P E Accounts HOLDINGS P E Accounts PRODUCT b D Data Source views Figure 3 12 Select Preview Table After selecting the table click OK Now the preview results will be displayed Chapter 3 Start Here Type query expression here Status Result1 T Problems G Error Log f SQL Results x e Teiid Execution Plan x A Status Operation Date Cc ACCOUNT_ID Succe select fro Jun 8 2012 Tr 19980002 19980003 _ 19980004 19980005 19980006 i 1999NNN7 rau F amp F WN CD Total 17 records shown Figure 3 13 Preview Results Define VDB SSN STATUS TYPE DATEOPENED DATEC CST01002 Personal Active 1998 02 01 00 00 00 0 _CST01003 Personal Active _ 1998 03 06 00 00 00 0 2012 _cSTo1004 _ Personal Active _ 1998 03 07 00 00 00 0 2012 1 _CSTO1005 _ Personal Active 1998 06 15 00 00 00 0 2012 CSTO1006 Personal Active 1998 09 15 00 00 00 0 2012 4 CSTA1NN7 Persnnal Active 1999 01 20 nn nn nn N 017 The Define VDB action allows you to create a VDB Virtual Database artifact for deployment to a Teiid Server In the Action Set list double click the action or select it then click Execute selected action The following dialog is displayed New VDB i New VDB Press the Finish button to finish VDB Name myVDB Descriptiom See Selected
230. s ProductData ProductiD datatype varchar length 11 nullable NO NULLS gt lt colurmm gt lt column name ProductName namelnSource dbo products ProductData Produ datatype varchar length 60 nullable NULLABLE gt lt column gt lt column nam e Productlype namelnSource dbo products ProductData Product datatype varchar length 15 nullable NULLABLE gt lt column gt TALUMA Pi Figure 5 31 Select Source Text File and Target Relational Model Page If the target model contains named children tables views procedures that conflict with the objects being imported a dialog will be displayed giving you options on how to proceed including replacing specific existing objects creating new same named objects or cancel import entirely 87 JBoss Enterprise Data Services 5 Teiid Designer User Guide Duplicate Objects Exist Options Replace Existing Objects See list below Create New Objects Anyway results in validation errors Cancel Import Duplicate Objects getProductinf ProductData ProductiDIindex ProductSymbals ProductView Select All Deselect All Cancel Figure 5 32 Duplicate Objects Dialog 5 6 2 Import Relational Tables CSV Format To create relational tables from imported text file metadata a Perform Steps 1 through 3 above and select the Relational Tables CSV Format import type then click Next gt Chapter 5 Importers T Import Me
231. s will scan the data in each field individually and can be a very long running operation Set name to SalesForce label Selecting this option will cause the importer to set the name metadata in the generated model 1 By default the importer uses the internal data name because SalesForce labels are often invalid f Create a procedure for the GetUpdated operation Selecting this option will cause the importer to create a procedure for the getUpdated operation ir Create a procedure for the GetDeleted operation Selecting this option will cause the importer to create a procedure for the getDeleted operation in lt a ee gt lext gt Cancel Finish Figure 5 26 Target Model Selection Dialog a Step 5a If you are updating an existing relational model the next page will be Review Model Updates page Any differences Press Finish to create your models and tables 82 Chapter 5 Importers Create Relational Model from SalesForce Data Model Review Model Updates Review the changes that will be applied to your model to bring it up to date with the source metadata Uncheck any changes you do not wish to apply Only In Old Model 010 Changes 4 Only In New Model NEw T i ra file TestSF 1314365845645 temp xmi can Salesforce Selection Details lt Back Next gt Cancel Anish Figure 5 27 Review Model Updates Dialog When finished the new or changed relational model s package diagram will be d
232. should end up displayed in a diagram if applicable and selected 10 2 Search Transformation SQL The Telid Designer provides a search capability to string values present in transformation SQL text To search for string values in your transformations SQL Step 1 Select Search gt Transformations action on the Telid Designer main menu which opens the Search Transformations dialog Step 2 Specify a string segment in the Find field and specify change your case sensitive preference Step 3 Select Perform Search button Any transformation object containing SQL text which contains occurrences of your string will be displayed in the results section You can select individual objects and view the SQL If a table or view supports updates and there is insert update or delete SQL present you can expand the object and select the individual SQL type as shown below If you wish to view the selected object and its SQL in a Model Editor you can click the Edit button An editor will be opened if not already open If an editor is open its tab will be selected In addition the 200 Chapter 10 Searching Transformation Editor will be opened and you can perform Find Replace Ctrl F actions to highlight your original searched text string and edit your SQL if you wish 10 3 Search Models Via Metadata Properties The Telid Designer provides a search capability to find model objects that are characterized by one or more metadata property va
233. source model for JDBC data source action will now utilitze the Connection profile that you just created to import the metadata from the database to create your T eiid Source Model In the Action Set list double click the action or select it then click Execute selected action The wizard is launched as shown below 31 JBoss Enterprise Data Services 5 Teiid Designer User Guide Import Database via JDBC Import Database via JDBC F d Select the JDBC source configuration for the database to be imported into a relational model Connection Profile JDBC Metadata Processor eee JDBC default ois Propertie Driver MySQL JDBC Driver URL jdbc mysql localhost 3306 Accounts UserName root k lt Back Next gt Cancel Finish Figure 3 7 Select Connection Profile On this page select the TestMySQL Connection profile that you created in the previous step Click Next Chapter 3 Start Here import Database via JDBC Select Database Metadata E Select the types of objects in the database to import Foreign Keys Include Incomplete FKs O Indexes LOCAL TEMPORARY O Unique Only O Approximations Allowed C Procedures C eek nen J canet a Figure 3 8 Select Database Metadata On this page select the database metadata that you want to import When finished click Next 33 34 JBoss Enterprise Data Services 5 Teiid
234. ss of precision Figure 6 16 Datatype Resolver Dialog To summarize the different sections of the dialog Target Attribute SQL Symbol Table This table shows all target attribute SQL Symbol bindings from the Reconciler Dialog which have a type conflict Select on a table row to populate the lower Edit Panel Edit Panel The lower panel shows the Target Attribute and SQL Symbol datatype information for the 128 Chapter 6 Creating and Editing Model Objects selected binding You can resolve the conflict in one of the following ways Virtual Target Attribute Resolve the type conflict by changing the target attribute type to be compatible with the SQL Symbol type The attribute s current runtime type is shown along witha potential new datatype and some button controls Apply Button If the suggested datatype is acceptable click Apply to allow the attribute type to be changed Convert All Button If you wish to change all of the attribute types in the table to be compatible with its corresponding SQL Symbol datatype click the Convert All button Change Button If the suggested datatype is not acceptable click Change to choose your own datatype from a datatype dialog SQL Symbol Resolve the type conflict by applying a CONVERT function to the SQL Symbol so that its type is compatible with the target attribute type The SQL Symbol s current type is shown along with a suggested CONVERT function and two butt
235. ste Ctrl V V _ Figure 7 13 New View Table Wizard Action 161 JBoss Enterprise Data Services 5 Telid Designer User Guide Running the action will display the Create Relational View Table wizard The wizard page contains 3 tabbed panels representing the various properties and components that make up the possible definition of a relational view table Enter your table name define the desired columns and specify the SQL transformation then click OK This wizard is designed to provide feedback as to the completeness of the relational view table information as well as the validation state of the table and it s components Note that although errors or warnings may be displayed during editing the wizard is designed to allow finishing even if the table definition is incomplete The first tab labeled Properties contains the input for the simple table properties including name and Supports update E Create Relational View Table aa Create Relational View Table No columns defined for table This wizard allows creating a complete relational view table including SQL definition H Properties Columns SQL Name myTable Supports Update cones Figure 7 14 Properties Tab The Columns tab allows creation and editing of basic relational columns This includes adding deleting or moving columns as well as changing the name datatype and length properties 162 Chapter 7 Metadata specific Modeling
236. t Chapter 5 Importers _J Import From Flat File Source x Flat File Fixed Columns Width Parser Settings Eh Press the Next gt bution t continue SPP Selected Data Ale EmpDataARxedWidth tet Format Options File Contents Preview Data line 2 Department string WIDTH 5 AnnualSalary integer WI MgrId integer WIDTH 8 Street string WIDTH 14 Cit Cursor Position 24 ee Kisselmeyer Abbiegale Tikvica 9000059 G 64000 ares Glore Diodie vojvoda 9000060 G 71000 Dawson Pinckney Ostoja 9000061 G 71000 Waldrip Trixie Curic 5000062 G 57000 Kitchen 71 Lpha Bulc 9000063 G 60000 Wakeman Gerard vlahovic 9000064 G 78000 H HaTtTtTarTi Dimne be KOFAS MAAA iF BAA e gt Column Options Column Information ADD Column Name Datatype E firstName string BELEN FA middleName 3 string UP DA lastName string Generated SQL Statement SELECT AfirstName A middleName A column 3 FROM EXEC ssss getTexthles EmpDataAxedWidth txt AS f TEXTTABLE file COLUMNS firstName string width 12 middleName string width 12 column_3 string width 12 AS A lt Back Next gt Cancel n Figure 5 15 Flat File Fixed Columns Width Options Page Step 6 On the View Model Definition page select the target folder location where your new view model will be created You can also select an existing model for your new view tables Note the Model Status section which will indicate the validity of the model name
237. t war_context model_ name resource will accept URI path parameters and or XML while http host port war_context model_ name json resource will accept URI path parameters and or JSON Step 1In a virtual model add a procedure s that returns an XMLLiteral object The target of your procedure can be any models in your VDB Here is an example procedure that selects from a virtual table VirtualBooks and returns the results as an XMLLiteral VIEW amp m ov E Sa a 4 Transformation Diagram E Table Editor Transformation Editor 0 amp Cursor at 4 4 Ba el Aa CREATE VIRTUAL PROCEDURE BEGIN SELECT XMLELEMENT NAME books XMLAGG XMLELEMENT NAME book XMLFOREST RestfulBooks VirtualBooks ISBN RestfulBooks VirtualBooks TITLE RestfulBooks VirtualBooks SUBTITLE RestfulBooks VirtualBooks PUBLISHER RestfulBooks VirtualBooks PUBLISH_YEAR RestfulBooks VirtualBooks EDITION RestfulBooks VirtualBooks TYPE RestfulBooks VirtualBooks AUTHOR_ID AS result FROM RestfulBooks VirtualBooks WHERE RestfulBooks rgetBooks isbn_in RestfulBooks VirtualBooks ISBN END Notice the syntax used to convert the relation table result of the select from VirtualBooks to an XMLLiteral All XML functions are documented in the Scalar Functions chapter of the Telid Reference Guide Here is an example of an update procedure that will insert a row and return an XMLLiteral object 173 JBoss Enterprise Data Services 5 Teiid
238. t Move action 7 T AllCustomerAccounts gt Sources ar Northwind xmi New gt b ie BooksProject New Child gt gt te PartsProject Modeling gt b t WSDLImportProject Open Open With gt Copy Paste Ctrl V Paste Special Ctrl V Delete Refactor Unda Redo g g Import gy Export Rename Namespace URI Figure 8 3 Refactor Move Action In Model Explorer a Step 3 Select a new location i e Project or Folder and click OK 181 JBoss Enterprise Data Services 5 Teiid Designer User Guide Move Northwind xmi Select the move destination w Ee AllCustomerAccounts gt Ca Northwind xmi Ge Sources gt E BooksProject gt E PartsProject gt WSDLImportProject Cancel Figure 8 4 Move Model Dialog 8 3 Save Copy of Model The Save As action performs a similar function as the Refactor gt Rename action except the renamed model is a structural copy of the original model Each model object maintains it s own unique ID So copying a model will result in a exact structural copy of your original model but with re generated unique object IDs Be aware that locating and copying your models via your local file system may result in runtime errors within Designer Each model is expected to be unique and duplicate models are not permitted To create a duplicate model using Save As a Step 1 Open the model you wish to copy in a Model Editor by double clicking the model in
239. t org teiid d PRD01089 Amazon com Incorporated PRDO1O90 Juniper Networks Incorporated 2 Stock 2 3 PRDO1O91 Red Hat Incorporated l Stock PRDO1092 Boston Scientific Corporation Stock 3 PRDO1O93 Inex Pharmaceuticals Incorpora Stock PRDO1O94 Pfizer Inc Stock PRDO1O95 Cytovax Biotechnologies Incorpe Stock 2 PRDO1096 Commonwealth Biotechnologies Stock PRDO1097 British Biotechnology plc Stock NasdagNM PRDO1220 Unisys Corporation Stock NYSE PRD01099 Honeywell International Stock 2 NYSE PRDO1100 Hilton Hotels Corporation Stock NYSE 3 PRDO1101 7 Hilton Hotels Corporation 3 Corpor 4 3 NYSE 2 PRDO1102 Mercury Interactive Corporation Stock 2 NasdaqhM PRDO1103 Fidelity Freedom Income Fund Mutual 1 NasdaqSC MMAR ATI AA Mailh Fae d a AANAN FM bie bee l F Babes k H mMm P o a fe m H Wj li j m n B a ol a O E Figure 9 8 SQL Results View 9 2 6 Execution Plans When Preview Data is executed the Teiid Execution Plan is also displayed as shown below The Execution Plan may also be obtained by rt clicking on a previewable object then selecting Modeling gt Show Execution Plan in the context menu 191 JBoss Enterprise Data Services 5 Telid Designer User Guide FJ SOL Results Teiid Execution Plan 23 Preview Data for myTbl SOL select from vModel myTbI Execution Plan
240. t PartsSourceB xmi 4 http waww ews org 2001 MMLSchema 4 _ PartsProject SampleViews xmi ta Package Diagram gt H Supplierinfo Figure C 8 Show Model Imports Action C 2 1 1 Selection Based Action Menus Selecting specific objects in the Model Explorer provides a context from which the T elid Designer presents a customized menu of available actions Selecting a view model for instance results in a number of high level options to manage edit model content perform various operations and provides quick access to other important actions available in Telid Designer These may include specialized actions based on model type 217 JBoss Enterprise Data Services 5 Telid Designer User Guide gt Og PartsSourceB xmi J qj ee gt j New Child amp Base Table Modeling gt Catalog Index Open With gt L Logical Relationship Procedure i l schema ny ctrl LE Paste Ctrit H ner iia E Custom Diagram Delet Ted oo es z 57 o Refactor ge Import py Export Figure C 9 Sample Context Menu C 2 2 Outline View The Outline View is a utility view which provides both at tree view dedicated to a specific model open in an editor and a scaled thumbnail diagram representative of the diagram open in the corresponding Diagram Editor You can show the Outline View by clicking on its tab If there is no open editors the view indicates that Outline is not
241. t match the column datatype String integer etc an error message will be displayed in the dialog header When all required values are entered click the OK button to execute the query oe Preview Data To preview data from this table select an access pattern and provide a value for each required column All access pattern column values are set Select OK to continue Access Patterns Required Columns Al NameandID PUBLISHERID long 20022 NAME stringlZ55 Mifflin na Figure 9 5 Access Pattern Column Input Dialog 189 JBoss Enterprise Data Services 5 Telid Designer User Guide 9 2 3 Preview Relational Procedure To preview a relational procedure procedure can be in a view model as well as a Source model Step 2 Right click select the Preview Data action 3 You can also select the same action in Step 3 An input parameter input dialog is presented Enter a valid value for each parameter Note that if data entered does not match the parameter datatype String integer etc an error message will be displayed in the dialog header When all required values are entered click the OK button to execute the query Preview Data To execute this procedure input values are required All parameter values are set Select OK to continue Input Parameters colorIn string blue nas Figure 9 6 Procedure Parameter Input Dialog 9 2 4 Preview Web Service Operation To preview a Web service o
242. tadata From Text File x Select Import Type lt b gt Select the type of text file import desired ina a Import Type Purpose Imports relational schema catalogs tables columns and indexes from a CSW text file into a relational model 1 Schema Catalog and Table data is expected to be of the form gt TYPE i e SCHEMA CATALOG or TABLE Name Description Optional Location Optional gt gt Locations are of the form ProjectName FolderName ModelName SchemaName gt gt If the project folder model or schema catalog containers do not exist they will be created 2 The Column data is expected to be in the form gt gt COLUMN ColumnName JDBCType Length Description 3 Column data rows for each table must appear immediately following the table data row 4 The Index data is expected to be of the form gt gt INDEX IndexName Type Uniqueness Tablespace Column 5 Index data rows must appear immediately following the table column data rows A sample of typical input data is shown below Sample Ale Format CATALOG Catalog _1 Catalog 1 Description Project_l1 MyModel_ 1 SCHEMA Schema_l Schema_1 Description Project_l1 MyModel 1 Catalog 1 Figure 5 33 Select Import Type Relational Tables CSV Format a Step 4 In the next page you ll need to provide a source text file containing the metadata formatted to the specifications on the previous page Import Metadata From Text File Select Source Text F
243. talCcity binding CountryInfoServiceSoapBinding port CountryInfoServiceSoap Service CountryInfoService B P lt Back Next gt Cancel Finish Figure 3 24 Consume SOAP Wizard For Connection Profile select the previously created CountryInfoConn profile The available WSDL Operations will then be displayed under Select the desired WSDL Operations Select only the first CapitalCity Operation for this example Click Next to proceed to the next page as shown below 45 46 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Relational Model from Web Service Models Definition All inputs OK Click Next gt to define custom procedures Source Model Definition Location SOAPProj sources Name CountryinfoService xmi al Status Source model CountryInfoService xmi does not exist and will be created and contain the required invoke web service procedure Niew Model Definition Location SOAPProj views L Joo Name CountryInfoServiceView xmi Status View model CountryInfoServiceView xmi does not exist and will be created and contain your generated procedures Procedure Generation Options Userspecified Procedures recommended Define userspecified request and response procedures from your WSDL schema elements This option also generat and response Default Procedures Generate default request and response procedures A new procedure will be generated
244. tegration solution that runs as a service on the JBoss Enterprise Service Oriented Architecture Platform SOA P EDS can be used to integrate data from any sources including relational databases text files web services and ERP CRM mainframe systems Red Hat provides various tools to help with the design deployment and ongoing management of an EDS instance 1 3 Insurance Use Case The Situation The CEO of Acme Home Insurance has decided that in order to operate more effectively it is time to improve the company s in house data analysis The company requires a more comprehensive and accurate view of data relating to its customers and associated factors contributing to the company s risk management and overall business strategy Since the quality of data analysis depends on the quality of data integration the company is first reviewing its data integration solution Customer information is stored in a Tenacicle database on the company network However it also needs to draw upon an assortment of data from other sources including for example Occurances of fire and flood across the nation provided by the Federal Department of Emergency Services which is stored in an online IntegriSQL database Average building costs in metropolitan and regional areas for each state provided by several state Building Associations some of which are stored in online databases and others stored as 11 JBoss Enterprise Data Services 5 Telid Des
245. the Source Metadata into the terminology and domain of different applications View Metadata too can contain both technical and business metadata When you model View Metadata you re modeling the data as your applications and your enterprise ultimately use it 2 3 6 1 Modeling Your Source Metadata When you model the Source Metadata within your enterprise information systems you capture some detailed information including Identification of datatype Storage formats Constraints Source specific locations and names The Source Metadata captures this detailed technical metadata to provide a map of the data the location of the data and how you access it JBoss Enterprise Data Services 5 Teiid Designer User Guide This collection of Source Metadata comprises a direct mapping of the information sources within your enterprise If you use the Teiid Designer Server for information integration this technical metadata plays an integral part in query resolution For example our ZIPCode column and its parent table StreetAddress map directly to fields within our hypothetical address book database To extend our example we might have a second source of information a comma separated text file provided by a marketing research vendor This text file can supply additional demographic information based upon address or ZIP code This text file would represent another Enterprise Information System EIS and the meta objects in its Source Model
246. tion We alluded to its parent table StreetAddress These meta objects and others that would describe the other tables and columns within the database would all combine to form a Source Metadata model for whichever enterprise information system hosts all the objects You can have Source Models within your collection of metadata models These model physical data storage locations You can also have View Models which model the business view of the data Each contains one type of metadata or another For more information about difference between Source and 2 3 4 Business and Technical Metadata Metadata can include different types of information about a piece of data Technical metadata describes the information required to access the data such as where the data 17 JBoss Enterprise Data Services 5 Teiid Designer User Guide resides or the structure of the data in Its native environment Business metadata details other information about the data such as keywords related to the meta object or notes about the meta object Note that the terms technical and business metadata refer to the content of the metadata namely what type of information is contained in the metadata Don t confuse these with the terms physical and view metadata that indicate what the metadata represents 2 3 4 1 Technical Metadata Technical metadata represents information that describes how to access the data in its original native data storage Techni
247. tions for this action This action clones a complete model project containing any number of model XMI or XSD files organized in a user defined directory structure All object references UUIDs within the original project will be replaced with new unique references Any model dependencies or internal object references are refactored to reflect the dependencies within the cloned project Any model references to models in projects external to the original project will NOT be replaced Only XMI and XSD files are cloned All other file types in your project will NOT be processed nor copied into your newly cloned project including VDBs If one or more editors that require Save are open the user will be asked to save them before continuing with the cloning process To clone a model project 184 Step 2 Right click then select Model Project gt Clone in the context menu Otherwise you can select the Project gt Clone Project action located in the Telid Designer s main menu bar Metadata Run Window Help Close Project Build Working Set gt Clean Build Automatically Clone Project Build Project Imports Build All Imports i b Properties Figure 8 8 Clone Project In Project Menu Step 3 On the Clone Project wizard page provide a name for your new project Chapter 8 Editing Models and Projects Clone Model Project Clone Model Project Specify cloned model project name Project name Valu
248. titted Namespace Resolution This page identifies successful and errant WSDL namespace resolution The main WSDL document will essentially always be resolved since the workspace file chooser is used to obtain the path Problems will occur when the main WSDL file imports other WSDL files that cannot be resolved If no errors select Next to proceed or Finish if enabled to complete with default options Create Web Service from WSDL File Namespace Resolution All namespaces are resolved Select Next to modify the created schemas workspace locations Namespaces jy Namespace http dladbo l fhome blafond Test Designer Folder example files wsdls OnHand wsdl lt Back Next gt Cancel Anish Figure 5 46 Namespace Resolution Dialog s Step 5 The next page WSDL Operations Selection allows customizing the resulting content of your Web Service model by selecting deselecting various operations and interfaces in the following dialog 99 JBoss Enterprise Data Services 5 Teiid Designer User Guide Create Relational Model from Web Service WSDL Operations Selection Press the Anish button to finish Select the desired WSDL Operations Ww Ja Share_BSM_Real_Time_Data_Design_Server_RealTimeData_portService k Share BSM Real Time Data Design_Server_RealTimeData_portPort wr Share _BSM Real Time Data Design Server RealTimeData_portBinding OnHand Selection Details OnHand Operation id rh input message _OnH
249. to reflect the new element Note the BODY and HEADER tabs which exist on both the Request and Response tabs If the selected service mode for this procedure is set to MESSAGE the HEADER tab will be enabled and allow you to define the SOAP header variables utilizing the same schema tree Select the Response tab and create the response procedures result set columns in the same way Repeat this process for all operations by changing the selection target operation via the Operations selector at the top Chapter 5 Importers o Create Relational Model from Web Service Procedure Definition Press the Finish button to finish Operations fFuicountyinfo O Overwrite existing procedures for this operation Schema Contents _____________________ Element Info i FullCountrylnfo_ type Add Name o o Sequence E sCountryis0Code TG Delete Generated SOL Statement CREATE VIRTUAL PROCEDURE BEGIN SELECT AMLELEMENT NAME FullCountrylnfo AMLNAMES PACES DEFAULT http Avww corsprong org websamples countryinfo AMLELEMENT NAME sCountrySOCode CountryinfoSernviceView FullCountryinfo_request sCountrylSOCode AS xml_ out END I Back Next gt Cancel Finish Figure 5 41 Procedure Definition Page e Step 7 Click Finish After generation the new models can be found in the specified location in your workspace In the Model Explorer you can see the importer created the follo
250. tp www metamatrix com metamodels Relational Column PART COLOR PART COLOR http www metamatrix com metamodels Relational Column PART ID PART ID http www metamatrix com metamodels Relational Column PART ID PART ID http www metamatrix com metamodels Relational Column PART WEIGHT PART WEIGHT http www metamatrix com metamodels Relational Column PartsVirtual Parts Virtual http www metamatrix com metamodels Core ModelAnnotation l partsByColor partsByColor http www metamatrix com metamodels Relational Procedure b Ga Found 10 matches PartsProject PartsSourceB xmi a JBoss Enterprise Data Services 5 Telid Designer User Guide Figure C 23 Search Results View The toolbar actions for the Search Results view are b Show Next Match Navigates down one row in the view Show Previous Match Navigates up one row in the view I Remove Selected Matches Removes selected results from the view Remove All Matches Clears the view _ Search Launches the MoT eiid Designerearch Dialog P Previous Search Results Select previous search results from history You can also perform some of these actions via the right click menu e Problems Search S23 JL feature Name pattern Part 26 matches v ig Found 8 matches PartsProject PartsSourceA xmi A PART ID htta 1 i p men am F m men ee pr stim z show In sSniIt AIt W E PART NAME gt tio EY PART_COLOF J Next
251. u To open a perspective by using the shortcut bar button ij Step 2 A menu appears showing the same choices as shown on the Window gt Open Perspective menu Choose Other from the menu EICI E Fr Debug uth oa Java Browsing Figure C 1 Perspectives Menu Step 1 Click on the Open Perspective button Step 3 In the Select Perspective dialog choose Teiid Designer and click OK 213 JBoss Enterprise Data Services 5 Teiid Designer User Guide Open Perspective a java Ga Java Browsing ge Jawa EE fel Java Type Hierarchy a JavaScript 2 JBoss AS a jBPM jPDL 3 af JMX H JPA ate Plug in Development ER Remote System Explorer Fi Resource Seam default go Team Synchronizing ee Teiid Designer web ge Web Dewelopment XML Cancel Figure C 2 Select Perspective Dialog The Telid Designer perspective is now displayed There are few additional features of perspectives to take note of The title of the window will indicate which perspective is in use Teiid Designer PartsProject PartsSourceA xmi Boss Developer Studio Ale Edit Refactor Navigate Search Project Metadata Run Window Help Figure C 3 Workbench Window Title Bar The shortcut bar may contain multiple perspectives The perspective button which is pressed in indicates that it is the current perspective To display the full name of the perspectives right click the perspective bar and select Show Text and conve
252. u sought will be highlighted in the Character Table Double click this highlighted character to place it in the Text to copy field and then click the Copy button Now switch back to your document and choose Edit Paste from the gedit menu bar The above text includes application names system wide menu names and items application specific menu names and buttons and text found within a GUI interface all presented in proportional bold and all distinguishable by context Mono spaced Bold Italic or Proportional Bold Italic Whether mono spaced bold or proportional bold the addition of italics indicates replaceable or variable text Italics denotes text you do not input literally or displayed text that changes depending on circumstance For example To connect to a remote machine using ssh type ssh username domain name at a shell prompt If the remote machine is example com and your username on that machine is john type ssh John example com The mount o remount file system command remounts the named file system For example to remount the home file system the command is mount o remount home To see the version of a currently installed package use the rpm q package command It will return a result as follows package version release Note the words in bold italics above username domain name file system package version and release Each word is a placeholder either for text you enter when issuing a command or for text disp
253. uch a case it is possible to increase the depth limit by setting the JVM property WsdlSchemaHandlerRecursiveDepth to a larger value eg D WsdlSchemaHandlerRecursiveDepth 800 This should only be used with caution as on some systems itis possible the JVM throws a StackOverFlow exception before the new depth limit is reached 96 Chapter 5 Importers En ma Warning w e es Detected possible circular references in the response schema for one or more of the selected operations which may adversely affect the generated transformations lf desired you may use the Default Procedures option instead This warning was triggered at a recursive depth of 750 If you know this was not a circular reference the recursive depth can be increased by setting the following java property and restarting DWesdlSch emaHandlerR cursiveDepth Figure 5 43 Warning message displayed if depth limit has been reached 5 8 Import WSDL Into Web Service You can create a Web Service model by selecting a WSDL file in your workspace importing WSDL files from the file system or by defining a URL The Telid Designer will interpret the WSDL locate any associated or dependent XML Schema files generate an XML View of the schema components and create a Web Service model representing the interfaces and operations defined in the WSDL There are three options for selecting the WSDL for your Web Service generation Workspace Location File System Location URL Detaile
254. ur service and click the Endpoint Address link This will retrieve your web service s WSDL and the WSDL URL address will appear in the browser s address bar Endpoint Name jboss ws context books endpaint MySqlBooks BOOKS Endpoint Address http 127 0 0 1 8060 books MySqiBooks BOOKS StartTinme StopT ine Mon Jun 11 15 16 02 CDT 2012 RequestCount ResponseCount FaultCount 0 0 0 MinProcessingTime MaxProcessingTime AvgProcessingTime 0 0 0 Now that you have your WSDL URL you can use any SOAP testing tool such as the Web Service Tester that comes with JBDS and JBoss Tools or an external tool like soapUI Using the JBoss AS Administration Console 178 Using the administration console that comes with JBoss AS you can deploy WAR files The administration console is available at http host port admin console Once logged on s simply use the Add a New Resource button of the Web Application WAR resource folder REST WAR Testing What is my URI When you modeled your REST procedures you assigned a URI for each HT TP Operation you defined along with the corresponding operation GET PUT POST or DELETE The full path of each URI is defined as Awar_context model_name resource for XML input output and war_context model_name json resource for JSON input output Using your REST URL you can use any testing tool with REST support such as the Web Service Tester included with JBDS and JBoss Tools or an external tool like soapU
255. urce X Data File Source Selection Press the Next gt button to continue Data File Source EmployeeData Available Data Files Folder location fhome blafond TestDesignerFolder FlathleData employee data Data Ale Name EmpDataRxedWidth tet EmployeeData txt Wd PlayerData tet Selected Data Ale PlayerData tet Source Model Definition Location Test mllmport Name TextfileProcedures xmi EXISTING MODEL Source model TexthleProcedures xmi already contains required getTexthles procedure Model MODEL Sere mad Ttetraceures um arends eonenna ered Cancel Finish D Bac Next gt Figure 5 11 Data File Source Selection Page a Step 4 The next page titled Flat File Column Format Definition requires defining the format of your column data in the file The options are Character delimited and Fixed width This page contains a preview of the contents of your file to aid in determining the format The wizard defaults to displaying the first 20 lines but you can change that value if you wish When finished with this page click Next gt 67 JBoss Enterprise Data Services 5 Telid Designer User Guide J Import From Flat File Source x Flat File Column Format Definition Press the Next gt button to continue P Selected Data Fle EmployeeData tet File Preview Options Number of lines in file 52 Number of preview lines 20 Select Column Format Char
256. ure 9 1 Connection Profile Information Dialog Note that if a source model has no associated connection profile the following dialog will be displayed No Connection Info Available No connection info stored in model RelModelA xmi Use Modeling gt Set Connection Profile action to select and apply connection info to model Figure 9 2 No Connection Info Dialog 9 1 3 Remove Connection Profile from Source Model As a user you may not want this connection information i e URL username etc shared through your VDB Designer provides a means to remove this connection information via a Modeling gt Remove Connection Info action When adding a source model without connection information will require the user to Supply or select the correct translator type 9 2 Previewing Data For a Model Designing and working with data is often much easier when you can see the information you re working with The Designer s Preview Data feature makes this possible and allows you to instantly preview the 187 JBoss Enterprise Data Services 5 Telid Designer User Guide information described by any object whether it s a physical table or a virtual view In other words you can test the views with actual data by simply selecting the table view procedure or XML document Previewing information is a fast and easy way to sample the data Of course to run more complicated queries like what your application likely uses simply execute the VDB Via DTP an
257. user a new model project C New gt Folder Create new folder within an existing project or folder a New gt Virtual Database Definition Create a new VDB or Virtual Database Definition Open File Enables you to open a file for editing including files that do not reside in the Workspace Close Ctrl W Closes the active editor You are prompted to save changes before the file closes Close All Shift Ctrl W Closes all open editors You are prompted to save changes before the files close El Save Ctrl S Saves the contents of the active editor lal Save As Enables you to save the contents of the active editor under another file name or location IE Save All Shift Ctrl S Saves the contents of all open editors Move Launches a Refactor gt Move resource dialog Rename F2 Launches a Refactor gt Rename resource dialog if resource selected else in line rename is preformed Refresh Refreshes the resource with the contents in the file system Convert Line Delimiters To Alters the line delimiters for the selected files Changes are immediate and persist until you change the delimiter again you do not need to save the file J Print Ctrl P Prints the contents of the active editor In the Telid Designer this action prints the diagram in the selected editor Allows control over orientation portrait or landscape scaling margins and page order User can also specify a subset of the pa
258. viceView CapitalCity response RESPONSE result ASt END E Ce Figure 3 28 Consume SOAP Wizard Click Finish to exit the wizard In the Cheat Sheet you can now continue Click iv to advance to the next step Create VDB This section of the Cheat Sheet provides instructions for creating a VDB using the models that you created in the previous step The Cheat Sheet section is shown below 49 50 JBoss Enterprise Data Services 5 Teiid Designer User Guide Cheat Sheets H gy oo Consume a SOAP Web Service v gt Introduction v Create New Telid Model Project gt Create SOAP Web Service Connection gt Create Models From SOAP Connection Create VDB Follow the steps below to create a new VDB v Launch New VDB Wizard p gt 1 Select button to browse and select wi y project or folder location 2 Enter a unique name for your VDB 3 Enter an optional description for your VDB 4 Select the Add button to choose models to go in your VDB 5 Click Finish Test VDB Figure 3 29 Create VDB VDB in your workspace When complete exit the wizard In the Cheat Sheet you can now continue Click Iv to advance to the next step 6 Test VDB This final section of the Cheat Sheet provides instructions for executing the VDB created in the previously created VDB to execute it Chapter 4 New Model Wizards Chapter 4 New Model Wizards Models are the primary resource used by the Te
259. vices 5 Telid Designer User Guide C 2 6 Problems View The Problems View displays validation errors warnings or information associated with a resource contained in open projects within your workspace a error 1 warning 0 others Description Resource Path SQL statement is empty 2 Books xmi BooksProject 2 bookCollection Problem w 4 Warnings 1 item The type referenced by column book edition must be marked as an enterprise datatype Books xmi 2 BooksProject bookCollection t Problem Figure C 21 Problems View By default the Problems View is included in the Telid Designer perspective If the Problems View is not showing in the current perspective click Window gt Show View gt Other gt General gt Problems There are 5 columns in the view s table which include 1 Description A description of the problem preceded by a severity icon i e error a warning DP or info i Resource The name of the resource Path The project name Location The object within the resource that has a validation error Dew N type Type of validation item C 2 6 1 Toolbar Menu Click the upside down triangle icon to open the View Menu icon to see various options including sorting filtering displayed columns and much more C 2 6 2 Context Menu Additional actions are available by selecting a problem and right click to open a context menu 226 Teiid Designer Ul Reference Dp si iE
260. virtual documents in the new model over to the Virtual Documents list by using the arrow button to move all elements Step 8 Select the appropriate document options and mapping options Click Finish Step 9 Click Finish to create a model of all selected document entities or optional click Next gt to view Selected Documents Statistics page which shows document entity statistics and gives you an idea the size of the model being created Step 10 Optional Click Finish to create a model of all selected document entities or click Next gt to view Preview Generated Documents page that allows you to exclude document specific entities then click Finish For deeply nested schema your total entity count may be large If so displaying the preview may take some time 4 4 Creating XML Schema Model Create XML Schema Model 04 To create a new empty XML schema xsd model Step 1 Launch the New Model Wizard Step 2 Specify a unique model name Step 3 Select XML Schema XSD option from Model Class drop down menu Step 4 Select Datatype Model from Model Type drop down menu Step 5 Click Finish Chapter 4 New Model Wizards You can change the target location i e project or folder by selecting the Browse button and selecting a project or folder within your workspace In addition to creating a new empty XML schema model the following builder option is available Copy from existing model of the same model cl
261. what columns it projects The TEXTT ABLE function is implicitly a nested table and may be correlated to preceding FROM clause entries TEXTTABLE expression COLUMNS lt COLUMN gt DELIMITER char QUOTE ESCAPE char HEADER integer SKIP integer AS name Telid Designer will construct the full SQL statement for each view table in the form SELECT A Name A Sport A Position A Team A City A StateCode A AnnualSalary FROM 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 To import from your flat file source follow the steps below Step 1 In Model Explorer choose the File gt Import action t in the toolbar or select a project folder or model in the tree and choose Import Step 2 Select the import option Teiid Designer gt File Source Flat gt gt Source and View Model and click Next gt Fx CD JBoss Enterprise Data Services 5 Telid Designer User Guide 66 Select Choose import source Select an import source gt Plug in Development gt E gt Run Debug gt Team 6 Teid Designer DDL Ale gt gt Source or View Model Designer Text Ale gt gt Source or View Models Ear Ale Source Flat gt gt Source and View Model Eyr Ale Source XML gt gt Source and View Model JDBC Database gt gt Source Model hof Sal
262. will result in any unneeded imports being removed from the model or any required imports added to the model If unchecked no updating of imports will be performed Enable Preview If the Designer Runtime feature is installed and a Teiid Instance is defined T eiid 204 c User Preferences Designer will automatically keep the preview artifacts VDBs in sync with the workspace models Unchecking this preference will disable preview feature and not create preview artifacts Enable Preview Teiid Cleanup If operating Designer with Enable Preview TRUE then this preference will result in automatic clean up of your preview artifacts from your Telid servers Any preview VDBs or preview data sources will be undeployed from your servers as part of Eclipse s shut down process Teiid Designer alle Specify values for general Designer preferences Preview Data VDB Execution Enable auto creating of a source model s data source on Teiid server VDB Execution Enable Preview Enable Preview Teiid Cleanup Teiid Designer Always open editor without prompting Open Designer perspective when a model is opened Always open Never open Prompt Check and update imports during save W Import Logical ER Models as View Relational Models Figure B 2 General Teiid Designer Preferences Panel B 1 1 Diagram Preferences Several diagram preferences are available to customize your diagrams Notations Standard diagram notation fo
263. wing a single physical model containing a single procedure called invoke This model and procedure correspond to the single port declared in the WSDL A single view model was also created containing your new procedures named after the operations declared in the WSDL For each operation a wrapper procedure was created which can be previewed in Designer Below is an example dependency diagram showing the sources for the wrapper procedure as request response procedures and the invoke source procedure 95 JBoss Enterprise Data Services 5 Telid Designer User Guide CountrylnfoService H binding string bs action string 2 55 e request XMLLiteral J endpoint string 255 J result XMLLiteral Figure 5 42 Example Web Services Wrapper Procedure 5 7 1 Circular References in WSDL Schemas It is possible for a WSDL schema to either contain a very deep set of XML type references or indeed for such references to be circular This is legal in the WSDL schema but can make processing the schema in Designer difficult If left unchecked such circular references can result ina JVM StackOverFlow exception and exiting of the application To mitigate this possibility a depth limit of 750 references has been introduced Should the depth exceed this limit then a warning is displayed and further processing of that fragment of the schema will end It may be the case that the reference in question is not circular but just very deep so in s
264. workspace MED is registered it can be deleted from the workspace if desired The registry keeps its own copy And a registered MED can always be copied back to the workspace by using the appropriate toolbar or context menu action C 2 13 Guides View To open Teiid Designer s Guides view select the main menu s Window gt Show View gt Other and select the Telid Designer gt Guides view in the dialog The Guides view provides assistance for many common modeling tasks The view includes categorized Modeling Actions and also links to Cheat Sheets for common processes Cheat Sheets are an eclipse The Guides view is shown below Teiid Designer UI Reference wa Guides amp a Status E Modeling Actions Action Sets Model JDBC Source a a Create Teiid Model Project Create JDBC connection F Create source model for JDBC data source Preview Data g Create VDB C Execute VDB Description lt no action selected gt Cheat Sheets Cheat sheets for Telid Designer use cases Create Model from JDBC Source Create Model from Flat File Source Consume a SOAP Web Service Create Model from XML Local File Source Create Model from XML Remote Source Create multi source VDB Create and test a VDB Figure C 31 Guides View The upper Action Sets section provides categorized sets of actions Select the desired category i
265. would describe each comma separated value 2 3 6 2 Modeling Your View Metadata When you create View Metadata you are not describing the nature of your physical data storage Instead you describe the way your enterprise uses the information in its day to day operations View Metadata derives its classes and attributes from other metadata You can derive View Metadata from Source Metadata that describes the ultimate sources for the metadata or even from other View Metadata However when you model View Metadata you create special views on your existing enterprise information systems that you can tailor to your business use or application expectations This View Metadata offers many benefits You can expose only the information relevant to an application The application uses this View Metadata to resolve its queries to the ultimate physical data storage You can add content to existing applications that require different views of the data by adding the View Metadata to the existing View Metadata that application uses You save time and effort since you do not have to create new models nor modify your existing applications Your applications do not need to refer to specific physical enterprise information systems offering flexibility and interchangeability As you change sources for information you do not have to change your end applications The View Metadata models document the various ways your enterprise uses the information and the
266. x metamodels relational Base H Catalog gt RelationalEntity com metamatrix metamodels relatior H Column gt RelationalEntity com metamatrix metamodels relatior H ColumnSet gt RelationalEntity com metamatrix metamodels rela DirectionKind Foreignkey gt Relationship com metamatrix metamodels relatior Index gt RelationalEntity com metamatrix metamodels relational LogicalRelationship gt Relationship com metamatrix metamodels LogicalRelationshipEnd gt RelationalEntity com metamatrix meta MultiplicityKind Nullable Type a Eee Figure C 26 Datatype Hierarchy View gt gt gt gt gt gt p gt gt gt gt ne n TO OO OF m g 231 JBoss Enterprise Data Services 5 Telid Designer User Guide C 2 10 System Catalog View To open Teiid Designer s System Catalog view select the main menu s Window gt Show View gt Other and select the Telid Designer gt System Catalog view in the dialog Model Explorer age System Catalog g v Gg SYS gt E VirtualDatabases gt H Schemas gt E Tables gt B Datatypes gt E Columns E Keys KeyColumns A z Procedures E ProcedureParams Properties Fal getCharactervVDBResource H getBinaryVDBResource ffl getVDBResourcePaths z i ReferencekeyColumns T F FFF NFTF FF getXMLSchemas H document string gt HE schemas Figure C 27 System Catalog View C 2 11 SQL Reserved Words View
267. xplorer highlighted for renaming 117 JBoss Enterprise Data Services 5 Teiid Designer User Guide v hae TwoSourceParts v fe PartsDB2 xmi b gt import declarations 2 Ha Package Diagram v PARTS El PART ID string 4 EY PART _NAME string 255 EY PART COLOR string 30 EY PART_WEIGHT string 255 NewColumn F PK_PARTS E SHIP VIA g STATUS Figure 6 2 New Model Object In Explorer e Step 1 Select the parent object to which you want to add a child For example you can add a package to a package or an attribute to a class a Step 2 Right click on a container object From the pop up menu select New Child You can now select the child object you would like to add New Child New Sibling New Association Modeling lt 2 Undo Create NewColumn Figure 6 3 New Child Action In Diagram Access Pattern Column Foreign Key Primary Key Unigue Constraint a Step 3 The new model object displays on the diagram and is highlighted for renaming PEPE P ci y Figure 6 4 New Model Object In Diagram 118 Chapter 6 Creating and Editing Model Objects Step 1 Select the row for the parent object to which you want to add a child For example to add a column click the Base Table tab and select base table row s Step 2 Right click on a table row From the pop up menu select New Child You can now select the child object you would like to add gt GB PartsVi
268. y needed in VDB 2 4 8 1 Model Extension Definition MED The purpose of a MED is to define one or more sets of extension properties Each set of extension properties pertains to one model object type or metaclass Each MED consists of the following 24 Chapter 2 Introduction Namespace Prefix a unique identifier Typically only a small number of letters and can be used as an abbreviation for the namespace URI Namespace URI a unique URI Extended Metamodel URI Model Class the metamodel URI that is being extended Each metamodel URI also has model class and that is typically what is shown in the Designer The model classes supported for extension are Relational Web Service XML Document and Function Version currently not being used Description an optional description or purpose Extended Model Object Types Metaclasses a set of model object types or metaclasses that have extension properties defined Properties the extension property definitions grouped by model object type A MED file is an XML file with an extension of mxd A MED schema file See attached modelExtension xsd file is used to validate a MED file Here is a sample MED file lt xml version 1 0 encoding UTF 8 standalone no gt lt modelExtension xmins p http org teiid modelExtension 2011 xmins xsi http www w3 org 2001 XMLSchema instance metamodelUri http www metamatrix com metamodels Relational namespacePrefix mymo
269. y of its procedure minus the CREATE VIRT UAL PROCEDURE BEGIN END keywords and the input variable declarations and assignments in the Procedure section When pasting in SQL do not include the CREATE VIRT UAL PROCEDURE BEGIN END keywords Input variables will be automatically generated when the Content via Element property is set on an operation s input parameter Input variables may be edited using the Add or Remove link in the Input Variables section and may only represent XPath values to single attributes and elements within the input contents other variable declarations and assignments must be typed directly into the Procedure section Clicking the Add or Remove link will display the following dialog 143 JBoss Enterprise Data Services 5 Telid Designer User Guide Edit Input Variables Request Document Input Variables Check a request document component to define an input variable for the Web Service Select an input variable to see procedure Uncheck a request document component to delete an existing input the XPath that will be used to Variable select its value from the lt v e bookCollection BooksNS BookSetNested request document v lel book BooksNS BookNested IN_author string isbn BookTypesNS ISBN IN_edition string O title xsd string IN_ isbn string subtitle xsd string IN_publishDate string e edition BookTtypesNS BookEdition IN_publisher string gt C E authors BooksNS Authors IN_subtitle
270. yable This will cause you WAR file to be automatically deployed the JBoss AS instance you have defined 177 JBoss Enterprise Data Services 5 Telid Designer User Guide v SoapyBooksProject A BooksWS vdb C Dynamic Web Project ay E lanna Fr Ado Pie oat B New b b EY MySqlBooks C M MySq Open b MySglBooks V N 6 Copy gt Ga MySqliBooks xr Paste ctr V b gS test Delete b 52 US States Refactor b ey Import ey Export Refresh 3 Mark as Deployable Validate Using the JBoss AS Administration Console Using the administration console that comes with JBoss AS you can deploy WAR files The administration console is available at http host port admin console Once logged on simply use the Add a New Resource button of the Web Application WAR resource folder Manual Deployment to JBossAS It is possible to deploy the generated WAR by manually copying the file to the deploy folder of the target JBoss AS If the server is running the WAR will deploy automaticall via hot deploy Otherwise the WAR will deploy at the next start of the server 7 4 2 4 Testing Your Generated WAR Files Once you have deployed your war file you are ready to test it out There are a few ways to accomplish this SOAP WAR Testing Determining Your WSDL URL You can get your WSDL URL at http server port jbossws services This is where all the deployed web services for the target JBossAS server will be listed Find yo

JBoss Enterprise Data Services 5 Teiid Designer User Guide

Contents

Download Pdf Manuals

Related Search

Related Contents