Sage Intacct

The Lyftron Provider for Sage Intacct offers the most natural way to access Sage Intacct 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 Sage Intacct data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Sage Intacct 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 Sage Intacct.
• Comprehensive full support of ANSI Sql to query data with ease.
• Collaborative query processing.

Prerequisites

The user must have credentials for Sage Intacct, 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 Sage Intacct 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 Sage Intacct 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 Sage Intacct connection with Lyftron.

User=[your_user];CompanyID=[your_Company];Password=[your_password];SenderID=[your_senderID];SenderPassword=[your_sender_password];

Key	Value	Field
Connection Name	Enter your connection details	Required
User	Your Sage Intacct User	Required
CompanyID	Your Sage Intacct CompanyID	Required
Password	Your Sage Intacct	Required
SenderID	Your SenderID	Required
SenderPassword	Your Sage Intacct SenderPassword	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 Sage Intacct connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.

Data Model

The Lyftron Provider for Sage Intacct models entities in the Sage Intacct API as tables, views, and stored procedures. These are defined in schema files, which are simple, text-based configuration files.

API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Tables

The Lyftron Provider for Sage Intacct models Item Listings in tables so that they can be easily queried, updated, and deleted. You can list items on your Sage Intacct store by calling the AddItem stored procedure.

Views

Views are tables that cannot be modified. Typically, read-only data are shown as views.

Name	Type	Description
AcctLabelTaxGroup	Tables	Retrieves AcctLabelTaxGroup report data.
AcctRange	Tables	Retrieves AcctRange report data.
ACHBank	Tables	Retrieves ACHBank report data.
ActivityLog	Tables	Retrieves ActivityLog report data.
Aisle	Tables	Retrieves Aisle report data.
Allocation	Tables	Retrieves Allocation report data.
APAccountLabel	Tables	Retrieves APAccountLabel report data.
APAdjustment	Tables	Retrieves APAdjustment report data.
APBill	Tables	Retrieves APBill report data.
APBillBatch	Tables	Retrieves APBillBatch report data.
APPymt	Tables	Retrieves APPymt report data.
APRecurBill	Tables	Retrieves APRecurBill report data.
APTerm	Tables	Retrieves APTerm report data.
ARAccountLabel	Tables	Retrieves ARAccountLabel report data.
ARAdjustment	Tables	Retrieves ARAdjustment report data.
ARInvoice	Tables	Retrieves ARInvoice report data.
ARInvoiceBatch	Tables	Retrieves ARInvoiceBatch report data.
ARPaymentBatch	Tables	Retrieves ARPaymentBatch report data.
ARTerm	Tables	Retrieves ARTerm report data.
Attendee	Tables	Retrieves Attendee report data.
Billing_Contact	Tables	Retrieves Billing_Contact report data.
Bin	Tables	Retrieves Bin report data.
BudgetHeader	Tables	Retrieves BudgetHeader report data.
CheckingAccount	Tables	Retrieves CheckingAccount report data.
Class	Tables	Retrieves Class report data.
ClassGroup	Tables	Retrieves ClassGroup report data.
Comments	Tables	Retrieves Comments report data.
Contact	Tables	Retrieves Contact report data.
CreditCard	Tables	Retrieves CreditCard report data.
Customer	Tables	Retrieves Customer report data.
CustomerEmailTemplate	Tables	Retrieves CustomerEmailTemplate report data.
CustomerGroup	Tables	Retrieves CustomerGroup report data.
CustomerVisibility	Tables	Retrieves CustomerVisibility report data.
CustType	Tables	Retrieves CustType report data.
Department	Tables	Retrieves Department report data.
DepartmentGroup	Tables	Retrieves DepartmentGroup report data.
EarningType	Tables	Retrieves EarningType report data.
EEAccountLabel	Tables	Retrieves EEAccountLabel report data.
EExpenses	Tables	Retrieves EExpenses report data.
EmailTemplate	Tables	Retrieves EmailTemplate report data.
Employee	Tables	Retrieves Employee report data.
EmployeeEntityContacts	Tables	Retrieves EmployeeEntityContacts report data.
EmployeeGroup	Tables	Retrieves EmployeeGroup report data.
EmployeeOutOfOffice	Tables	Retrieves EmployeeOutOfOffice report data.
EmployeePositionSkill	Tables	Retrieves EmployeePositionSkill report data.
EmployeeRate	Tables	Retrieves EmployeeRate report data.
EmployeeType	Tables	Retrieves EmployeeType report data.
ExchangeRate	Tables	Retrieves ExchangeRate report data.
ExchangeRateTypes	Tables	Retrieves ExchangeRateTypes report data.
ExpenseAdjustments	Tables	Retrieves ExpenseAdjustments report data.
ExpensePaymentType	Tables	Retrieves ExpensePaymentType report data.
GAAPAdjJrnl	Tables	Retrieves GAAPAdjJrnl report data.
GLAccount	Tables	Retrieves GLAccount report data.
GLAcctGrp	Tables	Retrieves GLAcctGrp report data.
GLAcctGrpMember	Tables	Retrieves GLAcctGrpMember report data.
GLBatch	Tables	Retrieves GLBatch report data.
GLBudget	Tables	Retrieves GLBudget report data.
GLCoaCatMember	Tables	Retrieves GLCoaCatMember report data.
GLCompGrpMember	Tables	Retrieves GLCompGrpMember report data.
ICRow	Tables	Retrieves ICRow report data.
InvDocument	Tables	Retrieves InvDocument report data.
InvDocumentParams	Tables	Retrieves InvDocumentParams report data.
InvPriceList	Tables	Retrieves InvPriceList report data.
Item	Tables	Retrieves Item report data.
ItemGroup	Tables	Retrieves ItemGroup report data.
ItemTaxGroup	Tables	Retrieves ItemTaxGroup report data.
Journal	Tables	Retrieves Journal report data.
Location	Tables	Retrieves Location report data.
LocationGroup	Tables	Retrieves LocationGroup report data.
Misc_Supporting_Document	Tables	Retrieves Misc_Supporting_Document report data.
OutOfOffice	Tables	Retrieves OutOfOffice report data.
PODocument	Tables	Retrieves PODocument report data.
PODocumentParams	Tables	Retrieves PODocumentParams report data.
POPriceList	Tables	Retrieves POPriceList report data.
PositionSkill	Tables	Retrieves PositionSkill report data.
ProductLine	Tables	Retrieves ProductLine report data.
Project	Tables	Retrieves Project report data.
ProjectGroup	Tables	Retrieves ProjectGroup report data.
ProjectResources	Tables	Retrieves ProjectResources report data.
ProjectStatus	Tables	Retrieves ProjectStatus report data.
ProjectTransactionRule	Tables	Retrieves ProjectTransactionRule report data.
ProjectType	Tables	Retrieves ProjectType report data.
RecurGLBatch	Tables	Retrieves RecurGLBatch report data.
RenewalMacro	Tables	Retrieves RenewalMacro report data.
ReportingPeriod	Tables	Retrieves ReportingPeriod report data.
RevRecTemplate	Tables	Retrieves RevRecTemplate report data.
RevRecTemplMilestone	Tables	Retrieves RevRecTemplMilestone report data.
SavingsAccount	Tables	Retrieves SavingsAccount report data.
Seminar	Tables	Retrieves Seminar report data.
Seminar_Package	Tables	Retrieves Seminar_Package report data.
Seminar_Registration	Tables	Retrieves Seminar_Registration report data.
SODocument	Tables	Retrieves SODocument report data.
SODocumentParams	Tables	Retrieves SODocumentParams report data.
SOPriceList	Tables	Retrieves SOPriceList report data.
StatAccount	Tables	Retrieves StatAccount report data.
StatJournal	Tables	Retrieves StatJournal report data.
STKitDocument	Tables	Retrieves STKitDocument report data.
Task	Tables	Retrieves Task report data.
TaskResources	Tables	Retrieves TaskResources report data.
TaxGroup	Tables	Retrieves TaxGroup report data.
TerritoryGroup	Tables	Retrieves TerritoryGroup report data.
Timesheet	Tables	Retrieves Timesheet report data.
TimeType	Tables	Retrieves TimeType report data.
TransactionRule	Tables	Retrieves TransactionRule report data.
TransactionRuleDetail	Tables	Retrieves TransactionRuleDetail report data.
TrxCurrencies	Tables	Retrieves TrxCurrencies report data.
UoM	Tables	Retrieves UoM report data.
UserAdjJrnl	Tables	Retrieves UserAdjJrnl report data.
UserInfo	Tables	Retrieves UserInfo report data.
UserRoles	Tables	Retrieves UserRoles report data.
Vendor	Tables	Retrieves Vendor report data.
VendorGroup	Tables	Retrieves VendorGroup report data.
VendorVisibility	Tables	Retrieves VendorVisibility report data.
VendType	Tables	Retrieves VendType report data.
Warehouse	Tables	Retrieves Warehouse report data.
AllocationEntry	Views	Retrieves AllocationEntry report data.
APAdjustmentItem	Views	Retrieves APAdjustmentItem report data.
APBillItem	Views	Retrieves APBillItem report data.
APBillPayment	Views	Retrieves APBillPayment report data.
APIUsageDetail	Views	Retrieves APIUsageDetail report data.
APIUsageSummary	Views	Retrieves APIUsageSummary report data.
APPayment	Views	Retrieves APPayment report data.
APPaymentItem	Views	Retrieves APPaymentItem report data.
APPaymentRequest	Views	Retrieves APPaymentRequest report data.
APRecurBillEntry	Views	Retrieves APRecurBillEntry report data.
ARAdjustmentItem	Views	Retrieves ARAdjustmentItem report data.
ARInvoiceItem	Views	Retrieves ARInvoiceItem report data.
ARPayment	Views	Retrieves ARPayment report data.
ARPaymentItem	Views	Retrieves ARPaymentItem report data.
ARRecurInvoice	Views	Retrieves ARRecurInvoice report data.
ARRecurInvoiceEntry	Views	Retrieves ARRecurInvoiceEntry report data.
BankFee	Views	Retrieves BankFee report data.
BankFeeEntry	Views	Retrieves BankFeeEntry report data.
BillingSchedule	Views	Retrieves BillingSchedule report data.
CCTransaction	Views	Retrieves CCTransaction report data.
CCTransactionEntry	Views	Retrieves CCTransactionEntry report data.
ChargePayoff	Views	Retrieves ChargePayoff report data.
ChargePayoffEntry	Views	Retrieves ChargePayoffEntry report data.
CNSAcctBal	Views	Retrieves CNSAcctBal report data.
Company	Views	Retrieves Company report data.
CreditCardFee	Views	Retrieves CreditCardFee report data.
CreditCardFeeEntry	Views	Retrieves CreditCardFeeEntry report data.
DDSJob	Views	Retrieves DDSJob report data.
Deposit	Views	Retrieves Deposit report data.
DepositEntry	Views	Retrieves DepositEntry report data.
EExpensesItem	Views	Retrieves EExpensesItem report data.
EExpensesPayment	Views	Retrieves EExpensesPayment report data.
EPPayment	Views	Retrieves EPPayment report data.
EPPaymentItem	Views	Retrieves EPPaymentItem report data.
EPPaymentRequest	Views	Retrieves EPPaymentRequest report data.
ExchangeRateEntry	Views	Retrieves ExchangeRateEntry report data.
ExpenseAdjustmentsItem	Views	Retrieves ExpenseAdjustmentsItem report data.
FundsTransfer	Views	Retrieves FundsTransfer report data.
FundsTransferEntry	Views	Retrieves FundsTransferEntry report data.
GLAccountBalance	Views	Retrieves GLAccountBalance report data.
GLAcctGrpHierarchy	Views	Retrieves GLAcctGrpHierarchy report data.
GLDetail	Views	Retrieves GLDetail report data.
GLEntry	Views	Retrieves GLEntry report data.
GLResolve	Views	Retrieves GLResolve report data.
InvDocumentEntry	Views	Retrieves InvDocumentEntry report data.
InvDocumentSubtotals	Views	Retrieves InvDocumentSubtotals report data.
InvoiceRun	Views	Retrieves InvoiceRun report data.
InvPriceListEntry	Views	Retrieves InvPriceListEntry report data.
InvRecurSubtotals	Views	Retrieves InvRecurSubtotals report data.
ItemComponent	Views	Retrieves ItemComponent report data.
OtherReceipts	Views	Retrieves OtherReceipts report data.
OtherReceiptsEntry	Views	Retrieves OtherReceiptsEntry report data.
PODocumentEntry	Views	Retrieves PODocumentEntry report data.
PODocumentSubtotals	Views	Retrieves PODocumentSubtotals report data.
POPriceListEntry	Views	Retrieves POPriceListEntry report data.
PORecurSubtotals	Views	Retrieves PORecurSubtotals report data.
PSADocumentEntry	Views	Retrieves PSADocumentEntry report data.
RecurDocumentEntry	Views	Retrieves RecurDocumentEntry report data.
RecurGLEntry	Views	Retrieves RecurGLEntry report data.
RevRecChangeLog	Views	Retrieves RevRecChangeLog report data.
RevRecSchedule	Views	Retrieves RevRecSchedule report data.
RevRecScheduleEntry	Views	Retrieves RevRecScheduleEntry report data.
RevRecScheduleEntryTask	Views	Retrieves RevRecScheduleEntryTask report data.
SODocumentEntry	Views	Retrieves SODocumentEntry report data.
SODocumentSubtotals	Views	Retrieves SODocumentSubtotals report data.
SOPriceListEntry	Views	Retrieves SOPriceListEntry report data.
SORecurDocument	Views	Retrieves SORecurDocument report data.
SORecurSubtotals	Views	Retrieves SORecurSubtotals report data.
STKitDocumentEntry	Views	Retrieves STKitDocumentEntry report data.
TerritoryGrpMember	Views	Retrieves TerritoryGrpMember report data.
TimesheetEntry	Views	Retrieves TimesheetEntry report data.
TransTmplBatch	Views	Retrieves TransTmplBatch report data.
TransTmplEntry	Views	Retrieves TransTmplEntry report data.
UoMDetail	Views	Retrieves UoMDetail report data.
UserRights	Views	Retrieves UserRights report data.
WfpmPaymentRequest	Views	Retrieves WfpmPaymentRequest report data.