JDBC Connections

These connections are used to migrate data from a JDBC source(s) to Amorphic Data Platform. Using these connections, data can be written directly into an Amorphic Dataset.

Following are the fields required to establish a JDBC connection,

  • Data load type
    There are two types of JDBC Connections available depending on the data load type,
    • Bulk data load
    • Normal data load
  • Connection Accessibility
    The accessibility type depend on where the data source resides. Following are two options available
    • Publicly Accessible Connection
    • Private Connection
  • JDBC connection url
    The data source’s JDBC connection url from which the data is to be migrated
  • Username
    Username for the data source
  • Password
    Password for the data source
  • SSL
    This field only applies to the Normal data load connections and is used when additional level of security needs to be enforced.

What Data load types apply to your use case?

As mentioned above, Amorphic recognizes JDBC connections as either Bulk or Normal data loads.

  • Bulk data load connections

    Bulk load connections are recommended to the user(s) who wish to migrate quite a few number of tables or significant amount of data. The user entered JDBC url format varies on the database in use. Currently the following data source(s) are supported with this connection type,

    • Oracle
    • MySQL
    • PostgreSQL

    Creating a Bulk data load JBDC connection can be done as shown in the image below,

    JDBC Bulk Load Connection

    Note: For more details, Please check the documentation on How to set up a bulk data load in Amorphic

  • Normal data load connections

    Normal load connections are recommended to the user(s) who wish to migrate one table or data that is smaller in size. The user entered JDBC url format varies on the database in use. This connection supports all the data sources that AWS Glue supports (here) as follows,

    • Amazon Redshift
    • Amazon Relational Database Service
      • Amazon Aurora
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL
    • Publicly accessible databases
      • Amazon Aurora
      • MariaDB
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL

    Creating a Normal data load JBDC connection can be done as shown in the image below,

    JDBC Normal Load Connection