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
->
DataMaps
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
[quote="BinCoder"]Thanks Sergei, Its set to insert mode for mysql. I will send you the datamap soon.[/quote]
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 Dec 16, 2010 12:59 pm<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>Quote:</b></span></td> </tr> <tr> <td class="quote">does this mean that apatar doesn't support InnoDB for MSSQL -> MySQL migration? because, i thought InnoDB is supported by apatar. </td> </tr></table><span class="postbody"> <br /> <br />Apatar supports InnoDB. Please provide error log when you work with InnoDB.</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>ctrl-alt-del</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 Dec 16, 2010 4:02 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">thanks sergei <br /> <br />does this mean that apatar doesn't support InnoDB for MSSQL -> MySQL migration? because, i thought InnoDB is supported by apatar. <br /> <br /></span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Quote:</b></span></td> </tr> <tr> <td class="quote"> <br />Apatar Open Source Data Integration features and benefits: <br />- No coding! Visual job designer and mapping enable non-developers to design and perform transformations, shortening implementation time <br />- Distributed under an open source model, reducing integration and maintenance costs <br />- Connectivity to Salesforce.com, SugarCRM, MySQL, Oracle, MS SQL, Microsoft Excel, Microsoft Access, GoldMine, DB2, Sybase, PostgreSQL, dBase, EnterpriseDB, vTiger, <span style="font-weight: bold">InnoDB</span>, Vertica Analytic Databse, Openbravo ERP, Compiere ERP, .CSV, XML, RSS, ATOM, HTTP queries, POP3, LDAP, FTP, WebDav, Autodesk Buzzsaw, any JDBC data sources, Amazon S3, Flickr, StrikeIron and CDYNE data quality Web services, and more <br />- Job scheduler and synchronization automate the data integration process <br />- Improves data quality with a variety of verification, filtration, and validation features <br />- Users have the ability to create, share, and re-use pre-built data transformations and publish data integration output as a custom RSS feed to ApatarForge, the online Apatar community <br />- Platform-independent, runs from Windows, Linux, and Mac OS. <br /></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: Wed Dec 15, 2010 11:56 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>ctrl-alt-del wrote:</b></span></td> </tr> <tr> <td class="quote">hi, <br /> <br />i have a problem migrating from MSSQL to MySQL. my apatar version is 1.12.13 <br /> <br />the problem is when i'm using innoDB at MySQL. the data cannot be migrated. but if i'm using myISAM.. all the data are migrated. <br /> <br />do we need to change the table from innoDB to MyISAM?</td> </tr></table><span class="postbody"> <br /> <br />Correct.</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>ctrl-alt-del</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 Dec 15, 2010 9:14 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, <br /> <br />i have a problem migrating from MSSQL to MySQL. my apatar version is 1.12.13 <br /> <br />the problem is when i'm using innoDB at MySQL. the data cannot be migrated. but if i'm using myISAM.. all the data are migrated. <br /> <br />do we need to change the table from innoDB to MyISAM?</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: Tue Aug 03, 2010 4:18 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hello, <br /> <br />You currently have version </span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Quote:</b></span></td> </tr> <tr> <td class="quote">Version Apatar_v1.12.11 </td> </tr></table><span class="postbody"> <br /> <br />Please download the latest version of Apatar 1.12.12. Also if you used the patch for 1.12.11, make sure that you replaced the correct files. <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>BinCoder</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: Mon Aug 02, 2010 3:23 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">The following is the error i get from the show error tab. <br /> <br /> <br />********************************* <br />Start date Mon Aug 02 18:49:14 GST 2010 <br />Version Apatar_v1.12.11 <br />JRE Version 1.6.0_17 <br />JRE Vendor Sun Microsystems Inc. <br />log4j.configuration = `null` <br />Start Reading from MattInf <br />Start Reading from MattInf <br />Start Reading from MattInf <br />Start Reading from MattInf <br />java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.String <br /> at com.apatar.core.DataBaseTools.setDataToPS(DataBaseTools.java:1601) <br /> at com.apatar.core.AbstractJdbcDataBase.insertOneRow(AbstractJdbcDataBase.java:329) <br /> at com.apatar.core.AbstractJdbcDataBase.TransformTDBtoRDB(AbstractJdbcDataBase.java:272) <br /> at com.apatar.mysql.MySqlNode.TransformTDBtoRDB(MySqlNode.java:188) <br /> at com.apatar.core.AbstractDataBaseNode.Transform(AbstractDataBaseNode.java:363) <br /> at com.apatar.core.AbstractDataBaseNode.Transform(AbstractDataBaseNode.java:333) <br /> at com.apatar.core.Runnable.execute(Runnable.java:207) <br /> at com.apatar.core.Runnable.execute(Runnable.java:187) <br /> at com.apatar.core.Runnable.execute(Runnable.java:181) <br /> at com.apatar.core.Runnable.executeToNode(Runnable.java:174) <br /> at com.apatar.core.Runnable.access$0(Runnable.java:171) <br /> at com.apatar.core.Runnable$Run.run(Runnable.java:85) <br />Start Reading from matter</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>BinCoder</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: Mon Aug 02, 2010 11:31 am<span class="gen"> </span> Post subject: Problem Exportibg Data from MSSQL and importing to MySql</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hi Guys, <br /> <br />I am still facing problems with importing data in to MySql Database from the MSSQL DB.I have currently setup the MySql DB to be MyISAM based and even checked the field values and ensured that they are the same but still for some reason my mysql db is still empty.</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>BinCoder</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: Sun Aug 01, 2010 10:57 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Dear Sergie, <br /> <br />I tried the steps you outlined but still it did not work out. I added a custom table to check and that gets populated properly. What else do you think could be going on?</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>BinCoder</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: Tue Jul 27, 2010 2:30 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">I have sent and email already now. <br /> <br />Let me know what is the problem. <br /> <br />Thanks</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>BinCoder</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: Tue Jul 27, 2010 2:20 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Thanks Sergei, <br /> <br />Its set to insert mode for mysql. <br /> <br />I will send you the datamap soon.</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: Tue Jul 27, 2010 1:53 pm<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>BinCoder wrote:</b></span></td> </tr> <tr> <td class="quote">how do i attach the file here in this thread? <br /> <br />BTW it is a very simple thing <br /> <br />MSSQL >> Transform >> MySql <br /> <br />But the MySql db is not populated with the data.</td> </tr></table><span class="postbody"> <br /> <br />MySQL set to insert or update mode? <br /> <br />You can send your datamap directly to sergei.l at apatar dot com</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>BinCoder</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: Tue Jul 27, 2010 1:20 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">how do i attach the file here in this thread? <br /> <br />BTW it is a very simple thing <br /> <br />MSSQL >> Transform >> MySql <br /> <br />But the MySql db is not populated with the data.</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: Tue Jul 27, 2010 12:25 pm<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>BinCoder wrote:</b></span></td> </tr> <tr> <td class="quote">No i did not get any .</td> </tr></table><span class="postbody"> <br /> <br />Could you please send your datamap to me? <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>BinCoder</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: Tue Jul 27, 2010 8:30 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">No i did not get any .</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: Mon Jul 26, 2010 11:58 am<span class="gen"> </span> Post subject: Re: Migrating Data from MSSQL Server to MySql Server</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>BinCoder wrote:</b></span></td> </tr> <tr> <td class="quote">Hi guys, <br /> <br />I have tried to migrate some data from MSSQL server to the MySql Server, i am able to view results in the transform element but when i try to preview the results in the MySql element i dont see anything?What could be the reason. <br /> <br />Thanks</td> </tr></table><span class="postbody"> <br /> <br />Did you get any errors? <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> </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