| |
| //// |
| Licensed to the Apache Software Foundation (ASF) under one |
| or more contributor license agreements. See the NOTICE file |
| distributed with this work for additional information |
| regarding copyright ownership. The ASF licenses this file |
| to you under the Apache License, Version 2.0 (the |
| "License"); you may not use this file except in compliance |
| with the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| //// |
| |
| The +metastore+ tool configures Sqoop to host a shared Hsqldb metadata repository. |
| This tool basically just starts Hsqldb, while the +job tool+ creates the necessary |
| tables that will contain the job metadata if they don't exist. |
| |
| Multiple users and/or remote users can define and execute saved jobs (created |
| with +sqoop job+) defined in this metastore. |
| |
| Clients must be configured to connect to the metastore in +sqoop-site.xml+ or |
| with the +--meta-connect+ argument. Sqoop supports MySql, Hsqldb, PostgreSql, Oracle, DB2, |
| and SqlServer as the +metastore+ server implementations, but please note that |
| the +metastore+ tool can only manage the startup and shutdown |
| of Hsqldb so far. |
| |
| All services other than Hsqldb and Postgres require the download of the |
| corresponding JDBC driver and connect string structured in the correct format. |
| |
| Migration of metastore data from one database service to another is not directly supported, but is possible. |
| |
| .JDBC Connection String Formats: |
| [grid="all"] |
| `---------------------------`------------------------------------------ |
| Service Connect String Format |
| ----------------------------------------------------------------------- |
| +MySQL+ jdbc:mysql://<server>:<port>/<dbname> |
| +HSQLDB+ jdbc:hsqldb:hsql://<server>:<port>/<dbname> |
| +PostgreSQL+ jdbc:postgresql://<server>:<port>/<dbname> |
| +Oracle+ jdbc:oracle:thin:@//<server>:<port>/<SID> |
| +DB2+ jdbc:db2://<server>:<port>/<dbname> |
| +MSSQL+ jdbc:sqlserver://<server>:<port>;database=<dbname> |
| ----------------------------------------------------------------------- |
| |
| |