Kettle连接SAP报错问题

kettle连接sap我没用过，我到官网看了下，感觉需要一个插件，插件列表见
http://wiki.pentaho.com/displa ... g-Ins
里面说到ITN Connector ERP 的插件，文档可以见
http://wiki.pentaho.com/download/attachments/1049091/ITN+ERP+Connector+for+Pentaho+Data+Integration+v4.pdf?version=1&modificationDate=1289401208000

我用过informatica读取sap数据，原理是创建一个rfc（需要在sap部署），调用rfc读取数据，理论上这个连接只是连接到sap的服务，不可能访问具体的数据库的表。不过看这个文档又不像这样，有点奇怪。

SAP高端货，小公司用不起，表示没玩过SAP，SAP里面有没有数据库对应的用户名或者模式名什么的，把表名写全，类似xxx.t001k这样

我也遇到同样的问题了,楼主现在有解决方法了么.我在网上找了很久,也没看到解决方案.

请问下你是怎么连接到sap的，我现在连接报错
 Unable to connect to the SAP ERP server: 

Cannot get SAP function
Connect to SAP gateway failed
Connection parameters: TYPE=A DEST=BW ASHOST=IP SYSNR=21 PCS=1

LOCATION    CPIC (TCP/IP) on local host with Unicode
ERROR       partner 'IP:3322' not reached
TIME        Mon Aug 07 10:11:17 2017
RELEASE     720
COMPONENT   NI (network interface)
VERSION     40
RC          -10
MODULE      nixxi.cpp
LINE        3286
DETAIL      NiPConnect2: IP:3322
SYSTEM CALL connect
ERRNO       10060
ERRNO TEXT  WSAETIMEDOUT: Connection timed out
COUNTER     14


Possibly the SAP JCo implementation library (e.g. sapjco3.dll) does not exist or cannot be loaded. Please copy it to your libext directory! If you use version 3.0.5 or higher on Windows be sure to have MS Visual C++ 2005 SP1 Redistributable Package ATL Security Update installed.

org.pentaho.di.trans.steps.sapinput.sap.SAPException: 

Cannot get SAP function
Connect to SAP gateway failed
Connection parameters: TYPE=A DEST=BW ASHOST=IPSYSNR=21 PCS=1

LOCATION    CPIC (TCP/IP) on local host with Unicode
ERROR       partner 'IP:3322 not reached
TIME        Mon Aug 07 10:11:17 2017
RELEASE     720
COMPONENT   NI (network interface)
VERSION     40
RC          -10
MODULE      nixxi.cpp
LINE        3286
DETAIL      NiPConnect2:IP:332
SYSTEM CALL connect
ERRNO       10060
ERRNO TEXT  WSAETIMEDOUT: Connection timed out
COUNTER     14


Possibly the SAP JCo implementation library (e.g. sapjco3.dll) does not exist or cannot be loaded. Please copy it to your libext directory! If you use version 3.0.5 or higher on Windows be sure to have MS Visual C++ 2005 SP1 Redistributable Package ATL Security Update installed.

at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.test(SAPConnectionImpl.java:123)
at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.open(SAPConnectionImpl.java:94)
at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.open(SAPConnectionImpl.java:65)
at org.pentaho.di.trans.steps.sapinput.sap.SAPConnectionFactory.getConnectionTestReport(SAPConnectionFactory.java:60)
at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2685)
at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:546)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)
at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)
at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)
at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:43)
at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:138)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
at org.eclipse.jface.window.Window.open(Window.java:796)
at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:389)
at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:318)
at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:116)
at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:59)
at org.pentaho.di.ui.trans.step.BaseStepDialog$5.widgetSelected(BaseStepDialog.java:770)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.pentaho.di.ui.trans.steps.tableinput.TableInputDialog.open(TableInputDialog.java:435)
at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124)
at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8720)
at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027)
at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1310)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7931)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9202)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:648)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)

使用sap input