Forum Discussion
Quickbooks Online Authentication Error
I set up Stitch to connect in to QBO and it's working really well so far. I ended up with the same set of tables. I haven't started moving the PQ queries to point to the new source yet though. Doesn't look like it will be that difficult though.
I set Stitch up to replicate the QBO database every 30 minutes into our Amazon RDS Postgres database. I have no idea what all was involved on the Postgres side - our engineering team handled that. Since we already had an integration with another source set up it only took them a few minutes to get me up and running. Not sure how hard it would have been otherwise. Stitch seems to have things pretty well automated though.
One thing I ran into was fixing a weird certificate issue with AWS. Wasn't too bad to fix once I found this article: https://saurabha.com/connecting-power-bi-to-aws-rds-postgresql/
Good luck! Can't believe there's still not ETA for a fix! $100/mo to Stitch will end up being money well spent though.
Were you able to connect your Customer table to Journal Entries, Deposits, Purchases etc once you moved the data into Power BI?
I found that the connection between Customer and those other Tables worked with the Power BI connector, but have not found it yet using Stitch. I messaged their support team, but am awaiting a reply. Any thoughts?