I have been thru the other postings on the SAP JCO Connector.
Is it possible to use SAPJCO3 with Talend?
I am using TIS 4.0.2.
I am trying to use the SAPJCO3.JAR (3.0.5). I have the dll in a directory that is in the PATH variable. I placed the sapjco3.jar file in the <Talend Install Directory>/lib/java directory and renamed it to sapjco.jar.
I then imported sapjco.jar from the modules tab.
I run a job with the SAP Connection component and receive errors
com.sap.mw cannot be resolved to a type
com.sap.mw.jco.JCO.Client cannot be resolved to a type
com.sap.mw.jco.JCO cannot be resolved to a type
and these errors repeat many times.
I can get the jco 2.1.9 to work but I assume the version 3 of the jco is improved?
Thanks in advance and regards
Rick
That's what I did, but the specified version is no longer available because it is outdated. If Talend was supporting version 3.0 we wouldn't even be discussing this here.
Hello Michael!
I do not have the files "sapjcorfc.so" and "librfccm.so" as they don't ship with the SAPJCo.
I have done the following:
1. Extract SAP distribution package (I finally got my hands on version 2.1.9 for 64 bits) to C:\Program Files\SAPJCo
2. Add C:\Program Files\SAPJCo to the PATH
3. Add C:\Program Files\SAPJCo\sapjco.jar to the CLASSPATH
4. Copy librfc32.dll to the Windows\System32 -directory (overwrite if exists)
5. Copy sapjco.jar to TalendJobServer\lib -directory
Should I do something else with my librfc32.dll?
Yours,
Alex
Hello everyone!
I think I got CommandLine to work with SAP on my 64 bit machine but JobServer is still not working. When I do a "Generate" on my test jobs, I don't get any compiler errors, so I assume all SAP libraries are found. But when I click "Run" I get the error below. Even though my execution server, CommanLine and TAC all run on the same machine.
In the jsl.ini I added the sapjco.jar to the classpath:
params = 6
param00 = -cp
param01 = D:\TalendJobServer;D:\TalendJobServer\lib\jmxremote_optional.jar;D:\TalendJobServer\lib\log4j-1.2.15.jar;D:\TalendJobServer\lib\commons-io-1.3.2.jar;D:\TalendJobServer\lib\jsl.jar;C:\Program Files\SAPJCo\sapjco.jar
param02 = -Djava.library.path=D:\TalendJobServer\jsysmon-20061229\native\windows\
param03 = -Dcom.sun.management.jmxremote
param04 = -Dtalend_props=D:\TalendJobServer\conf\TalendJobServer.properties
param05 = org.talend.remote.jobserver.service.WindowsJobServer
But still not working. What else should I do to get jobs to execute that connect to SAP?
Exception in thread "main" java.lang.Error: Problemas de compilación no resuelto:
com.sap.mw no se puede resolver en un tipo
com.sap.mw.jco.JCO no se puede resolver en un tipo
at delibes.zzz_test_sap_hechos_economicos_reales_actual_0_1.ZZZ_TEST_SAP_Hechos_Economicos_Reales_Actual.tSAPConnection_1Process(ZZZ_TEST_SAP_Hechos_Economicos_Reales_Actual.java:485)
at delibes.zzz_test_sap_hechos_economicos_reales_actual_0_1.ZZZ_TEST_SAP_Hechos_Economicos_Reales_Actual.runJobInTOS(ZZZ_TEST_SAP_Hechos_Economicos_Reales_Actual.java:7243)
at delibes.zzz_test_sap_hechos_economicos_reales_actual_0_1.ZZZ_TEST_SAP_Hechos_Economicos_Reales_Actual.main(ZZZ_TEST_SAP_Hechos_Economicos_Reales_Actual.java:7066)
Never mind my last post, it was the CommandLine after all. The terrible Talend Administration Center kept telling me it compiled fine ("Ready to run"), while in fact CommandLine was unable to find sapjco.jar. Now I explicitly included it in the .classpath file and everything works alright.
On a different note, I am shocked how awful is the Talend Administration Center. It is such an important piece of software within the ETL framework, yet it works so bad and is so terribly full of bugs...
Hi Alex
Which version of TOS are you using? Does the job work fine in studio? Please also put the sapjco.jar into commandline-workspace\.Javalibs before you generate the job on job conductor.
Best regards
Shong
Good morning Shong and thank you for your reply,
Finally everything works, so don't worry. I am using Talend Integration Suite 4.0.3 r47759.
And correct, the trick was to copy the sapjco.jar in the commandline-workspace\.Javalibs directory. Just in case I also added a line in the ".classpath" file.
Yours,
Alex
