Talend Open Studio for Data Integration: Lesson 2 – Creating a MS SQL Connection

The first thing you need to do once you have a Talend Project created is define your connections that data will be extracted from or where it will be written to.

Microsoft SQL Server is a good example of a database that many users will need to work with in ETL, so we will cover how to add that to your project in Talend.

1.  Create the Connection in Talend Repository

In your open project, look for the Repository.  This is where you will find many different objects available within your Talend project.  Specifically for adding a connection, we are going to expand the Metadata category within the repository.  Then you will need to right-click on “Db Connections” and choose “Create Connection”

Step 1 in Creating a Microsoft SQL Connection in Talend ETL
In the Talend project repository, right click on Db Connections under Metadata to add a connection to MS SQL

 

2.  Enter MS SQL Connection Name

You will then be prompted with a dialog box that will walk you through creating your connection.  In the first box which is step 1/2, enter at least a name for your connection and then click Next.

Step 2 in Creating a Microsoft SQL Connection in Talend ETL
Enter a name for your Microsoft SQL connection in Talend ETL

3.  Enter MS SQL Connection Details

Next, enter the details needed to define your connection.  Make sure to use SQL server authetication by entering a Login and Password.  Currently, Windows Authentication with SQL Server 2008 is not consistent.  After you have entered the details click “Finish”

Step 3 in Creating a Microsoft SQL Connection in Talend ETL
Enter the MS SQL connection details and click Finish

 

4.  Verify

You will now see your connection under Metadata in the Talend Repository

Adding a MS SQL connection in Talend Open Studio ETL
You will now see your Microsoft SQL connection created in Talend ETL

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>