ACCESS YOUR INFUSIONSOFT DATA FOR REPORTING

Our data warehouse for Infusionsoft® gives you MySQL access to your Infusionsoft Data.  Your data is securely stored in the Amazon cloud using RDS. We provide you a secure connection to your data that allows you to create custom reports using Crystal Reports, Tableau, direct SQL queries, and other popular reporting platforms.

SUPPORT

Support is offered via email and our support page for all packages, and via phone for the enterprise package.  Phone support is also available for the first 30 days with the Premium package.

SCHEMA

As any Infusionsoft API developer will tell you, the Infusionsoft schema is a little different…  You can view Infusionsoft’s Table documentation here: https://developer.infusionsoft.com/docs/table-schema/ and download a mysql dump of the data warehouse schema here.

Not at this time.  However, you can synchronize an on-site database, with the Cloud database we provide using MySQL Workbench.

With Infusionsoft Apps with less then 50k contact records, data is updated every 15 minutes.  Sometimes, if you update thousands of contacts at once, the update can lag behind a little bit, but usually you can count on 30 minutes or better.  For apps with more then 50k contacts, we still trigger an update every 15 minutes, but depending upon the number of changes the sync can take longer.  But generally, no longer then an hour.

No, The Data-warehouse will consume as few as 30 API tokens per data update, and then approx 2 additional token per thousand updated records. It takes about a minute to sync 1000 records (depending upon the table), so you can count on 2 to 4 tokens per minute. Infusionsoft grants an application 2 tokens per second, so you should be fine.

No, one of Infusionsoft’s original clients contacted us to get their Infusionsoft App of over 1.5 million contacts synced.  While getting their data warehouse synced we worked with Infusionsoft’s systems team to get our queries as efficient as possible.  Granted, our sync does consume resources, so it is entirely possible some actions may be slower while we are syncing, however, we’ve never had anyone notice or complain about it.

No, we sync everything possible via the API.  This includes most tables, however, it does not include Campaigns.  While there is a table called “Campaigns” these are for legacy “Follow-Up Sequences” not Campaigns as they are today.

Yup, we sync all of those automatically.  If you add or remove one, we take care of it on the next sync without any extra effort from you.

Copyright © 2016 Novak Solutions LLC. “Automation Center” is a trademark of Novak Solutions LLC.