Preface

This manual describes Adapter for JDBC, an utility replicating modified data in Altibase to other database supporting JDBC.

Audience

This manual has been prepared for the following Altibase users:

• Database administrators
• Performance administrators
• Database users
• Application developers
• Technical Supporters

It is recommended for those reading this manual possess the following background knowledge:

• Basic knowledge in the use of computers, operating systems, and operating system utilities
• Experience in using relational database and an understanding of database concepts
• Computer programming experience
• Experience in database server management, operating system management, or network administration

Organization

This manual is organized as follows:

• Chapter 1: Introduction
  This chapter introduces Migration Center and explains how to install it.

• Chapter 2: Getting Started
  This chapter describes the key concepts in migration, how to use Migration Center in GUI and CLI modes, and tools provided for user convenience.

• Chapter 3: GUI Mode Quick Guide
  This chapter provides a quick step guide for GUI mode users who are new to Migration Center.

• Chapter 4: CLI Mode Quick Guide
  This chapter provides a quick step guide for CLI mode users who are new to Migration Center.

• Chapter 5: Migration Center Internals
  This chapter describes the main steps of Migration Center, namely the Build, Reconcile, Run, and Data Validation steps.

• Appendix A: Migration Options
  This appendix describes the Migration Center options.

• Appendix B: Migratable Database Objects
  This appendix provides the table that shows what database objects can be migrated using Migration Center.

• Appendix C: Data Type Mapping
  This appendix explains how to check and customize the default data type mapping for an existing project. In addition, it provides default data type mapping tables

• Appendix D: Mapping Default Values
  This appendix provides the mapping table for default values according to which Migration Center converts source database default values to comply with Altibase.

• Appendix E: PSM Converter Rule List
  This chapter describes the rules for converting PSM convertes to DDL SQL statements when migrating from Oracle to Altibase.

• Appendix F: FAQ

Documentation Conventions

This section describes the conventions used in this manual. Understanding these conventions will make it easier to find information in this manual and in the other manuals in the series.

There are two sets of conventions:

• Syntax diagram convetions
• Sample code conventions

Syntax Diagram Conventions

This manual describes command syntax using diagrams composed of the following elements:

Elements	Meaning
	Indicates the start of a command. If a syntactic element starts with an arrow, it is not a complete command.
	Indicates that the command continues to the next line. If a syntactic element ends with this symbol, it is not a complete command.
	Indicates taht the command continues from the previous line. If a syntactic element starts witht his symbol, it is not a complete command.
	Indicates the end of a statement.
	Indicates a manatory element.
	Indicates an optional element.
	Indicates a mandatory element comprised of options. One, and only one, option must be specified.
	Indicates an optional element comprised of options.
	Indicates an optional element in which multiple elements may be specified. A comman must precede all but the first element.

Sample Code Conventions

The code examples explain SQL statements, stored procedures, iSQL statements, and other command line syntax.

The following table describes the printing conventions used in the code examples.

Rules	Meaning	Example
[ ]	Indicates an optional item	VARCHAR [(size)] [[FIXED |] VARIABLE]
{ }	Indicates a mandatory field for which one or more items must be selected.	{ ENABLE | DISABLE | COMPILE }
|	A delimiter between optional or mandatory arguments.	{ ENABLE | DISABLE | COMPILE } [ ENABLE | DISABLE | COMPILE ]
. . .	Indicates that the previous argument is repeated, or that sample code has been omitted.	SQL> SELECT ename FROM employee; ENAME ----------------------- SWNO HJNO HSCHOI . . . 20 rows selected.
Other Symbols	Symbols other than those shown above are part of the actual code.	EXEC :p1 := 1; acc NUMBER(11,2)
Italics	Statement elements in italics indicate variables and special values specified by the user.	SELECT * FROM table_name; CONNECT userID/password;
Lower case words	Indicate program elements set by the user, such as table names, column names, file names, etc.	SELECT ename FROM employee;
Upper case words	Keywords and all elements provided by the system appear in upper case.	DESC SYSTEM_.SYS_INDICES_;

Related Documentations

For more detailed information, please refer to the following documents.

• Installation Guide

• Getting Started Guide

• Administrator’s Manual

• Replication Manual

• Precompiler User’s Manual

• API User’s Manual

• Altibase C Interface Manual

• iSQL User’s Manual

• Utilities Manual

• General Reference

• Error Message Reference

Altibase Welcomes Your Comments and Feedbacks

Please let us know what you like or dislike about our manuals. To help us with better future versions of our manuals, please tell us if there is any corrections or classifications that you would find useful.

Include the following information:

• The name and version of the manual that you are using
• Any comments about the manual
• Your name, address, and phone number

If you need immediate assistance regarding any errors, omissions, and other technical issues, please contact Altibase's Support Portal.

Thank you. We always welcome your feedbacks and suggestions.