Dynamics GP

The Lyftron Provider for Dynamics GP offers the most natural way to access Dynamics GP data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing Dynamics GP data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Dynamics GP data provider and automatically build your data migration pipelines in minutes, not months

The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Key Features

• Comprehensive Delta load mechanism.
• Real-time access to Dynamics GP.
• Comprehensive full support of ANSI Sql to query data with ease.
• Collaborative query processing.

Prerequisites

The user must have credentials for Dynamics GP, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron

Establishing a Connection with Lyftron's Quickstart Steps

Create your Dynamics GP connection with Lyftron by following the 5 easy steps show below:

Step1. Add your connection

Click on Connect section on the left panel →  Click on Add Connection button

Step2. Select your connector

In the connector selection panel, search and click Dynamics GP for your connection 

Step3. Enter your connection details

In the Connection String section enter the values of the below parameters. The following connection string is required to establish Dynamics GP connection with Lyftron.

CompanyId=[your_companyId];user=[your_user];password=[your_password];URL=[your_url];

Key	Value	Field
Connection Name	Enter your connection details	Required
CompanyId	Your company id	Required
user	Your Dynamics GP User	Required
password	Your Dynamics GP Password	Required
URL	http://{servername}:{port}/Dynamics/GPService	Required
Logfile**	Use the logfile option to debug your job and provide your connection name to generate the log file.  [ConnectionConfigurationPath]\Connection_name_log.tx	Optional
Verbosity**	Choose verbosity 1-5 based on the severity of debugging	Optional

** For more information, check the Lyftron logging and debugging section.

If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.

Step4. Test your connection

Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.

 Step5. Save your connection

Hurray! Now you have successfully connected with the Lyftron Dynamics GP connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.

Data Model

The Lyftron Provider for Dynamics GP models Dynamics GP entities in relational views, or read-only tables. The tables are determined automatically based on the metadata the provider retrieves when you connect. Any changes that you make to your Dynamics GP account, such as creating a custom field or changing its data type, are reflected on reconnection.

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Name	Type	Description
Applicant	Views	The DynamicsGP table Applicant.
ApplicantApplication	Views	The DynamicsGP table ApplicantApplication.
ApplicantApplications	Views	The DynamicsGP table ApplicantApplications.
ApplicantEducation	Views	The DynamicsGP table ApplicantEducation.
ApplicantInterview	Views	The DynamicsGP table ApplicantInterview.
ApplicantInterviewInterviewItems	Views	The DynamicsGP table ApplicantInterviewInterviewItems.
ApplicantInterviews	Views	The DynamicsGP table ApplicantInterviews.
ApplicantPreviousEmployers	Views	The DynamicsGP table ApplicantPreviousEmployers.
ApplicantReference	Views	The DynamicsGP table ApplicantReference.
ApplicantReferences	Views	The DynamicsGP table ApplicantReferences.
ApplicantSchools	Views	The DynamicsGP table ApplicantSchools.
ApplicantSkill	Views	The DynamicsGP table ApplicantSkill.
ApplicantSkills	Views	The DynamicsGP table ApplicantSkills.
ApplicantTest	Views	The DynamicsGP table ApplicantTest.
ApplicantTests	Views	The DynamicsGP table ApplicantTests.
ApplicantWorkHistory	Views	The DynamicsGP table ApplicantWorkHistory.
BackOfficeRole	Views	The DynamicsGP table BackOfficeRole.
BackOfficeRoleAssignment	Views	The DynamicsGP table BackOfficeRoleAssignment.
Bank	Views	The DynamicsGP table Bank.
BusinessObjectUserAssignment	Views	The DynamicsGP table BusinessObjectUserAssignment.
CashReceipt	Views	The DynamicsGP table CashReceipt.
CashReceiptDistributions	Views	The DynamicsGP table CashReceiptDistributions.
ChangedCurrencyKey	Views	The DynamicsGP table ChangedCurrencyKey.
ChangedCustomerAddressKey	Views	The DynamicsGP table ChangedCustomerAddressKey.
ChangedCustomerKey	Views	The DynamicsGP table ChangedCustomerKey.
ChangedInternetAddressKey	Views	The DynamicsGP table ChangedInternetAddressKey.
ChangedItemKey	Views	The DynamicsGP table ChangedItemKey.
ChangedPriceLevelKey	Views	The DynamicsGP table ChangedPriceLevelKey.
ChangedPricingKey	Views	The DynamicsGP table ChangedPricingKey.
ChangedSalesInvoiceKey	Views	The DynamicsGP table ChangedSalesInvoiceKey.
ChangedSalesOrderKey	Views	The DynamicsGP table ChangedSalesOrderKey.
ChangedSalespersonKey	Views	The DynamicsGP table ChangedSalespersonKey.
ChangedUofMScheduleKey	Views	The DynamicsGP table ChangedUofMScheduleKey.
Company	Views	The DynamicsGP table Company.
CompanyAddress	Views	The DynamicsGP table CompanyAddress.
CountryRegionCode	Views	The DynamicsGP table CountryRegionCode.
Currency	Views	The DynamicsGP table Currency.
CurrencyAccess	Views	The DynamicsGP table CurrencyAccess.
CurrencyPostingAccount	Views	The DynamicsGP table CurrencyPostingAccount.
Customer	Views	The DynamicsGP table Customer.
CustomerAddress	Views	The DynamicsGP table CustomerAddress.
CustomerAddresses	Views	The DynamicsGP table CustomerAddresses.
CustomerReceivablesSummary	Views	The DynamicsGP table CustomerReceivablesSummary.
Employee	Views	The DynamicsGP table Employee.
EmployeeAddress	Views	The DynamicsGP table EmployeeAddress.
EmployeeAddresses	Views	The DynamicsGP table EmployeeAddresses.
EmployeePayCode	Views	The DynamicsGP table EmployeePayCode.
Fee	Views	The DynamicsGP table Fee.
GLAccount	Views	The DynamicsGP table GLAccount.
GLAccountCategory	Views	The DynamicsGP table GLAccountCategory.
GLAccountFormat	Views	The DynamicsGP table GLAccountFormat.
GLFixedAllocationAccount	Views	The DynamicsGP table GLFixedAllocationAccount.
GLFixedAllocationAccountDistributions	Views	The DynamicsGP table GLFixedAllocationAccountDistributions.
GLPostingAccount	Views	The DynamicsGP table GLPostingAccount.
GLPostingAccountCurrencies	Views	The DynamicsGP table GLPostingAccountCurrencies.
GLTransaction	Views	The DynamicsGP table GLTransaction.
GLTransactionLines	Views	The DynamicsGP table GLTransactionLines.
GLUnitAccount	Views	The DynamicsGP table GLUnitAccount.
GLVariableAllocationAccount	Views	The DynamicsGP table GLVariableAllocationAccount.
GLVariableAllocationAccountDistributions	Views	The DynamicsGP table GLVariableAllocationAccountDistributions.
HRRequisition	Views	The DynamicsGP table HRRequisition.
InventoriedItem	Views	The DynamicsGP table InventoriedItem.
InventoryAdjustment	Views	The DynamicsGP table InventoryAdjustment.
InventoryAdjustmentLines	Views	The DynamicsGP table InventoryAdjustmentLines.
InventoryTransfer	Views	The DynamicsGP table InventoryTransfer.
InventoryTransferLines	Views	The DynamicsGP table InventoryTransferLines.
InventoryVariance	Views	The DynamicsGP table InventoryVariance.
InventoryVarianceLines	Views	The DynamicsGP table InventoryVarianceLines.
Item	Views	The DynamicsGP table Item.
ItemClass	Views	The DynamicsGP table ItemClass.
ItemCurrency	Views	The DynamicsGP table ItemCurrency.
ItemVendor	Views	The DynamicsGP table ItemVendor.
ItemWarehouse	Views	The DynamicsGP table ItemWarehouse.
ManufacturingOrder	Views	The DynamicsGP table ManufacturingOrder.
ManufacturingOrderPickList	Views	The DynamicsGP table ManufacturingOrderPickList.
ManufacturingOrderRoute	Views	The DynamicsGP table ManufacturingOrderRoute.
MulticurrencySetup	Views	The DynamicsGP table MulticurrencySetup.
PayablesCreditMemo	Views	The DynamicsGP table PayablesCreditMemo.
PayablesDocument	Views	The DynamicsGP table PayablesDocument.
PayablesDocumentDistributions	Views	The DynamicsGP table PayablesDocumentDistributions.
PayablesDocumentTaxes	Views	The DynamicsGP table PayablesDocumentTaxes.
PayablesFinanceCharge	Views	The DynamicsGP table PayablesFinanceCharge.
PayablesInvoice	Views	The DynamicsGP table PayablesInvoice.
PayablesMiscellaneousCharge	Views	The DynamicsGP table PayablesMiscellaneousCharge.
PayablesReturn	Views	The DynamicsGP table PayablesReturn.
PaymentCardType	Views	The DynamicsGP table PaymentCardType.
PaymentTerms	Views	The DynamicsGP table PaymentTerms.
PlannedOrder	Views	The DynamicsGP table PlannedOrder.
PlannedOrderItems	Views	The DynamicsGP table PlannedOrderItems.
Policy	Views	The DynamicsGP table Policy.
PolicyBehaviors	Views	The DynamicsGP table PolicyBehaviors.
PriceLevel	Views	The DynamicsGP table PriceLevel.
Pricing	Views	The DynamicsGP table Pricing.
PricingDetails	Views	The DynamicsGP table PricingDetails.
Project	Views	The DynamicsGP table Project.
ProjectAccounts	Views	The DynamicsGP table ProjectAccounts.
ProjectBillingCycles	Views	The DynamicsGP table ProjectBillingCycles.
ProjectBudget	Views	The DynamicsGP table ProjectBudget.
ProjectBudgets	Views	The DynamicsGP table ProjectBudgets.
ProjectChangeOrder	Views	The DynamicsGP table ProjectChangeOrder.
ProjectChangeOrderBudgets	Views	The DynamicsGP table ProjectChangeOrderBudgets.
ProjectChangeOrderFees	Views	The DynamicsGP table ProjectChangeOrderFees.
ProjectContract	Views	The DynamicsGP table ProjectContract.
ProjectContractAccounts	Views	The DynamicsGP table ProjectContractAccounts.
ProjectContractBillingCycles	Views	The DynamicsGP table ProjectContractBillingCycles.
ProjectEmployeeExpense	Views	The DynamicsGP table ProjectEmployeeExpense.
ProjectEmployeeExpenseDistributions	Views	The DynamicsGP table ProjectEmployeeExpenseDistributions.
ProjectEmployeeExpenseLines	Views	The DynamicsGP table ProjectEmployeeExpenseLines.
ProjectEquipmentList	Views	The DynamicsGP table ProjectEquipmentList.
ProjectFees	Views	The DynamicsGP table ProjectFees.
ProjectMiscellaneousLog	Views	The DynamicsGP table ProjectMiscellaneousLog.
ProjectMiscellaneousLogDistributions	Views	The DynamicsGP table ProjectMiscellaneousLogDistributions.
ProjectMiscellaneousLogLines	Views	The DynamicsGP table ProjectMiscellaneousLogLines.
ProjectTimesheet	Views	The DynamicsGP table ProjectTimesheet.
ProjectTimesheetDistributions	Views	The DynamicsGP table ProjectTimesheetDistributions.
ProjectTimesheetLines	Views	The DynamicsGP table ProjectTimesheetLines.
PurchaseInvoice	Views	The DynamicsGP table PurchaseInvoice.
PurchaseInvoiceDistributions	Views	The DynamicsGP table PurchaseInvoiceDistributions.
PurchaseInvoiceFreightTaxes	Views	The DynamicsGP table PurchaseInvoiceFreightTaxes.
PurchaseInvoiceLines	Views	The DynamicsGP table PurchaseInvoiceLines.
PurchaseInvoiceMiscellaneousTaxes	Views	The DynamicsGP table PurchaseInvoiceMiscellaneousTaxes.
PurchaseInvoiceTaxes	Views	The DynamicsGP table PurchaseInvoiceTaxes.
PurchaseOrder	Views	The DynamicsGP table PurchaseOrder.
PurchaseOrderFreightTaxes	Views	The DynamicsGP table PurchaseOrderFreightTaxes.
PurchaseOrderLines	Views	The DynamicsGP table PurchaseOrderLines.
PurchaseOrderMiscellaneousTaxes	Views	The DynamicsGP table PurchaseOrderMiscellaneousTaxes.
PurchaseOrderTaxes	Views	The DynamicsGP table PurchaseOrderTaxes.
PurchaseReceipt	Views	The DynamicsGP table PurchaseReceipt.
PurchaseReceiptDistributions	Views	The DynamicsGP table PurchaseReceiptDistributions.
PurchaseReceiptLines	Views	The DynamicsGP table PurchaseReceiptLines.
PurchaseReceiptUserDefined	Views	The DynamicsGP table PurchaseReceiptUserDefined.
ReceivablesCreditMemo	Views	The DynamicsGP table ReceivablesCreditMemo.
ReceivablesDebitMemo	Views	The DynamicsGP table ReceivablesDebitMemo.
ReceivablesDebitMemoCommissions	Views	The DynamicsGP table ReceivablesDebitMemoCommissions.
ReceivablesDocument	Views	The DynamicsGP table ReceivablesDocument.
ReceivablesDocumentDistributions	Views	The DynamicsGP table ReceivablesDocumentDistributions.
ReceivablesDocumentTaxes	Views	The DynamicsGP table ReceivablesDocumentTaxes.
ReceivablesFinanceCharge	Views	The DynamicsGP table ReceivablesFinanceCharge.
ReceivablesInvoice	Views	The DynamicsGP table ReceivablesInvoice.
ReceivablesInvoiceCommissions	Views	The DynamicsGP table ReceivablesInvoiceCommissions.
ReceivablesReturn	Views	The DynamicsGP table ReceivablesReturn.
ReceivablesReturnCommissions	Views	The DynamicsGP table ReceivablesReturnCommissions.
ReceivablesServiceRepair	Views	The DynamicsGP table ReceivablesServiceRepair.
ReceivablesServiceRepairCommissions	Views	The DynamicsGP table ReceivablesServiceRepairCommissions.
ReceivablesWarranty	Views	The DynamicsGP table ReceivablesWarranty.
ReturnMaterialAuthorization	Views	The DynamicsGP table ReturnMaterialAuthorization.
ReturnMaterialAuthorizationAudits	Views	The DynamicsGP table ReturnMaterialAuthorizationAudits.
ReturnMaterialAuthorizationLines	Views	The DynamicsGP table ReturnMaterialAuthorizationLines.
SalesBackorder	Views	The DynamicsGP table SalesBackorder.
SalesBackorderLines	Views	The DynamicsGP table SalesBackorderLines.
SalesBackorderPayments	Views	The DynamicsGP table SalesBackorderPayments.
SalesDocument	Views	The DynamicsGP table SalesDocument.
SalesDocumentCommissions	Views	The DynamicsGP table SalesDocumentCommissions.
SalesDocumentFreightTaxes	Views	The DynamicsGP table SalesDocumentFreightTaxes.
SalesDocumentMiscellaneousTaxes	Views	The DynamicsGP table SalesDocumentMiscellaneousTaxes.
SalesDocumentProcessHolds	Views	The DynamicsGP table SalesDocumentProcessHolds.
SalesDocumentTaxes	Views	The DynamicsGP table SalesDocumentTaxes.
SalesDocumentTrackingNumbers	Views	The DynamicsGP table SalesDocumentTrackingNumbers.
SalesFulfillmentOrder	Views	The DynamicsGP table SalesFulfillmentOrder.
SalesFulfillmentOrderDistributions	Views	The DynamicsGP table SalesFulfillmentOrderDistributions.
SalesFulfillmentOrderLines	Views	The DynamicsGP table SalesFulfillmentOrderLines.
SalesFulfillmentOrderPayments	Views	The DynamicsGP table SalesFulfillmentOrderPayments.
SalesInvoice	Views	The DynamicsGP table SalesInvoice.
SalesInvoiceDistributions	Views	The DynamicsGP table SalesInvoiceDistributions.
SalesInvoiceLines	Views	The DynamicsGP table SalesInvoiceLines.
SalesInvoicePayments	Views	The DynamicsGP table SalesInvoicePayments.
SalesOrder	Views	The DynamicsGP table SalesOrder.
SalesOrderLines	Views	The DynamicsGP table SalesOrderLines.
SalesOrderPayments	Views	The DynamicsGP table SalesOrderPayments.
Salesperson	Views	The DynamicsGP table Salesperson.
SalespersonCommissions	Views	The DynamicsGP table SalespersonCommissions.
SalespersonSalesHistory	Views	The DynamicsGP table SalespersonSalesHistory.
SalesProcessHoldSetup	Views	The DynamicsGP table SalesProcessHoldSetup.
SalesQuote	Views	The DynamicsGP table SalesQuote.
SalesQuoteLines	Views	The DynamicsGP table SalesQuoteLines.
SalesReturn	Views	The DynamicsGP table SalesReturn.
SalesReturnDistributions	Views	The DynamicsGP table SalesReturnDistributions.
SalesReturnLines	Views	The DynamicsGP table SalesReturnLines.
SalesReturnPayments	Views	The DynamicsGP table SalesReturnPayments.
SalesTerritory	Views	The DynamicsGP table SalesTerritory.
SalesTerritorySalesHistory	Views	The DynamicsGP table SalesTerritorySalesHistory.
Service	Views	The DynamicsGP table Service.
ServiceCall	Views	The DynamicsGP table ServiceCall.
ServiceCallAdditionalCharges	Views	The DynamicsGP table ServiceCallAdditionalCharges.
ServiceCallEquipmentCodes	Views	The DynamicsGP table ServiceCallEquipmentCodes.
ServiceCallExpenses	Views	The DynamicsGP table ServiceCallExpenses.
ServiceCallLabor	Views	The DynamicsGP table ServiceCallLabor.
ServiceCallParts	Views	The DynamicsGP table ServiceCallParts.
ServiceEquipment	Views	The DynamicsGP table ServiceEquipment.
ServiceEquipmentReadings	Views	The DynamicsGP table ServiceEquipmentReadings.
ServiceQuote	Views	The DynamicsGP table ServiceQuote.
ServiceQuoteAdditionalCharges	Views	The DynamicsGP table ServiceQuoteAdditionalCharges.
ServiceQuoteEquipmentCodes	Views	The DynamicsGP table ServiceQuoteEquipmentCodes.
ServiceQuoteExpenses	Views	The DynamicsGP table ServiceQuoteExpenses.
ServiceQuoteLabor	Views	The DynamicsGP table ServiceQuoteLabor.
ServiceQuoteParts	Views	The DynamicsGP table ServiceQuoteParts.
ShippingMethod	Views	The DynamicsGP table ShippingMethod.
Skill	Views	The DynamicsGP table Skill.
SkillSet	Views	The DynamicsGP table SkillSet.
SkillSetSkills	Views	The DynamicsGP table SkillSetSkills.
UofMSchedule	Views	The DynamicsGP table UofMSchedule.
UofMScheduleDetails	Views	The DynamicsGP table UofMScheduleDetails.
UserAssignableBusinessObject	Views	The DynamicsGP table UserAssignableBusinessObject.
Vendor	Views	The DynamicsGP table Vendor.
VendorAddress	Views	The DynamicsGP table VendorAddress.
VendorAddresses	Views	The DynamicsGP table VendorAddresses.
VendorManufacturingOrder	Views	The DynamicsGP table VendorManufacturingOrder.
VendorManufacturingOrderRoute	Views	The DynamicsGP table VendorManufacturingOrderRoute.
VendorPlannedOrder	Views	The DynamicsGP table VendorPlannedOrder.
Warehouse	Views	The DynamicsGP table Warehouse.
WarehouseBins	Views	The DynamicsGP table WarehouseBins.