SAP ERP system connection using Talend

[Prakhar1]

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]

[manodwhb]

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

[Prakhar1]

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)

[Prakhar1]

[manodwhb]

@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.

[Prakhar1 · Accepted solution]

@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.