Apatar Community Forums

Can I develop a connector for my data source (target)?

hoctdy — Tue, 16 Mar 2010 09:58:08 GMT

i have read a FAQ and it said that "The open source code of Apatar allows easy building of add-on connectors for any data integration applications, be it legacy, APIs or semi-structured data sources (targets).
so how can i do this ? could you show me the detail about building a connector? please
thanks

RE: contributed a new connect to plug-in into apatar

Anonymous — Tue, 16 Mar 2010 04:35:13 GMT

Thanks Sergei for your link. But the trouble is when I read Apatar's code about XML connector, I don't understand and don't know how to make one. Can you give me more materials about this, pls? Thanks.

RE: Error importing emails into SFDC

ChadSmith — Tue, 16 Mar 2010 01:52:53 GMT

Sorta - no more errors and I actually get data in, but in the Comments (SFDC) instead of the message I get:

org.apache.derby.impl.jdbc.EmbedClob@ca9833

I'm using the Replace With as you described in the Union, so from SQL through Replace With and then To the SFDC Description...

The incoming data is a SQL 2008 Datatype of Text...

RE: contributed a new connect to plug-in into apatar

Sergei — Mon, 15 Mar 2010 17:30:55 GMT

hoctdy wrote:

i'm a student.i'm a scienor in university off science in VietNam.
i have a project about data integration. and i must contribute a connector similar XMl connector.but i don't know how can i do this? step by step to deveolop a connector.
So, could you show me the way do this? orDo you have some references about how to construct an connector. can you send me.please.
Thank you

Hi hoctdy,

You can find helpful guides here that help you learn how to create your own connector and create Apatar project in Eclipse.

Regards,
Sergei

contributed a new connect to plug-in into apatar

hoctdy — Mon, 15 Mar 2010 17:14:49 GMT

RE: Error importing emails into SFDC

Sergei — Mon, 15 Mar 2010 15:40:41 GMT

ChadSmith wrote:

Getting this:

ava.io.IOException: java.lang.IllegalArgumentException: The char '0x2' after 'Date: Thu, 19 Feb 2009 08:37:51 -0500

I tried using a replace to replace \2 with a space, but no go.

You need to use Replace With function (all options enabled) where Input value is:

Code:

(?s)(?m)(.*)\x02

And replace with value is:

Code:

Let me know if it helped.

Regards,
Sergei

RE: DateTime format in salesforce

Sergei — Mon, 15 Mar 2010 13:47:34 GMT

Anonymous wrote:

Any word on this bug being fixed?

This bug was fixed. Do you have any problems with datetime format at the moment? If yes, could you please provide us with the error log from Apatar - Debug -Show Error?

Regards,
Sergei

RE: DateTime format in salesforce

Anonymous — Mon, 15 Mar 2010 13:16:50 GMT

Any word on this bug being fixed?

RE: CREATE table based on source table definitions

Sergei — Mon, 15 Mar 2010 10:35:11 GMT

disembowler wrote:

Hi everyone,

I have a table from SFDC and want to dump its content 1:1 into a relational DB table without having to manually create the target table in the DB first?
i.e. can Apatar do something like
CREATE table AS SELECT * FROM <someothertable>?

Thanks...

Hi disembowler,

At the moment Apatar cannot create/replicate tables in the target node. However this feature could be implemented. If interested, we can discuss details. You can email me your detailed use case and I provide you with our feedback.

Regards,
Sergei

RE: Calculations on Date and Time inputs

Ludmila — Mon, 15 Mar 2010 09:55:12 GMT

Hi Ross,

We've faced the same issue during one of our recent migrations. We have created a function to adjust the time zone but it will only be released in the next version of Apatar (current version is 1.12.3, whatever comes after it will have this AddTimeZone function)

However, I will email it to you as well as the instructions on how to add it to Apatar.

Anyone interested in getting this function before the new version of Apatar is released, please reply to this message or email me at ludmila.r@apatar.com

Regards,
Ludmila