We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Has anyone used Apatar to connect to Salesforce?

Medium Priority
1,175 Views
Last Modified: 2016-02-16
I am trying to use Apatar to connect to Salesforce and push/pull data back and forth between an Access application that I have created.  I am just having a little trouble getting it to work and was curious if anyone has done it and if so, if they know of any good tutorials...
Comment
Watch Question

CERTIFIED EXPERT

Commented:
What part exactly are you having problems with. Is it the connection to Salesforce or the connection to Access? The following pages seem to have detailed instructions for the Salesforce and Access connectors:
http://www.apatarforge.org/wiki/display/GUI/Apatar+Connector+for+SalesForce.com
http://www.apatarforge.org/wiki/display/GUI/Connector+for+MS+Access

I've never used Apatar, but I know Salesforce and Access, so hopefully I can help you to solve this.

Author

Commented:
I tried just adding the initial connection to Salesforce and configured it and it should pull everything back from one of my objects in SF...Select * From Accounts.

When I do the run and preview in Apatar, it returns blank.

What I have is my data in Salesforce...I need to download certain items in Access, then my access app is used to create contracts and such for the business, then that info will need to go back into salesforce.  Then I need to get the unique salesforce ID for each contract back into my app.

I wanted to schedule an automated process that would run at EOD, just having an issue getting started...

Author

Commented:
I followed that first link exactly several times and got nothing back...
CERTIFIED EXPERT

Commented:
The last 2 screenshots of the first link. The one with the data. What do you get:
1. No window at all
2. Completely blank window
3. Window with columns but no rows
And the one with the progress. Do you get that one too and what does is say?

When enter the wrong password for the user. Do you get an error message or do you get the same result. If you get an error message we at least know you got the user info right. Also in the Salesforce logs. Can you verify the user connected to Salesforce successfully?

Author

Commented:
I am not in front of it right now, but I when I click the "Run and Preview" I see the window open and scroll through the running commands and then I get a window with column headings and no rows.
CERTIFIED EXPERT

Commented:
Do you also get the progress window and what does it say?
Just to make sure: there are Accounts registered in SalesForce and the user that you use has permission to view those?

Author

Commented:
I can't tell you about the progress window because I don't have access to it and I am not with the person that does, but I know that they are the sole account with access to their Salesforce data and yes there are Accounts listed.

I should know more tomorrow once I meet with the user again...sorry this isn't easy for me to check for you.
CERTIFIED EXPERT

Commented:
I've installed Apatar and followed the instructions. It worked exactly as described in the manual. Maybe you could try a new install of Apatar on another machine, or try another Salesfoce account.

Author

Commented:
Well, after the meeting yesterday it looks like the client is not going to use apatar.  If you wouldn't mind giving me your thoughts on something else I will award points so we can close this out...

What do you think is the best option to synch data back and forth between MS Access and Salesforce.  The ideal situation is that the process would run EOD and synch the data.
CERTIFIED EXPERT

Commented:
And why don't use Apatar for that. It seems like it can do the job. The only options I have experience with are tools I've written myself in (Excel) VBA and C#. The advantage is it gives you complete control over the process. The disadvantage is it takes a lot of time to built the solutions.
What do you mean by "back and forth". Will data change in the same table (for example contacts) on both Salesforce and Access? That would be rather difficult because of the conflicts that could occur (same record changed in Salesforce and Access). If you only need specific tables one way and other tables the other way (for example contacts form Access to SalesForce and opportunities from SalesForce to Access) you might be able to use the data loader. This is a free tool from SalesForce that you can use to upload and download csv files. You can create these csv files from Access, and import them in Access. You could create a script to do the synchronization and then schedule this script.
Maybe you can go into what exactly you need a bit more.

Author

Commented:
Well, agents and dealers get added into SF and since SF adds their unique ID, that info gets updated back into Access.  Then contracts get built in Access and they get moved into SF.

I know about the data loader and that might be a route to take, I was also thinking about looking into the salesforce api and creating a windows service to do the work...

Author

Commented:
The apatar tool was just giving us problems and since I don't have the access to SF I can't really play around with it much.  It does look perfect, but I just don't have access to everything I need to mess with it.
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thank you...i will do that!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.