This connector is currently in beta and subject to change.

The Sisense Intacct connector is a standalone connector that allows you to import data from Intacct into the ElastiCube Manager. After you have downloaded and installed the connector, you can connect through a connection string you provide Sisense in the ElastiCube Manager. The connection string is used to authenticate users who want to connect to Intacct.

Once you have connected to Intacct, you can import a variety of tables from the Intacct API.

This page describes how to install the Intacct connector, how to connect to Intacct with a connection string, and what tables you can import into the ElastiCube Manager:

Installing the Intacct Connector

Sisense provides the Intacct connector as a standalone connector that you can download and add to your list of default Sisense connectors.

To install the Intacct connector:

  1. Contact us for the Intacct installation file.
  2. Open the installation file and click Install.
  3. After the installation process is complete, click Close.

The Intacct connector is displayed in the ElastiCube Manager under Add Data > Web Services.

Adding Intacct Tables to Your ElastiCube

After you have installed the Intacct connector, you can import your data from Intacct by connecting with a connection string. The connection string contains your Intacct users credentials. Intacct uses the connection string to authenticate your account and allow you to extract the relevant data for your account.

The connection string to Intacct is in the following format:

jdbc:Intacct:APIKey=xxxxxxxxxxxxxxxxxxxxxx;

For example:

jdbc:intacct:User=’myusername’;CompanyID=’TestCompany’;Password=’mypassword’;SenderID=’Test’;SenderPassword=’abcde123′;

You Intacct connection string should include the following parameters, separated by a semicolon ;.

User: You Intacct username.

CompanyID: Your company’s Intacct ID used when you log in.

Password: Your Intacct user password.

SenderID: The Web Services SenderID assigned to you by Intacct.

To connect to a shared child company, add your LocationID parameter to the connection string. To connect to a distributed child company, add your ClientID parameter to the connection string.

To add Intacct data:

  1. In ElastiCube Manager, click Add Data and then, Intacct. The Connect to Intacct window is displayed.
  2. In Datasource Connection String, enter your connection string.
  3. Click Connect to Server. Intacct is displayed in the Select Database list.
  4. Click OK. Sisense connects to Intacct and displays a list of tables available for you to import.
  5. Select the relevant tables and click Add. The tables are displayed in the ElastiCube Manager.

Intacct Tables

The Sisense Intacct connector allows you to import the following tables into the ElastiCube Manager.

Available Tables

AcctRange
ACHBank
ActivityLog
Aisle
Allocation
APAccountLabel
APAdjustment
APBill
APBillBatch
APPymt
APRecurBill
APTerm
ARAccountLabel
ARAdjustment
ARInvoice
ARInvoiceBatch
ARPaymentBatch
ARTerm
Attendee
Billing_Contact
Bin
BudgetHeader
CheckingAccount
Class
ClassGroup
Comments
Contact
CreditCard
Customer
CustomerEmailTemplate
CustomerGroup
CustomerVisibility
CustType
Department
DepartmentGroup
EEarningType
EAccountLabel
EExpenses
EmailTemplate
Employee
EmployeeEntityContacts
EmployeeGroup
EmployeeOutOfOffice
EmployeePositionSkill
EmployeeRate
EmployeeType
ExchangeRate
ExchangeRateTypes
ExpenseAdjustments
ExpensePaymentType
GAAPAdjJrnl
GLAccount
GLAcctGrp
GLAcctGrpMember
GLBatch
GLBudget
GLCoaCatMember
GLCompGrpMember
ICRow
InvDocument
InvDocumentParams
InvPriceList
Item
ItemGroup
ItemTaxGroup
Journal
Location
LocationGroup
Misc_Supporting_Document
OutOfOffice
PODocument
PODocumentParams
POPriceList
PositionSkill
ProductLine
Project
ProjectGroup
ProjectResources
ProjectStatus
ProjectTransactionRule
ProjectType
RecurGLBatch
RenewalMacro
ReportingPeriod
RevRecTemplate
RevRecTemplMilestone
SavingsAccount
Seminar
Seminar_Package
Seminar_Registration
SODocument
SODocumentParams
SOPriceList
StatAccount
StatJournal
STKitDocument
Task
TaskResources
TaxGroup
TerritoryGroup
Timesheet
TimeType
TransactionRule
TransactionRuleDetail
TrxCurrencies
UoM
UserAdjJrnl
UserInfo
UserRoles
Vendor
VendorGroup
VendorVisibility
VendType
Warehouse

Available Views

AllocationEntry
APAdjustmentItem
APBillItem
APBillPayment
APIUsageDetail
APIUsageSummary
APPayment
APPaymentItem
APPaymentRequest
APRecurBillEntry
ARAdjustmentItem
ARInvoiceItem
ARPayment
ARPaymentItem
ARRecurInvoice
ARRecurInvoiceEntry
BankFee
BankFeeEntry
BillingSchedule
CCTransaction
CCTransactionEntry
ChargePayoff
ChargePayoffEntry
CNSAcctBal
Company
CreditCardFee
CreditCardFeeEntry
DDSJob
Deposit
DepositEntry
EExpensesItem
EExpensesPayment
EPPayment
EPPaymentItem
EPPaymentRequest
ExchangeRateEntry
ExpenseAdjustmentsItem
FundsTransfer
FundsTransferEntry
GLAccountBalance
GLAcctGrpHierarchy
GLDetail
GLEntry
GLResolve
InvDocumentEntry
InvDocumentSubtotals
InvoiceRun
InvPriceListEntry
InvRecurSubtotals
ItemComponent
OtherReceipts
OtherReceiptsEntry
PODocumentEntry
PODocumentSubtotals
POPriceListEntry
PORecurSubtotals
PSADocumentEntry
RecurDocumentEntry
RecurGLEntry
RevRecChangeLog
RevRecSchedule
RevRecScheduleEntry
RevRecScheduleEntryTask
SODocumentEntry
SODocumentSubtotals
SOPriceListEntry
SORecurDocument
SORecurSubtotals
STKitDocumentEntry
TerritoryGrpMember
TimesheetEntry
TransTmplBatch
TransTmplEntry
UoMDetail
UserRights
WfpmPaymentRequest