REST API Reference

Back Next

JDBC V2 targets

When the target connection of the task target is JDBC V2, you can include the following fields and key-value pairs in the config array of the target connection:

Key	Type	Required	Description
Table Name	String	Yes	Name of the table to insert data to in JSON format. Enter a string of up to 988 characters.

POST request example

To update a

streaming ingestion and replication

task with a flat file source and a JDBC V2 target, you might send a request similar to the following example:

POST <serverUrl>/sisvc/restapi/v1/UpdateEntity/Documents('<document ID>')
Content-Type: application/json
Accept: application/json
IDS-SESSION-ID: <SessionId>

{
  "name": "FileFile to jdbc",
  "description": "FileToFile to jdbc_target",
  "runtimeId": "01000025000000000003",
  "locationId": "5sJ0JDyJyWLlrosS5qJjsQ",
  "currentVersion": "2",
  "messageFormat": "binary",
  "nodes": [
    {
      "name": "flatfile to jdbc_source",
      "type": "source",
      "connectionId": "012MGS0B00000000002N",
      "transformationType": "",
      "config": [
        {
          "key": "initialPosition",
          "value": "Current Time"
        },
        {
          "key": "tailingMode",
          "value": "Single file"
        },
        {
          "key": "rolloverPattern",
          "value": "test"
        },
        {
          "key": "File",
          "value": "logfile"
        }
      ]
    },
    {
      "name": "flatfile to jdbc_target",
      "type": "target",
      "connectionId": "012MGS0B0000000000KF",
      "transformationType": "",
      "config": [
        {
          "key": "Table Name",
          "value": "table"
        }
      ]
    }
  ],
  "edges": [
    {
      "from": "flatfile to jdbc_source",
      "to": "flatfile to jdbc_target"
    }
  ]
}

The response returns only the fields that you entered in the request. If the request is unsuccessful, the response includes a reason for the failure.

POST response example

If the request is successful, you might receive a response similar to the following example in a

Success

node:

{
  "Success": {
    "name": "FileFile to jdbc",
    "description": "FileToFile to jdbc_target",
    "runtimeId": "01000025000000000003",
    "locationId": "5sJ0JDyJyWLlrosS5qJjsQ",
    "currentVersion": "2",
    "messageFormat": "binary",
    "nodes": [
      {
        "name": "flatfile to jdbc_source",
        "type": "source",
        "connectionId": "012MGS0B00000000002N",
        "transformationType": "",
        "config": [
          {
            "key": "initialPosition",
            "value": "Current Time"
          },
          {
            "key": "tailingMode",
            "value": "Single file"
          },
          {
            "key": "rolloverPattern",
            "value": "test"
          },
          {
            "key": "File",
            "value": "logfile"
          }
        ]
      },
      {
        "name": "flatfile to jdbc_target",
        "type": "target",
        "connectionId": "012MGS0B0000000000KF",
        "transformationType": "",
        "config": [
          {
            "key": "Table Name",
            "value": "table"
          }
        ]
      }
    ],
    "edges": [
      {
        "from": "flatfile to jdbc_source",
        "to": "flatfile to jdbc_target"
      }
    ]
  }
}

Rename Saved Search

Table of Contents

REST API Reference

REST API Reference

JDBC V2 targets

JDBC V2 targets

POST request example

POST response example