Is it possible to load sql server with the help of Talend application

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

sarahjohns388
Posts: 2
Joined: Mon May 07, 2018 11:14 am

Is it possible to load sql server with the help of Talend application

Post by sarahjohns388 » Mon May 07, 2018 11:28 am

Hello All, hope all doing. I have faced an issue with Is it possible to load SQL server with the help of Talend application I need help from you guys.

The problem is, I was not able to load PATSTAT data into our SQL Server database with Talend application. In this, I had created a table but the data can't able to transfer to the table. I was able to get the log files but there is no flow, as usual, it should be happened. Can one help me on this?

Thanks
Sarahjohn


EPO / PATSTAT Support
Posts: 97
Joined: Thu Feb 22, 2007 5:33 pm

Re: Is it possible to load sql server with the help of Talend application

Post by EPO / PATSTAT Support » Tue May 08, 2018 12:35 pm

Hello Sarajohnm
yes, it is possible to do it with Talend, but we can not help you to get the scripts to work.
Our information is that it is best to create the data base and tables outside the Talend tool, and then only use Talend to load the data into the created tables.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply