topic Can Talend write to an Azure SQL Server Database in Talend Studio

Can Talend write to an Azure SQL Server Database

Anonymous — Wed, 11 May 2016 18:07:04 GMT

I'm running 6.1... I'm able to create and successfully confirm as connection with an Azure SQL Server, but I'm not able to write to it. Is Azure SQL Server not supported yet. I cannot find much information on this site with the word "Azure" in it.

Re: Can Talend write to an Azure SQL Server Database

talendtester — Wed, 11 May 2016 22:43:34 GMT

Some links I found:
https://help.talend.com/search/all?query=Microsoft+Azure&content-lang=en
https://help.talend.com/search/all?query=tAzureStorageContainerCreate&content-lang=en
https://www.youtube.com/watch?v=pq9QlFO_g0M

Re: Can Talend write to an Azure SQL Server Database

Anonymous — Thu, 12 May 2016 18:34:41 GMT

@talendtester I'm not writing to a Microsoft Azure Storage container but an Azure SQL Server database. I haven't found any documentation that shows how to do that. My approach has been as follows
1) In the"Tree" I clicked on Metadata and then right clicked on Db Connections and clicked on create connections.
2) In entered in all the appropriate information and then Clicked "Check" THIS WAS Successful.
3) So assuming the connection is good, I put a tMSSqlOutput in my workflow and tried to run it. Nothing is ever written to the database and I get the following errors. I'm fairly weak with Java so I'm not sure what the following means.
I/O Error: Connection reset by peer: socket write error
Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)
at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767)
at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722)
at net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:966)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.close(JtdsPreparedStatement.java:707)
at beginnersguide.uscensusshipments_0_1.USCensusShipments.tFileInputExcel_2Process(USCensusShipments.java:3573)
at beginnersguide.uscensusshipments_0_1.USCensusShipments.tFileFetch_2Process(USCensusShipments.java:523)
at beginnersguide.uscensusshipments_0_1.USCensusShipments.runJobInTOS(USCensusShipments.java:3923)
at beginnersguide.uscensusshipments_0_1.USCensusShipments.main(USCensusShipments.java:3780)

Re: Can Talend write to an Azure SQL Server Database

Anonymous — Fri, 20 May 2016 20:31:35 GMT

Same for me.
On Windows 10 and TOS DI 6.1.1
Connection to Azure SQL works in design-time but failing during runtime:

I/O Error: Connection reset by peer: socket write error
Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the Connection object is closed.
	at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)
	at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767)
	at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:1030)
	at adwh.gen_0_1.gen.tRowGenerator_1Process(gen.java:837)
	at adwh.gen_0_1.gen.runJobInTOS(gen.java:1221)
	at adwh.gen_0_1.gen.main(gen.java:1078)

Re: Can Talend write to an Azure SQL Server Database

Anonymous — Thu, 06 Apr 2017 10:10:00 GMT

Hey guys,
I stucked with exactly same problem.
Has anybody solved it?