Apatar.com
|
Log In
Log In
close x
Login
Password
Remember me
Forgot Your Password?
Create Account
close x
First Name
Last Name
E-mail
Telephone
Message
Home
DataMaps
Downloads
Community
Documentation/Wiki
Report Bugs
Forums
Mailing Lists
ETL News
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Apatar Community Forums Forum Index
->
Connectors Discussion
Post a reply
Username
Subject
Message body
Emoticons
View more Emoticons
Font colour:
Default
Dark Red
Red
Orange
Brown
Yellow
Green
Olive
Cyan
Blue
Dark Blue
Indigo
Violet
White
Black
Font size:
Font size
Tiny
Small
Normal
Large
Huge
Close Tags
Options
HTML is
OFF
BBCode
is
ON
Smilies are
ON
Disable BBCode in this post
Disable Smilies in this post
All times are GMT
Jump to:
Select a forum
Apatar Open Source
----------------
Announcements
Installation and Upgrade
Help
General Discussion
Feature Requests
Downloads
Development
APPLICATION INTEGRATION AND CONNECTORS
----------------
New Connector Requests
Connectors Discussion
DataMaps
Topic review
<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline"> <tr> <th class="thCornerL" width="22%" height="26">Author</th> <th class="thCornerR">Message</th> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>Sergei</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Thu Oct 07, 2010 9:48 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody"></span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Anonymous wrote:</b></span></td> </tr> <tr> <td class="quote">Hi Sergei, <br /> <br />Thanks for your reply and I did that too it shows those records in Apatar, but not getting inserted in MySQL database. <br /> <br />Thanks, <br />Prakash.C <br /> <br /></span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Sergei wrote:</b></span></td> </tr> <tr> <td class="quote">Hello Prakash, <br /> <br />You need to press Run and Preview on the target connector - MySQL connector. In this case your data will be populated in your database. <br /> <br />Regards, <br />Sergei</td> </tr></table><span class="postbody"></td> </tr></table><span class="postbody"> <br /> <br />Make sure that you mapped primary key (update criteria) in Transform node as well. BTW, did you get any errors? (Debug - Show error) <br /> <br />Regards, <br />Sergei</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row2"><span class="name"><a name=""></a><b>Guest</b></span></td> <td class="row2" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Thu Oct 07, 2010 9:44 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hi Sergei, <br /> <br />Thanks for your reply and I did that too it shows those records in Apatar, but not getting inserted in MySQL database. <br /> <br />Thanks, <br />Prakash.C <br /> <br /></span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Sergei wrote:</b></span></td> </tr> <tr> <td class="quote">Hello Prakash, <br /> <br />You need to press Run and Preview on the target connector - MySQL connector. In this case your data will be populated in your database. <br /> <br />Regards, <br />Sergei</td> </tr></table><span class="postbody"></span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>Sergei</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Thu Oct 07, 2010 9:39 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hello Prakash, <br /> <br />You need to press Run and Preview on the target connector - MySQL connector. In this case your data will be populated in your database. <br /> <br />Regards, <br />Sergei</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row2"><span class="name"><a name=""></a><b>prakash_it55</b></span></td> <td class="row2" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Wed Oct 06, 2010 5:32 pm<span class="gen"> </span> Post subject: Can't transform data between Oracle and MySql</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hi, <br />I'm new to Apatar,I tried to transform data from oracle table to MySql table but its not working. <br /> <br />Here are the steps I did, <br />1. Drag-and-drop the Oracle connector. <br />2. Configured the Oracle connection and selected the corresponding table. <br />3. Select the Insert mode option and also selected the primary key field. <br />4. Drag-and-drop the MySql connector. <br />5. Configured the Mysql connection and selected the corresponding table. <br />6. Select the Update option and also selected the primary key field. <br />7. Drag and drop the Transform from operations. <br />8. Configured the fields. <br /> <br />Finally I used Run and Preview option in Transform, its showing some data were Processed in a panel and in a separate panel I can see the data also, but actually nothing was inserted in Mysql Table. <br /> <br />Please suggest me if I missed anything, <br /> <br />Thanks, <br />Prakash</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> </table>
Powered by
phpBB
© 2001, 2005 phpBB Group
Terms and Conditions
Privacy Policy
Contact Info
Comments and Suggestions
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in