ETL工具kettle7.1

安装

PDI kettle pentaho-data-integration
下载链接 https://nchc.dl.sourceforge.net/project/pentaho/Data%20Integration/7.1/pdi-ce-7.1.0.0-12.zip
直接解压即可
在线文档 http://wiki.pentaho.com/display/EAI/Pentaho+Data+Integration+Steps
帮助文档和实例 https://help.pentaho.com/Documentation/7.1/0J0/0C0

运行

不同版本的Java,修改脚本,添加

1
export JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk1.8.0_40.jdk/Contents/Home

set-pentaho-env.sh

image

运行脚本sh spoon.sh

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
$ sh spoon.sh
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
10:59:35,634 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
10:59:35,818 INFO [KarafInstance]
*******************************************************************************
*** Karaf Instance Number: 1 at /Users/shaozhipeng/Desktop/data-integration ***
*** /./system/karaf/caches/spoon/data-1 ***
*** FastBin Provider Port:52901 ***
*** Karaf Port:8802 ***
*** OSGI Service Port:9051 ***
*******************************************************************************
十月 10, 2017 10:59:36 上午 org.apache.karaf.main.Main launch
信息: Installing and starting initial bundles
十月 10, 2017 10:59:36 上午 org.apache.karaf.main.Main launch
信息: All initial bundles installed and set to start
十月 10, 2017 10:59:36 上午 org.apache.karaf.main.Main$KarafLockCallback lockAquired
信息: Lock acquired. Setting startlevel to 100
Creating configuration from org.apache.karaf.command.acl.jaas.cfg
Creating configuration from jmx.acl.org.apache.karaf.bundle.cfg
Creating configuration from org.apache.activemq.webconsole.cfg
Creating configuration from org.apache.karaf.command.acl.bundle.cfg
Creating configuration from org.apache.karaf.webconsole.cfg
Creating configuration from org.apache.karaf.features.repos.cfg
Creating configuration from org.apache.karaf.command.acl.scope_bundle.cfg
Creating configuration from org.apache.karaf.command.acl.system.cfg
Creating configuration from jmx.acl.osgi.compendium.cm.cfg
Creating configuration from jmx.acl.java.lang.Memory.cfg
Creating configuration from org.ops4j.pax.web.cfg
Creating configuration from org.apache.karaf.features.cfg
Creating configuration from org.apache.karaf.command.acl.feature.cfg
Creating configuration from org.apache.karaf.kar.cfg
Creating configuration from org.apache.felix.fileinstall-deploy.cfg
Creating configuration from org.apache.karaf.features.obr.cfg
Creating configuration from org.apache.activemq.server-default.cfg
Creating configuration from org.apache.aries.rsa.provider.fastbin.cfg
Creating configuration from org.apache.karaf.command.acl.kar.cfg
Creating configuration from org.apache.karaf.shell.cfg
Creating configuration from org.apache.karaf.management.cfg
Creating configuration from org.apache.karaf.jaas.cfg
Creating configuration from org.pentaho.caching-default.cfg
Creating configuration from jmx.acl.org.apache.karaf.security.jmx.cfg
Creating configuration from jmx.acl.cfg
Creating configuration from mondrian.cfg
Creating configuration from org.apache.karaf.log.cfg
Creating configuration from jmx.acl.org.apache.karaf.config.cfg
Creating configuration from org.apache.karaf.command.acl.shell.cfg
Creating configuration from org.ops4j.pax.logging.cfg
Creating configuration from org.apache.karaf.command.acl.config.cfg
Creating configuration from org.pentaho.pdi.engine.spark.cfg
Creating configuration from org.ops4j.pax.url.mvn.cfg
Creating configuration from org.pentaho.features.cfg
十月 10, 2017 10:59:41 上午 org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess
信息: New Caching Service registered
Creating configuration from pentaho.big.data.impl.cluster.cfg
Creating configuration from pentaho.marketplace.di.cfg
Creating configuration from pentaho.geo.roles.cfg
Creating configuration from pentaho.metaverse.cfg
2017-10-10 11:00:02.489:INFO:oejs.Server:jetty-8.1.15.v20140411
2017-10-10 11:00:02.587:INFO:oejs.AbstractConnector:Started NIOSocketConnectorWrapper@0.0.0.0:9051
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/core
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/configuration/beans
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/configuration/parameterized-types
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/configuration/security
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://schemas.xmlsoap.org/wsdl/
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://www.w3.org/2005/08/addressing
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/08/addressing
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-management (152) [org.apache.cxf.management.InstrumentationManager]
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-policy (203) [org.apache.cxf.ws.policy.PolicyEngine, org.apache.cxf.policy.PolicyDataEngine, org.apache.cxf.ws.policy.AssertionBuilderRegistry, org.apache.cxf.ws.policy.PolicyInterceptorProviderRegistry, org.apache.cxf.ws.policy.PolicyBuilder, org.apache.cxf.ws.policy.PolicyAnnotationListener, org.apache.cxf.ws.policy.attachment.ServiceModelPolicyProvider, org.apache.cxf.ws.policy.attachment.external.DomainExpressionBuilderRegistry, org.apache.cxf.ws.policy.attachment.external.EndpointReferenceDomainExpressionBuilder, org.apache.cxf.ws.policy.attachment.external.URIDomainExpressionBuilder, org.apache.cxf.ws.policy.attachment.wsdl11.Wsdl11AttachmentPolicyProvider, org.apache.cxf.ws.policy.mtom.MTOMAssertionBuilder, org.apache.cxf.ws.policy.mtom.MTOMPolicyInterceptorProvider]
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (156) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-wsdl (189) [org.apache.cxf.wsdl.WSDLManager]
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/transports/http/configuration
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-soap (192) [org.apache.cxf.binding.soap.SoapBindingFactory, org.apache.cxf.binding.soap.SoapTransportFactory]
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxrs
十月 10, 2017 11:00:03 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxrs-client
十月 10, 2017 11:00:04 上午 org.apache.cxf.endpoint.ServerImpl initDestination
信息: Setting the server's publish address to be /marketplace
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-xml (191) [org.apache.cxf.binding.xml.XMLBindingFactory, org.apache.cxf.binding.xml.wsdl11.XMLWSDLExtensionLoader]
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/bindings/soap
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/simple
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-frontend-jaxws (194) [org.apache.cxf.jaxws.context.WebServiceContextResourceResolver]
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxws
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/binding/coloc
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-local (199) [org.apache.cxf.transport.local.LocalTransportFactory]
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-object (200) [org.apache.cxf.binding.object.ObjectBindingFactory]
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/binding/object
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/policy
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://www.w3.org/ns/ws-policy
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://www.w3.org/2006/07/ws-policy
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/09/policy
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://www.w3.org/2000/09/xmldsig#
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://docs.oasis-open.org/ws-sx/ws-securitypolicy/200702
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-addr (220) [org.apache.cxf.ws.addressing.policy.AddressingAssertionBuilder, org.apache.cxf.ws.addressing.policy.UsingAddressingAssertionBuilder, org.apache.cxf.ws.addressing.policy.AddressingPolicyInterceptorProvider, org.apache.cxf.ws.addressing.impl.AddressingWSDLExtensionLoader, org.apache.cxf.ws.addressing.WSAddressingFeature$WSAddressingFeatureApplier, org.apache.cxf.ws.addressing.MAPAggregator$MAPAggregatorLoader]
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/ws/addressing
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-security (222) [org.apache.cxf.ws.security.policy.WSSecurityPolicyLoader, org.apache.cxf.ws.security.cache.CacheCleanupListener]
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-rm (224) [org.apache.cxf.ws.rm.RMManager, org.apache.cxf.ws.rm.policy.RMPolicyInterceptorProvider, org.apache.cxf.ws.rm.policy.RM10AssertionBuilder, org.apache.cxf.ws.rm.policy.RM12AssertionBuilder, org.apache.cxf.ws.rm.policy.WSRMP12PolicyLoader, org.apache.cxf.ws.rm.policy.MC11PolicyLoader, org.apache.cxf.ws.rm.policy.RSPPolicyLoader]
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/ws/rm/manager
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2005/02/rm/policy
十月 10, 2017 11:00:05 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-javascript (225) [org.apache.cxf.javascript.JavascriptServerListener]
十月 10, 2017 11:00:06 上午 org.apache.cxf.endpoint.ServerImpl initDestination
信息: Setting the server's publish address to be /lineage
十月 10, 2017 11:00:06 上午 org.apache.cxf.endpoint.ServerImpl initDestination
信息: Setting the server's publish address to be /i18n
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/Users/shaozhipeng/Desktop/data-integration/launcher/../lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/Users/shaozhipeng/Desktop/data-integration/plugins/pentaho-big-data-plugin/lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
十月 10, 2017 11:00:07 上午 org.apache.cxf.endpoint.ServerImpl initDestination
信息: Setting the server's publish address to be /repositories
2017/10/10 11:00:17 - Carte - Installing timer to purge stale objects after 1440 minutes.

启动成功会弹出图形用户界面

image

helloworld

image
image
image
image

邵志鹏 wechat
扫一扫上面的二维码关注我的公众号
0%