1. Daniel Giugliano
  2. PowerBuilder
  3. Tuesday, 11 June 2019 16:36 PM UTC

Dear, I need to pass the SAP Business One SDK applications, from DI-API to SAP ServiceLayer HANA, someone has worked with that from PowerBuilder

 

Español:

Estimados , requiero pasar las aplicaciones de SAP Business ONE SDK , desde DI-API a SAP ServiceLayer , alguien a trabajado con esto, desde PowerBuilder

 

Daniel Giugliano

 

Marco Fossa Accepted Answer Pending Moderation
  1. Friday, 21 January 2022 23:03 PM UTC
  2. PowerBuilder
  3. # 1

Hola Daniel un gusto y gracias por la ayuda me baje el Appeon Power Builder 2019 R2(Trial), me recomendaron con esa version pero normalmente uso Power Builder 12.5 , cuando utilizo la opcion de .Net DLL Importer en la opcion de Tools me permite elegir los objetos pero algunos me los toma como que no los reconoce cual es la forma de importar el DLL de SAP Bussines One SDK en esta version??

Gracias por tu ayuda!!



marco

Comment
  1. Miguel Leeuwe
  2. Sunday, 23 January 2022 20:11 PM UTC
La herramienta solo funciona para funciones .net que usen datos the tipo "estandar". Ademas no te vale para este caso. Como han dicho tienes que utilizar la API de SAP.

"

Giuseppe moglia Sunday, 26 April 2020 14:14 PM UTC

It's easy Daniel

You have just to build up an HTTP Client (With PB2017 R3 you can) and follow the Service Layer API Reference

You have to connect at the beginning and the include the Authorization token in any other further request

"

saludos
  1. Helpful
There are no comments made yet.
Daniel Giugliano Accepted Answer Pending Moderation
  1. Friday, 21 January 2022 15:58 PM UTC
  2. PowerBuilder
  3. # 2

Buenos Dias Marcos, 

 

Hay varias maneras de conectarte a las transacciones SAP, ( OLE, .Net , ServiceLayer, etc)  y eso depende de la version de powerbuilder y la version de SAP que uses.

Por tu comentario anterior veo que es SAP 9.3 sobre SQL, faltaria saber la version de PowerBuilder  que usas.

Creo que la solucion para la version de SAP que tienes,  es crear un target .NET Windows Form (D)  y  referencial la DLL de SAP "SAPBusinessOneSDK.dll" , generarmente esta ubicada cuando instala SAP en la siguiente ruta C:\Program Files (x86)\sap\SAP Business One SDK\Lib\

un ejemplo seria algo asi:

 

//-----------------------------------------------------------------------------------------------------------------------

#if defined PBDOTNET then
TRY

// Instanciando Objeto SAP
SAPbobsCOM.CompanyClass vCompany;
vCompany = create SAPbobsCOM.CompanyClass;
vCompany.Server = gs_server_sap_new.trim();
vCompany.CompanyDB = gs_basedato_sap.trim();
vCompany.DbUserName = gs_dbusername.trim();
vCompany.DbPassword = gs_dbpassword.trim();
vCompany.UserName = gs_usuasap.trim();
vCompany.Password = gs_clavsap.trim();
vCompany.LicenseServer = gs_licenseserver.trim();
vCompany.language = SAPbobsCOM.BoSuppLangs.ln_Spanish;

// Rutina para Diferentes Base de datos

choose case gs_servertype.trim()
case "dst_MSSQL2005"
vCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2005;
case "dst_MSSQL2008"
vCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2008;
case "dst_MSSQL2012"
vCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2012;
case "dst_MSSQL2014"
vCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2014;
case "dst_MSSQL2016"
vCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2016;
case "dst_MSSQL2019"
vCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2019;
case "dst_HANA"
vCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_HANADB;
case else
vCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2012;
end choose

// Estableciendo conexion
Long ll_insID, lErrCode, lRetCode
string sErrMsg, st_mensaje_ok
if vCompany.Connected = false then
lRetCode = vCompany.Connect( );
If lRetCode <> 0 Then
st_espere.visible = true
vCompany.getlastError( lErrCode, sErrMsg);
MessageBox("Conexion con SAP",String(lRetCode) + ' - ' + sErrMsg ) ;
return
else
//MessageBox("Conexion", "EXITO" ) ;
End If
end if

String ls_error
catch (System.Exception ex)
ls_error = ex.Message
MessageBox('LogPass Exception Error', ls_error)
end try


#end if

//-----------------------------------------------------------------------------------------------------------------------

Saludos,

 

Daniel Giugliano

 

 

Comment
  1. Marco Fossa
  2. Friday, 21 January 2022 19:50 PM UTC
Hola Daniel un gusto y gracias por la ayuda me baje el Appeon Power Builder 2019 R2(Trial), me recomendaron con esa version pero normalmente uso Power Builder 12.5 , cuando utilizo la opcion de .Net DLL Importer en la opcion de Tools me permite escoger los objetos pero algunos me los toma como que no los reconoce cual es la forma de importar el DLL de SAP Bussines One SDK en esta version??

Gracias por tu ayuda!!



Marco

  1. Helpful
There are no comments made yet.
Marco Fossa Accepted Answer Pending Moderation
  1. Friday, 21 January 2022 15:18 PM UTC
  2. PowerBuilder
  3. # 3

Hola a esta fecha 21/01/2022 tambien estoy buscando ayuda en como utilizar el .DLL de SAP Bussines One ver 9.3 SDK (SQL) con Power Builder

Ayuda por favor!!

 

Marco

Comment
There are no comments made yet.
Daniel Giugliano Accepted Answer Pending Moderation
  1. Friday, 24 April 2020 15:33 PM UTC
  2. PowerBuilder
  3. # 4

Giuseppe moglia

If I still require help for initial sdk service layer with powerbuilder.

It would be of great help, some documentation or example for integration of powerbuilder with bussines one sdk service layer hana,

 

Daniel Giugliano

Comment
  1. Giuseppe moglia
  2. Sunday, 26 April 2020 14:14 PM UTC
It's easy Daniel

You have just to build up an HTTP Client (With PB2017 R3 you can) and follow the Service Layer API Reference

You have to connect at the beginning and the include the Authorization token in any other further request

Which kind of issue do you have?
  1. Helpful
There are no comments made yet.
Giuseppe moglia Accepted Answer Pending Moderation
  1. Friday, 24 April 2020 14:29 PM UTC
  2. PowerBuilder
  3. # 5

Daniel

sorry 

I've just seen your post do you need help?

Regards

Comment
There are no comments made yet.
Daniel Giugliano Accepted Answer Pending Moderation
  1. Friday, 14 June 2019 04:50 AM UTC
  2. PowerBuilder
  3. # 6

Dear,

Really a great start is to get the example that was given in ELEVATE 2018
It would be enough to start. I do not know if this example is available.
I do not know if Giuseppe Moglia is APPEON?

 

Daniel Giugliano

Comment
There are no comments made yet.
Daniel Giugliano Accepted Answer Pending Moderation
  1. Wednesday, 12 June 2019 15:39 PM UTC
  2. PowerBuilder
  3. # 7

Dear David,

Thanks for your attention,


I really need to have an example of how to integrate powerbuilder applications with SAP Business One (on SAP HANA)

I have been told that Giuseppe Moglia, from Appeon has done something similar, I do not know if that can help you to get the example
what am I waiting for,

He knows it, it is possible to communicate with him. and save your time.

Daniel Giugliano

 

 

 

 

Comment
  1. Armeen Mazda @Appeon
  2. Wednesday, 12 June 2019 18:17 PM UTC
I agree with Daniel that you may be best off to contact Giuseppe Moglia. At a high level, it is my understanding that integrating with SAP Business One is through REST Web APIs, and PB 2017/2019 supports REST Web APIs.
  1. Helpful 1
  1. David Peace (Powersoft)
  2. Thursday, 13 June 2019 11:41 AM UTC
Thanks Armeen

I guess Daniel should cut out the middle man and talk to Giuseppe directly.
  1. Helpful
  1. Miguel Leeuwe
  2. Friday, 21 January 2022 15:21 PM UTC
I think you can find him on LinkedIn
  1. Helpful
There are no comments made yet.
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 12 June 2019 14:26 PM UTC
  2. PowerBuilder
  3. # 8

Hi

I've had a quick read of the API documentation and cannot find any code examples in C++ which it says it supports. You need to find some code examples and then convert that thinking into the PB world. Cracking this first step is always difficult, but my guess is that people have not done this yet.

Good luck

David

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.