topic Re: [resolved] How to import data from sql server to mysql in Talend Studio

[resolved] How to import data from sql server to mysql

Anonymous — Tue, 09 Apr 2013 07:33:07 GMT

Hi,

i try to import the data from sql server to mysql using talend open studio. but source sql server i connect and after that drag and drop the source select mssqlinput connecion that time indicate the error symbol --no schema..
how to import data from sql server to mysql explain this details
Regards,
Abdul Khadir.

Re: [resolved] How to import data from sql server to mysql

Anonymous — Tue, 09 Apr 2013 07:58:58 GMT

Hi,
Create a metadata connection to the database
Right-click on the connection
Select "Retreive schema"
Select the tables you want to import
Drag the table from the metadata to the canvas (choose input (default))

Re: [resolved] How to import data from sql server to mysql

Anonymous — Tue, 09 Apr 2013 08:02:58 GMT

Hi mmabdulkadir,

i try to import the data from sql server to mysql using talend open studio. but source sql server i connect and after that drag and drop the source select mssqlinput connecion that time indicate the error symbol --no schema..

As a newbie, I encourage you to read the below articles first on Talend Help Center, to know how to create a DB connection in repository and retrieve schema.
Setting up a DB connection with four chapters General properties, Connection, Table upload and Schema definition.
A simple job design looks like:
tMSSQLINPUT--> tMySqlOutPut
Best regards
Sabrina

Re: [resolved] How to import data from sql server to mysql

Anonymous — Tue, 09 Apr 2013 12:09:42 GMT

Hi,
thank you for your reply. this is working fine and good. thank to both.
Regards,
Abdul Khadir.

Re: [resolved] How to import data from sql server to mysql

Anonymous — Wed, 10 Apr 2013 03:28:38 GMT

Hi,
Don't hesitate to post your issue on forum. In addition, for your another issue (mentioned in e-mail), the Dynamic Schema feature is only available in Talend Enterprise Subscription Version, it allows you to design schema with an unknown column structure (unknown name and number of columns).
With community version, the schema must be defined at design time, before the job execution.
Best regards
Sabrina

Re: [resolved] How to import data from sql server to mysql

_AnonymousUser — Tue, 29 Dec 2015 11:35:41 GMT

i m trying to move data from sql server to mysql but i m facing some problem when i drag the mysql connection on work area than tMysqlOutput does not appear on components window...............

plz help me

Re: [resolved] How to import data from sql server to mysql

Anonymous — Wed, 30 Dec 2015 03:26:45 GMT

Hi Nitinrathour,
On which talend build version you got it? What's your OS? Would you mind uploading a screenshot of your problem into forum?
Best regards
Sabrina