Domo Workbench broken Quickbooks 2019 2020 Python ODBC alternative

pydomoguy
pydomoguy
in Workbench

I have created a Gihub repository with a Python workaround to dump QB reports to a CSV via QODBC. I am sharing this freely and would like to collaborate with others to have this option in case Domo Workbench is not working as is currently the case for Quickbooks 2019+:


https://github.com/twg-robert/domo-python-quickbooks-odbc-workbench


NOTE: I just started this project last night due to an immediate need to pull reports from Quickbooks Enterprise 20.0. It is very basic and gritty. My goal is to export 6 canned reports to CSV then import them with Domo Workbench.

“The best way to find yourself is to lose yourself in the service of others.” ― Mahatma Gandhi.

Comments

  • GrantSmith
    GrantSmith Coach

    Very interesting @pydomoguy . Have you thought about utilizing the pydomo package to just straight import them into Domo instead of having to then go through Workbench?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • pydomoguy
    pydomoguy

    FYI I use Domo workbench to upload the CSV due to having to leave code on clients machines. I don't want anyone getting a hold of our API key which would be in the Python code. Hence the marriage between Python extracting the data from Quickbooks and Domo Workbench pushing the CSV to Domo works well. It is a balance between getting all the data I want out of Quickbooks and keeping some measure of security of our Domo instance. Still though you have to authenticate to Domo Workbench using a Domo user and managing this on many clients can be a pain.

    “The best way to find yourself is to lose yourself in the service of others.” ― Mahatma Gandhi.
  • trafalger
    trafalger Contributor

    This is helpful, thank you @pydomoguy!

Categories