eConnect is one of the most powerful and game changing products ever produced by Microsoft and it’s the engine we use with SmartConnect when connecting to Dynamics GP. Unfortunately not every function and module in Microsoft Dynamics GP is supported by eConnect nodes. The good thing is that with Node Builder this is no longer a limitation. Node Builder lets the non-developer write complex data validating nodes that sit right inside eConnect. Just like how Extender takes the development out of adding screens to GP, Node Builder takes the development out of building an eConnect node.
An eConnect node is a specific stored procedure that knows how to populate a table or set of tables within Microsoft Dynamics GP. A node also contains all the business rules of Microsoft Dynamics GP that are applied if you were to update those tables through the GP user interface. A good node makes sure that all the data entered into Microsoft Dynamics GP via eConnect is valid.
There are two ways:
Become a software developer and SQL server guru, as well as Microsoft Dynamics GP expert – and write your own eConnect stored procedure to create and populate the SQL tables you need
Use Node Builder. Node Builder is an easy to use interface that is a lot like SmartList Builder. Node Builder allows you to choose the tables you want to populate and then choose the fields that will be available to be populated with this node. Node Builder also lets you define your own rules about data validation. For example, you could check that an inventory item exists before you create a specific in transit inventory transfer.
You still need to be a Microsoft Dynamics GP expert to use Node Builder and have a good understanding of the table structure and the business rules from the front end. You do not need the ability to write code, however it helps to think like a programmer without being one.