We are proud to share our inclusion in the 2024 Gartner Magic Quadrant for Data Integration Tools. We believe this recognition reflects the differentiated business outcomes CData delivers to our customers.
Get the Report →
How to connect to Sage Intacct Data from IntelliJ
Integrate connectivity to Sage Intacct data with wizards in IntelliJ.
The CData JDBC Driver for Sage Intacct enables you to access Sage Intacct as a JDBC data source, providing integration with rapid development tools in IDEs. This article shows how to use the data source configuration wizard to connect to Sage Intacct data in IntelliJ.
About Sage Intacct Data Integration
CData provides the easiest way to access and integrate live data from Sage Intact. Customers use CData connectivity to:
- Access Sage Intacct without worrying about API updates or changes.
- Access custom objects and fields in HubSpot with no extra configuration steps involved.
- Write data back to Sage Intacct using embedded Web Services credentials with Basic authentication.
- Use SQL stored procedures to perform functional operations like approving or declining vendors, inserting engagements, and creating or deleting custom objects or fields.
Users frequently integrate Sage Intact with analytics tools such as Tableau, Power BI, and Excel, and leverage our tools to replicate Workday data to databases or data warehouses.
To learn about how other customers are using CData's Sage Intacct solutions, check out our blog: Drivers in Focus: Accounting Connectivity.
Getting Started
Create a JBDC Data Source for Sage Intacct
Follow the steps below to add the driver JAR and define connection properties required to connect to Sage Intacct data.
- In the Data Sources window, right-click and then click Add Data Source -> DB Data Source.
In the Data Source Properties dialog that appears, the following properties are required:
- JDBC Driver Files: Click the button next to this menu to add the JDBC Driver file cdata.jdbc.sageintacct.jar, located in the installation directory.
- JDBC Driver Class: In this menu, select cdata.jdbc.sageintacct.SageIntacctDriver from the list.
Database URL: Enter the connection URL in the JDBC URL property. The URL must start with jdbc:sageintacct: and includes connection properties separated with semicolons.
To connect using the Login method, the following connection properties are required: User, Password, CompanyId, SenderId and SenderPassword.
User, Password, and CompanyId are the credentials for the account you wish to connect to.
SenderId and SenderPassword are the Web Services credentials assigned to you by Sage Intacct.
Built-in Connection String Designer
For assistance in constructing the JDBC URL, use the connection string designer built into the Sage Intacct JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.
java -jar cdata.jdbc.sageintacct.jarFill in the connection properties and copy the connection string to the clipboard.
A typical JDBC URL is the following:
jdbc:sageintacct:User=myusername;CompanyId=TestCompany;Password=mypassword;SenderId=Test;SenderPassword=abcde123;
Edit and Save Sage Intacct Data
To discover schema information, right-click the data source you just created and click Refresh Tables. To query a table, right-click it and then click Open Tables Editor. You can also modify records in the Table Editor.
Ready to get started?
Download a free trial of the Intacct Driver to get started:
Download NowLearn more:
Intacct JDBC Driver
Complete read-write access to Intacct enables developers to search (Contacts, Invoices, Transactions, Vendors, etc.), update items, edit customers, and more, from any Java/J2EE application.
