Continued from Part 1 Part 2: MongoDB → JSON Step 1: Create a new job Create a separate job from Part 1. We will begin by placing a tMongoDBInput component and connecting it to a tLogRow component. In this job, we are only going to pull one of the three JSON items we loaded into the
One NoSQL database connector included in Talend Open Studio for Big Data is MongoDB, and using it is quite simple. This tutorial will show the functionality of the different components by importing files into MongoDB from a JSON file, and then exporting a JSON file from MongoDB. This
When connecting to a database in Talend Open Studio it is very important to utilize standard best practices that will enable you to access this connection during job design and to manage multiple database environments such as Dev, QA and Prod. This tutorial will walk you through the
This post is an extension of our previous post here – Import an Excel file into Access . Today we are going to show you how to build on this job in order to iterate upon a group of excel files in a specified file directory, enabling you to automate the bulk loading of multiple e
Sometimes integrating Talend with Excel data files can be particularly challenging, in this post we are going to walk you through the basic steps required to get started on build a job to load a MS Excel file into an Access database. You can download the example excel file used in thi
ETL Advisors is a leading data integration consulting firm, specializing in Talend Enterprise Platform and Talend Open Studio development. Our expert consultants have over 8 years direct Talend development experience in Talend Data Integration, Data Quality, MDM, ESB & Big Data products.