Query interface to Doxis ERP Connection Service (ERPCS)

Hello Marc,

yes, please schedule a meeting with me. As admin you should be able to see my mailadress.

I have another use-case and also discussed this with Rene Wenzel and it seems that SER is planning to standardize the interfaces.

The second use case: We want to archive our internal final test reports in Doxis. I need a few information from the ERP system, e.g. value list for the company code. In the DIIA plugin the company codes are available from the ERPCS (search dialog -> SearchRecipient -> ERP function SearchRecipientMasterData). This function is unfortunatly not available in the cubeDesigner.

My Idea was to use the data connection as REST. But maybe we found another solution in our meeting.

Best regards,

Michael

Dear Michael,

thanks for writing down your requirements. As I understand you want to have a selection of projects within Doxis webCube.

The main difference between a SmartBridge Product and the ERP Connection Service, is that SmartBridge products synchronize ERP/CRM entities with Doxis objects. In your case it would be a project e-file. In that case you can use standard features of cubeDesigner and win/webCube to query projects and fetch any field you want from the hitlist - without any coding!

We have an approach for a generic SmartBridge. Today we have adapters for Salesforce and SAP SuccessFactors and we are planning for JDBC.

From the product side, I would like to go in this direction.

It would be nice to discuss this in a meeting with you and our SmartBridge product owner. Would you like me to schedule a meeting?

Dear Marc,

thank you for your reply. I try to explain our use case:

We had a database connection configured to a MS SQL database to pick a project from the EPR system to fill up the descriptors for a record set, it was project no. and project name.

We synced the data from our Oracle based ERP database to MSSQL. Now we replaced the sync and we coded our own functions in the EPRCS to the needs of our ERP system, no MSSQL is requiered anymore.

As I understand: the database connection needs the database driver installed on the client. MSSQL is included in the Windows OS, but the Oracle instant client needs to be installed. I dont know how the behavior is on the webCube.

I could imaging to use more ERPCS functions especially in value lists to avoid data inconsistency, e.g. Supplier no or project no.

As I understand, the SmartBridge is not available for our ERP system and I dont see a benefit to buy an additional product when we have a central standardized REST interface to our ERP system which is already webCube-ready.

Right now, the ERPCS is only available for the solution packages like the DIIA and its quiert complicated to connect a solution to it.

I hope the explanation is sufficient and understandable enough to be able to make a decision to implement or not.

Thanks.

Best regards, Michael

Dear Michael,

could you please share the use case behind this request?
Normally we use SmartBridge products to synchronize ERP entities with Doxis objects. Then you can use standard queries and hitlists to work with this data.

What is your requirement to use ERP data as a data source in Doxis?