Live Data Connector to SAGE accounting

tye.gardner35371

I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has anyone ever linked an accounting systems to Smartsheet? I am assuming it is possible, but I want to gather other's experiences if they have.

Thanks!

Andrée Starå

Hi Tye,

If I'm not misstaken, @JeremiahHorstick has done this previously.

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Hi Tye,

If I'm not misstaken, @JeremiahHorstick has done this previously.

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Happy to help!

Here are a few other possible solutions as well.

Let me know how it goes and if I can help in any way!

http://layer2solutions.azurewebsites.net/solutions/general-data-integration/smartsheet-integration

https://tray.io/connectors/sage-intacct-smartsheet-integrations

https://www.workato.com/integrations/sagelive+smartsheet

JeremiahHorstick

Thanks @Andrée Starå

@tye.gardner35371

One of the simplest and most reliable ways to do it is using one of CDATA's drivers. With that you can basically connect anything to anything with whatever tooling your prefer.

I'm a big fan of CDATA because they have robust & resilient connectors.

We've connected to QuickBooks Desktop 4 different ways and connect to QuickBooks Online using the API.

It depends on your specific use case.

NikkiOno

@JeremiahHorstick Can you clarify more on how this works and wich CDATA driver you used? I am very confused.

JeremiahHorstick

@NikkiOno CData provides standards-based, reliable data services. It is a technically-implemented approach to extending Sage functionality with Smartsheet. Similarly, the CData Smartsheet driver can read/write records. The Smartsheet API and Data Connector are the other technical services I recommend, while Bridge & Data Mesh may accomplish your aim without a technical lift from your team.

https://www.cdata.com/drivers/sage300/

What are you building / implementing?

NikkiOno

@JeremiahHorstick I was trying to connect employee hours in QuickBooks time to smartsheets

JeremiahHorstick

@NikkiOno The hour values are accessible, however QB doesn't provide an easy way to access complete payroll data without a 3rd party payroll integration or QuickBooks Time.