topic Re: SAP ERP system connection using Talend in Talend Studio

SAP ERP system connection using Talend

Prakhar1 — Sat, 16 Nov 2024 02:12:31 GMT

Hi I need to connect to SAP ECC system (ERP). Can anybody ever done this ?

I tried using SAPConnection component but facing this issue

Starting job te at 18:37 08/06/2020.

Picked up _JAVA_OPTIONS: -Djavax.net.ssl.trustStore=C:\Windows\Sun\Java\Deployment\trusted.cacerts
[statistics] connecting to socket on port 3810
[statistics] connected
Exception in thread "main" java.lang.NoClassDefFoundError: com/sap/conn/jco/ext/DestinationDataProvider
at cd_bi_dlm.te_0_1.te.tSAPConnection_1Process(te.java:365)
at cd_bi_dlm.te_0_1.te.runJobInTOS(te.java:864)
at cd_bi_dlm.te_0_1.te.main(te.java:664)
Caused by: java.lang.ClassNotFoundException: com.sap.conn.jco.ext.DestinationDataProvider
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:583)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
... 3 more
[statistics] disconnected

Job te ended at 18:37 08/06/2020. [exit code=1]

Re: SAP ERP system connection using Talend

manodwhb — Mon, 08 Jun 2020 14:18:54 GMT

@Prakhar , have you installed sapjco.jar or sapjco3.jar ? can you check from Module View

Re: SAP ERP system connection using Talend

Prakhar1 — Mon, 08 Jun 2020 14:41:06 GMT

Hi @manodwhb

Yes I have installed the jar file and provided the path in module.

Now I am facing a pop-up error:

org.talend.designer.runprocess.ProcessorException: Job compile errors
At least job "te" has a compile errors, please fix and export again.
Error Line: 342
Detail Message: The type com.sap.conn.jco.JCoException cannot be resolved. It is indirectly referenced from required .class files
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.
at org.talend.designer.runprocess.JobErrorsChecker.checkLastGenerationHasCompilationError(JobErrorsChecker.java:338)
at org.talend.designer.runprocess.DefaultRunProcessService.checkLastGenerationHasCompilationError(DefaultRunProcessService.java:533)
at org.talend.designer.runprocess.RunProcessService.checkLastGenerationHasCompilationError(RunProcessService.java:316)
at org.talend.designer.runprocess.ProcessorUtilities.generateBuildInfo(ProcessorUtilities.java:826)
at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:609)
at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1951)
at org.talend.designer.runprocess.RunProcessContext$1.run(RunProcessContext.java:601)
at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:440)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:356)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:474)
at org.eclipse.ui.internal.progress.ProgressMonitorJobsDialog.run(ProgressMonitorJobsDialog.java:240)
at org.eclipse.ui.internal.progress.ProgressManager.run(ProgressManager.java:966)
at org.talend.designer.runprocess.RunProcessContext.exec(RunProcessContext.java:548)
at org.talend.designer.runprocess.remote.RunRemoteProcessContext.exec(RunRemoteProcessContext.java:85)
at org.talend.designer.runprocess.ui.ProcessComposite.exec(ProcessComposite.java:1444)
at org.talend.designer.runprocess.ui.views.ProcessView$RunAction.run(ProcessView.java:700)
at org.talend.designer.runprocess.ui.actions.RunProcessAction.run(RunProcessAction.java:58)
at org.talend.designer.core.debug.JobLaunchConfigurationDelegate$1.run(JobLaunchConfigurationDelegate.java:85)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)

Re: SAP ERP system connection using Talend

Prakhar1 — Mon, 08 Jun 2020 14:42:42 GMT

Re: SAP ERP system connection using Talend

manodwhb — Thu, 11 Jun 2020 08:27:47 GMT

@Prakhar ,if you are getting compilation means that job or particular component has not configured correctly.

could you please recheck configuration of particular component is it is throwing error.

Re: SAP ERP system connection using Talend

Prakhar1 — Thu, 11 Jun 2020 16:00:44 GMT

@manodwhb I come to know that the JVM I am using is not working with the latest sapjco3.jar. So i downgraded the jar file and it worked.