OpenDeploy_16.3_DB_Deploy_Admin_Guide_en_rev1.pdf - Database Deployment for OpenDeploy Administration Guide Release 16.3 TM OpenText TeamSite Database

OpenDeploy_16.3_DB_Deploy_Admin_Guide_en_rev1.pdf -...

This preview shows page 1 - 5 out of 205 pages.

Database Deployment for OpenDeploy Administration Guide Release 16.3
Image of page 1
OpenText TM TeamSite Database Deployment for OpenDeploy Administration Guide Rev.: October 2017 This documentation has been created for software version 16.3. It is also valid for subsequent software versions as long as no new document version is shipped with the product or is published at . Open Text Corporation 275 Frank Tompa Drive, Waterloo, Ontario, Canada, N2L 0A1 Tel: +1-519-888-7111 Toll Free Canada/USA: 1-800-499-6544 International: +800-4996-5440 Fax: +1-519-888-0677 Support: For more information, visit Copyright © 2017 Open Text. All Rights Reserved. Trademarks owned by Open Text. Disclaimer No Warranties and Limitation of Liability Every effort has been made to ensure the accuracy of the features and techniques presented in this publication. However, Open Text Corporation and its affiliates accept no responsibility and offer no warranty whether expressed or implied, for the accuracy of this publication.
Image of page 2
Table of Contents Chapter 1: Introduction 9 Overview 9 Install OpenDeploy and DataDeploy 9 Required Database Privileges 10 Invoke Database Deployments 10 Data Deployment Uses 10 Introductory Concepts 11 XML Defines Structured Content 11 Databases Store Structured Content 12 Map the XML Representation to the Database Schema 13 Deploy XML to the Database 14 Architectural Overview 15 Use Case Matrix 16 Chapter 2: Deployment Concepts 19 Deployment Categories 19 Overview of Database Deployment Process 19 Source/Destination Configurations 20 User-Defined Database Schemas 20 Sample Deployment Scenario 21 Update and Table Types 21 Data Sources 22 Data Organization and Tuples 23 Deployment Sequence 26 Chapter 3: Configuration Files 31 Configuration Overview 31 Map a Database Schema 31 Map a Database Schema with the Browser-Based User Interface 32 Set the Mapping Parameters 33 Map to an Existing Database Schema 34 Create a Database Schema File 34 Update an Existing Database Schema File 38 Map a Database Schema with iwsyncdb 39 Create dbschema.cfg Files 39 Validate dbschema.cfg Files 39 Validate dbschema.cfg Files using iwsyncdb -ddgen or -initial 40 Validate dbschema.cfg Files using iwsyncdb -validate 40 3
Image of page 3
Create the DataDeploy Configuration File 40 Using the Browser-Based User Interface 41 Use the iwsyncdb -ddgen Command 44 Deploy Multiple XML-Formatted Files as a List of Filelists 45 Sample Configuration Files 46 TeamSite-to-Database 46 TeamSite-to-XML 49 TeamSite Extended Attributes-to-Database 50 TeamSite Extended Attributes-to-XML 52 TeamSite and TeamSite Extended Attributes-to-Database 54 Formatted XML-to-Database 56 Formatted XML-to-Formatted XML 57 XML-to-Database 58 XML-to-Formatted XML 60 Database-to-XML 62 Specify the Database Connection Properties 66 Database Configuration File 66 Invoke Deployment 67 Deploy Metadata to a User-Defined Database 67 Change the Default Datatype Size on Internal Tables 68 Tablespace Attribute Usage in CREATE TABLE Statements 70 Vendor-Specific Configuration File Settings 71
Image of page 4
Image of page 5

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture