Four Stars

Importing CSV, transforming field type, and outputting to MS SQL Server

Hi -- I am new to Talend and ETL.

 

I have a csv that I need to bring into Talend.  I need to review the types for each of the fields, then I need to change one of them.  Then I need to output to a local MS SQL Server DB.

 

I've been poking around YouTube videos and Google, but haven't really found what I'm looking for.

 

Any help would be greatly appreciated.

5 REPLIES
Twelve Stars

Re: Importing CSV, transforming field type, and outputting to MS SQL Server

@CD9999,create a metadata fro csv in repository of Talend and create a job and use that metadata as tFileinputDelimited and connect to tMSsqlOutput to tFileinputDelimited .

Manohar B
Four Stars

Re: Importing CSV, transforming field type, and outputting to MS SQL Server

I only see tMSSqlConnection – not tMSSqlOuput. Is it the same thing?
Nine Stars

Re: Importing CSV, transforming field type, and outputting to MS SQL Server

No, they are different.
Goto Palette -> Databases -> MS Sql Server
You would then find all the components related to MS Sql Server.
Four Stars

Re: Importing CSV, transforming field type, and outputting to MS SQL Server

Ah ok – I see “tDBOutput(Microsoft SQL Server)” – I’m assuming that’s it.

How would I pull the schema from my MSSQL Server DB so that I can compare incoming datasets to the schema I currently have (and make adjustments to the DB schema as necessary)?
Employee

Re: Importing CSV, transforming field type, and outputting to MS SQL Server

Hi,

 

     Please refer the link below to understand how we can retrieve the all table schema from a DB using Talend Metadata.

 

https://help.talend.com/reader/hULYZJz6QBG0R8nvFrppxQ/EntMthts4SKiXVAFTv9Ypw

 

    If the details have helped you, could you please mark the topic as resolved?

 

Warm Regards,

 

Nikhil Thampi