選取您的 Cookie 偏好設定

我們使用提供自身網站和服務所需的基本 Cookie 和類似工具。我們使用效能 Cookie 收集匿名統計資料,以便了解客戶如何使用我們的網站並進行改進。基本 Cookie 無法停用,但可以按一下「自訂」或「拒絕」以拒絕效能 Cookie。

如果您同意,AWS 與經核准的第三方也會使用 Cookie 提供實用的網站功能、記住您的偏好設定,並顯示相關內容,包括相關廣告。若要接受或拒絕所有非必要 Cookie,請按一下「接受」或「拒絕」。若要進行更詳細的選擇,請按一下「自訂」。

JDBC connector for Amazon AppFlow - Amazon AppFlow
此頁面尚未翻譯為您的語言。 請求翻譯

JDBC connector for Amazon AppFlow

Java Database Connectivity (JDBC) is a Java API that developers use to connect their applications to relational databases. JDBC is included in the Java Standard Edition from Oracle. You can use Amazon AppFlow to transfer data from a databases by a creating a JDBC connection. Then you can transfer the data to other databases, AWS services, or other supported applications.

Amazon AppFlow support for JDBC

Amazon AppFlow supports JDBC as follows.

Supported as a data source?

Yes. You can use Amazon AppFlow to transfer data from databases through the JDBC API.

Supported as a data destination?

Yes. You can use Amazon AppFlow to transfer data to databases through the JDBC API.

Before you begin

Before you can use Amazon AppFlow to transfer data to or from a database using the JDBC connector, you must have one or more databases that support and are enabled for JDBC API access. For more information about installing the JDBC driver, see the JDBC documentation for your version of Java, such as the JDBC Getting Started documentation in the Oracle Java SE 8 Documentation.

From your database settings, note the endpoint name and port. You provide these values, along with your database user name and password, to Amazon AppFlow when you connect to your database.

Connecting Amazon AppFlow to a database through JDBC

To connect Amazon AppFlow to your database through the JDBC API, provide details from your database settings so that Amazon AppFlow can access your data.

To connect through JDBC
  1. Sign in to the AWS Management Console and open the Amazon AppFlow console at https://console.aws.amazon.com/appflow/.

  2. In the navigation pane on the left, choose Connections.

  3. On the Manage connections page, for Connectors, choose JDBC.

  4. Choose Create connection.

  5. In the Connect to JDBC window, enter the following information:

    • driver — Choose mysql or postgresql depending on the type of database where you want to connect.

    • hostname — The hostname associated with the database that you're connecting to.

    • port — The port that is activated for JDBC access to the database.

    • username — The user name for a user that has access to the database.

    • password — The password associated with the user name.

    • database — The name of the database where you want to connect.

  6. Optionally, under Data encryption, choose Customize encryption settings (advanced) if you want to encrypt your data with a customer managed key in the AWS Key Management Service (AWS KMS).

    By default, Amazon AppFlow encrypts your data with a KMS key that AWS creates, uses, and manages for you. Choose this option if you want to encrypt your data with your own KMS key instead.

    Amazon AppFlow always encrypts your data during transit and at rest. For more information, see Data protection in Amazon AppFlow.

    If you want to use a KMS key from the current AWS account, select this key under Choose an AWS KMS key. If you want to use a KMS key from a different AWS account, enter the Amazon Resource Name (ARN) for that key.

  7. For Connection name, enter a name for your connection.

  8. Choose Connect.

On the Manage connections page, your new connection appears in the Connections table. When you create a flow that uses JDBC as the data source, you can select this connection.

Transferring data to or from a database through JDBC

To transfer data to or from a database through the JDBC API, create an Amazon AppFlow flow, and choose JDBC as the data source or the data destination. For the steps to create a flow, see Creating flows in Amazon AppFlow.

When you configure the a flow that uses the JDBC connector as a source or destination, you set the following options:

  • connection – The Amazon AppFlow JDBC connection that you created.

  • API Version – The supported JDBC API version.

  • object – Typically, the database schema.

  • subobject – Typically, the name of the database table that you want to transfer data to or from.

Supported destinations

When you create a flow that uses JDBC as the data source, you can set the destination to any of the following connectors:

下一個主題:

Jira Cloud

上一個主題:

Intercom
隱私權網站條款Cookie 偏好設定
© 2025, Amazon Web Services, Inc.或其附屬公司。保留所有權利。