Table of Contents

Search

  1. Preface
  2. Informatica Intelligent Cloud Services REST API
  3. Platform REST API version 2 resources
  4. Platform REST API version 3 resources
  5. Data Integration REST API
  6. Mass Ingestion Files REST API
  7. Mass Ingestion Streaming REST API
  8. RunAJob utility
  9. ParamSetCli utility
  10. REST API codes
  11. REST API resource quick references

REST API Reference

REST API Reference

Connection configuration for tasks with JDBC V2 as a target

Connection configuration for tasks with JDBC V2 as a target

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
task with a flat file source and a JDBC V2 target, you might send a request similar to the following example:
{ "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" } ] }

0 COMMENTS

We’d like to hear from you!