Salesforce.com ODA - Ping failed

davcondev

I'm attempting to create a Salesforce.com ODA data source in BIRT Report Designer and I get the error below when testing the connection.<br />
<br />
I have tried to connect to test and production salesforce.com instances without success. There doesn't appear to be anywhere in the data source advanced properties to specify the server. This leads me to speculate that the server is hard coded and has gone out of date?<br />
<br />
I'm able to connect using Salesforce.com's Excel-based ad hoc query tool which I presume uses the same API as this data source.<br />
<br />
Thanks in advance!<br />
<br />
<span class='bbc_underline'>Error:<br />
</span><br />
org.eclipse.datatools.connectivity.oda.OdaException<br />
at com.birtexchange.oda.salesforce.impl.Connection.open(Connection.java:54)<br />
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)<br />
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.open(OdaConnectionWrapper.java:209)<br />
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.<init>(OdaConnectionWrapper.java:59)<br />
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionFactory.createConnection(OdaConnectionFactory.java:26)<br />
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)<br />
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:358)<br />
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)<br />
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSourceEditorPageCore$1.run(DataSourceEditorPageCore.java:629)<br />
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)<br />
at org.eclipse.datatools.connectivity.ui.wizards.ProfileDetailsPropertyPage.testConnection(ProfileDetailsPropertyPage.java:98)<br />
at org.eclipse.datatools.connectivity.ui.wizards.ProfileDetailsPropertyPage$1.widgetSelected(ProfileDetailsPropertyPage.java:80)<br />
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)<br />
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)<br />
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)<br />
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)<br />
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)<br />
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)<br />
at org.eclipse.jface.window.Window.open(Window.java:801)<br />
at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:111)<br />
at org.eclipse.birt.report.designer.data.ui.actions.EditDataSourceAction.doAction(EditDataSourceAction.java:69)<br />
at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)<br />
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)<br />
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)<br />
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)<br />
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)<br />
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)<br />
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)<br />
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)<br />
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)<br />
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2629)<br />
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2593)<br />
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2427)<br />
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:670)<br />
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)<br />
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:663)<br />
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)<br />
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)<br />
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)<br />
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)<br />
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)<br />
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)<br />
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br />
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br />
at java.lang.reflect.Method.invoke(Unknown Source)<br />
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)<br />
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)<br />
at org.eclipse.equinox.launcher.Main.run(Main.java:1407)

dmelcher

Hi davcondev,
Thank you for your interest in the SalesForce.com ODA. The ODA currently only connects to a production/development environment. Connection to a test environment is coming soon. All communication to SF is done through their SOAP Web Services API.

To determine if you can access the SF APIs, please type the following into a command prompt:
ping na3-api.salesforce.com

If the reply cannot successfully return an IP address, then your network might be blocking this for some reason.

Please let me know the results of this test, and we'll take it from there.

Dan