How to ingest multiple tables to Amorphic using JDBC connection?
info
- Follow the steps mentioned below.
- Total time taken for this task: 20 Minutes.
- Pre-requisites: User registration is completed, logged in to Amorphic and role switched
Tidbits
- Create a JDBC connection and migrate data to Amorphic. Many options are available depending on your use-case.
- Amorphic leverages AWS DMS service for migrating data.
JDBC data ingestion
You need to have a
Postgres DB password
to get started. Please contact adminClick here for instructions to ingest data.
You can do more...
Try few other types of use cases using the same Database/tables as a source. Few examples are
- Migrate single table from RDBMS to Amorphic.
- Migrate multiple tables with CDC as migration type.
- Migrate multiple tables to existing amorphic S3 dataset.
- Change the destination to S3 or S3Athena.
- Migrate data with
reload
as an update method.