/talend-tdbresultstojson

Talend tDBResultsToJson component

GNU General Public License v3.0GPL-3.0

License

tDBResultsToJSON

  • Version 1.0

Converts a database result set to a generic JSON string

Overiew of job flow

Alt text

Setting up the datbaase components

  1. Use a DBConnection component
  2. The schema will include one column of type Object which is set to pass the ResultSet to the next component

Alt text

Alt text

Passing the database connection object

  1. Pass the DB connection object by calling a global get

Alt text

Configuring the features of the tDBResultsToJSON component

  1. Define if the DATA, STRUCTURE, or BOTH should be inlcuded in the JSON
  2. Define how to handle NULL values

Alt text

  1. Change the advanced setting when including STRUCTURE based on the type of database platform

Alt text

JSON produced from SQL query

Alt text

Alt text