How to Extract from MS SQL Database

One Star

How to Extract from MS SQL Database

Hi all,
I'm new to Talend and would appreciate any pointers/advice.
Objective: Create an output (Can be Excel) using a MS SQL query that joins several tables within a MS SQL Database.
So far, I've managed to create the DB Connection successfully, Create the Meta Data of all Tables within the Database.
then created: tMSSQLinput  -> Tmap -> Exceloutput. 
Which works just fine for simple extracts of individual and basic joins of more than one table in the database. However the query that I want to run is far more complex. Ideally, I'd like to run the query on the MS SQL database within Talend, view the data, and save the extract in an excel output file. 
I've saved the Query under the Queries drop down of the Db connection, and it returns columns when I run it through the SQL builder window, but on the canvas it doesn't create any meta data which I can then output in excel. 
I think I'm not using the right features of Talend. If anyone could point me in the right direction would be really grateful. Happy to elaborate further if I've not explained clearly my problem.
Thanks in advance
Moderator

Re: How to Extract from MS SQL Database

Hi,
Could you please take a look at document about:TalendHelpCenter:Centralizing database metadata to see if it is what you are looking for?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now