tap-intacct

Tap for Intacct. This tap does not interact with the Intacct API, it relies on Intaccts Data Delivery Service to publish CSV data to S3 which this tap will consume.

Quick start

Install

We recommend using a virtualenv:

> virtualenv -p python3 venv
> source venv/bin/activate
> pip install tap-intacct

Create the config file

The Intacct Tap requires a start_date, a bucket, and an Intacct company ID to function.

start_date - an initial date for the Tap to extract data bucket - The name of an S3 bucket where the Intacct DDS is outputing data company_id - The Company ID used to login to the Intacct UI path (optional) - An optional path configured in the Intacct UI for use in the S3 bucket

Configure your S3 Bucket

This tap uses the boto3 library for accessing S3. The credentials used by boto will also need access to the S3 bucket configured in the above config.

Run the Tap in Discovery Mode

tap-intacct -c config.json --discover

---

Copyright © 2018 Stitch

---

Run the Tap with Meltano

All of the required changes to run the Tap with Meltano are in the most recent commit of the run with meltano branch.

To add the Tap to a Meltano pipeline, add this block of code to the "extractors" section of you meltano.yml file with the required values:

- name: tap-intacct
    namespace: tap_intacct
    pip_url: git+https://github.com/FreshConsulting/tap-intacct.git@run-with-meltano
    executable: tap-intacct
    config:
      start_date: <desired start date> # ex: '2025-01-01T00:00:00Z'
      bucket: <S3 Bucket to Target>
      company_id: <AWS Company ID>
      role_name: <Name of the Role to Impersonate>
      account_id: <AWS Account ID>
      external_id: <AWS External ID>

Functionality Limitations

The version of the Tap in the run with meltano branch does not have the capability to select or exclude specific streams from the source.

Meltano Details

Follow this tutorial for instructions on how to install and run Meltano