powerGate with SAGE


powerGate is meanwhile quite popular when it comes to connecting Vault with SAP, but what about other ERP systems? The powerGate server can be extended with plugins that allows to connect to potential any ERP system. Since the introduction of powerGate, we had the pleasure working with you on several projects, and today I’d like to give you some insight about the integration with KHK SAGE.

In the context of this project, we had the luxury to connect to the SAGE database. Actually, some special SQL views has been provided in order to read data from SAGE. This is a quite convenient approach, as SQL is known by almost everyone, while dealing with the API of an unknown system is of course more time consuming.

So, we’ve created a little powerGate plugin, via the standard and open .Net interface, that connects to the SAGE SQL views and exposes the data via REST/OData to the powerGate client. This took just a few hours of work, and then we were able to test the connection via Google Chrome. In the browser you can read, create, update data just via simple URLs and according arguments. This is grate, as you can immediately check the correct function without completing the integration in the first place. The next step was to start a PowerShell environment, such as PowerGUI or the Windows PowerShell ISE, and with the simple powerGate command-lets, such as Get-ERPObject, Add-ERPObject and Update-ERPObject, test the connectivity.

Add-ERPObject -Entity "SAGE.Services.Material" -Properties @{"Number"="4711";"Title"="test item"}
Get-ERPObject -Entity "SAGE.Services.Material" -Key @{"Number"="4711"}
Update-ERPObject -Entity "SAGE.Services.Material" -Properties @{"Number"="4711";"Title"="Flywheel 15/3"}

Now that the client was talking to the server and the data came through, we started to use the command-lets within the Data Standard dialogs in order to show item data, pick project and related information, access project items, and the like.

As you know, the Vault Data Standard dialogs has PowerShell as scripting language on the backend side. The powerGate client exposes the command-lets described before as native PowerShell commands, which can be easily consumed within the Data Standard dialogs. The dialogs can therefore show ERP data in a tab, or allow the user to enter a project number, look up for it and the pull the data over to Vault, or display the active projects in a list, and so on. It is also possible to create custom actions, such as context menus or place buttons in dialogs or tabs that communicates with the ERP system and updates data in Vault. As powerJobs is also based on PowerShell scripts, it’s possible to sync or transfer data at lifecycle change, such as updating items, transfer the BOM or any other information. The possibilities are endless.

The users now can easily link Vault projects, files and items to SAGE elements and so complete the Vault data with SAGE information, without leaving his familiar environment.

If you want to know more about powerGate, just get in touch with us.


This entry was posted in Data Standard, Vault-ERP connection. Bookmark the permalink.

1 Response to powerGate with SAGE

  1. Pingback: Ways of integrating Vault with ERP | coolorange

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s