MongoDB + JSON Part Two

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
Continue Reading →

MongoDB + JSON Part One

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
Continue Reading →

Using Contexts to Manage Multiple DB Environments

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
Continue Reading →

Iterate to load multiple excel files

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
Continue Reading →

Import an excel file into ms access

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
Continue Reading →