Unique Features

• Establish direct database connections to Microsoft Dynamics GP, supporting both Windows and SQL authentication for secure access.

• Configure a specific ErrorCodes Catalog for detailed GP error reporting and define the Dynamics GP Version to ensure schema compatibility.

• Read data from GP by selecting a Source Object or crafting flexible custom SQL Queries with SSIS variable support.

• Easily retrieve the latest metadata and update component fields using the Refresh Component feature.

• Perform diverse write operations including Create, Update, Delete, and Void records directly within your Dynamics GP database.

• Streamline data mapping with options to Map Unmapped Fields automatically or Clear All Mappings for a fresh configuration.

• Implement robust Error Handling with the ability to redirect erroneous rows to an error output, providing specific GP error messages.

• Utilize the specialized GP Next Document Number Generator to produce sequential IDs for records that lack automatic numbering.

• Easily generate unique IDs for specific transaction types by configuring the Document Transaction Type and DOCID (e.g., for Sales Order Processing).

• Components dynamically leverage XML Schema files to determine available GP objects and their field information for precise data manipulation.

• Customize your integration by modifying or providing your own schema files to adapt to unique GP configurations and extensions.