Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to JSON Target Connector
  3. JSON Target Connections
  4. Synchronization Tasks with JSON Target Connector
  5. Troubleshooting

JSON Target Connector

JSON Target Connector

Back Next

How JSON Target Connector Works

How JSON Target Connector Works

Let us consider a sample JSON file, which provides Customer-Address details, to explain how JSON Target Connector works.
JSON Target Connector is based on the following principles:
  • The XPaths are the building blocks of JSON Target Connector.
  • JSON Target Connector parses the JSON file and generates the XPaths of each JSON object or JSON array.
  • JSON Target Connector uses the XPaths to generate XML file with adequate primary and foreign key relationships.
  • The XMLStreamReader and XMLStreamWriter cleans the generated XML file.
  • The cleaned XML file is transformed into a valid JSON file based on the SAXevent parsing approach.
The following figure shows a sample JSON file of Customer - Address details.
This figure shows a sample JSON file of Customer - Address details.
JSON Target Connector follows the following principles to group elements into tables or fields:
  • JSON file must have root element. When the JSON file does not contain any root element, then the connector creates a dummy root called JSONRoot. The root element is used for further processing of files.
  • All the simple and attribute elements are considered as fields. Complex elements are not considered as fields.
  • Unbound elements are segregated and considered as separate tables.
  • Any bound element to the former element becomes the child element of the former element.
    Based on the sample file shown in the above figure, the following tables are created:
    • Table-1: JsonRoot with XPath/JsonRoot
    • Table-2: Customers_Customer_Address with XPath/Customers/Customer/Address
The following figure shows the tables written to the target:
This figure shows the tables written to the target.
0 COMMENTS
We’d like to hear from you!