topic Re: Object does not exist for sql server in Talend Studio

Object does not exist for sql server

Anonymous — Thu, 10 Dec 2015 09:55:46 GMT

hi team,
I have a scenario where i need to move the data from sql server to mssql.And the data has to update accordingly.So I am using talend cdc in which i have followed the below steps.
1)Created two connections for sql server one for data and another for CDC
2)Retrieved schema for both the connections.
3)Under data connection of sqlserver created CDC.This is working fine.
4)But while i add cdc by right clicking on table for data connection and click exceucte i see a error invalid object name 'TestTB.TCDC_student_new' even if Respective tables are getting created in sql server.Can any one help me to resolve this issue.
How can i resolve this issue.
Can any one help ??

Re: Object does not exist for sql server

Anonymous — Fri, 11 Dec 2015 07:19:13 GMT

Hi,
Could you please also indicate the build version you are using?
Here is a related jira issue: https://jira.talendforge.org/browse/TDI-22784
Best regards
Sabrina

Re: Object does not exist for sql server

Anonymous — Fri, 11 Dec 2015 07:54:45 GMT

hi,
I am using Talend data integration -Talend-Tools-Studio-20150908_1633-V6.0.1 and Sql server -Microsoft sql server 2008 R2.

Re: Object does not exist for sql server

Anonymous — Sat, 12 Dec 2015 04:45:08 GMT

Any update please ?

Re: Object does not exist for sql server

Anonymous — Mon, 14 Dec 2015 08:20:11 GMT

Hi,
We didn't find a related jira issue. Could you please show us your job setting screenshots?
Did you follow up document TalendHelpCenteretting up a CDC environment to set up your CDC environment?
Best regards
Sabrina