Package org.odpi.openmetadata.adapters.connectors.integration.jdbc.transfer.requests

Class Jdbc

java.lang.Object
org.odpi.openmetadata.adapters.connectors.integration.jdbc.transfer.requests.Jdbc
public class Jdbc extends Object
Utility class that delegates requests to jdbc

  • Field Details

  • Constructor Details

  • Method Details

    • getUserName

      public String getUserName()
      Get username
      Returns:
      username

    • getUrl

      public String getUrl()
      Get url
      Returns:
      url

    • getDriverName

      public String getDriverName()
      Get driver name
      Returns:
      driver name

    • getDatabaseProductVersion

      public String getDatabaseProductVersion()
      Get database product version
      Returns:
      database product version

    • getDatabaseProductName

      public String getDatabaseProductName()
      Get database product name
      Returns:
      database product name

    • getTables

      public List<JdbcTable> getTables(String catalog, String schemaName)
      Get all tables of a schema
      Parameters:
      schemaName - schema name
      Returns:
      tables

    • getViews

      public List<JdbcTable> getViews(String catalog, String schemaName)
      Get all views of a schema
      Parameters:
      schemaName - schema name
      Returns:
      views

    • getImportedKeys

      public List<JdbcForeignKey> getImportedKeys(String catalog, String schemaName, String tableName)
      Get foreign keys as described by the primary key columns referenced by foreign key columns of target table
      Parameters:
      catalog - catalog
      schemaName - schema name
      tableName - table name
      Returns:
      foreign keys

    • getExportedKeys

      public List<JdbcForeignKey> getExportedKeys(String catalog, String schemaName, String tableName)
      Get foreign keys as described by the foreign key columns referenced by primary key columns of target table
      Parameters:
      catalog - catalog
      schemaName - schema name
      tableName - table name
      Returns:
      foreign keys

    • getPrimaryKeys

      public List<JdbcPrimaryKey> getPrimaryKeys(String schemaName, String tableName)
      Get table primary keys
      Parameters:
      schemaName - schema name
      tableName - table name
      Returns:
      primary keys

    • getColumns

      public List<JdbcColumn> getColumns(String catalog, String schemaName, String tableName)
      Get all column of table
      Parameters:
      schemaName - schema name
      tableName - table name
      Returns:
      columns

    • getSchemas

      public List<JdbcSchema> getSchemas(String catalog)
      Get all schemas
      Returns:
      schemas

    • getCatalogs

      public List<JdbcCatalog> getCatalogs()
      Get all catalogs
      Returns:
      schemas

    • getTableTypes

      public List<String> getTableTypes()
      Get supported table types
      Returns:
      table types