Forum Discussion

black_magic1001's avatar
black_magic1001
Icon for Helper I rankHelper I
6 years ago

Cdata Quickbooks Remote Connection

I have a client who has power bi installed on his local desktop.  He is trying to get data from quickbooks desktop (direct query or import, doesn't matter) that is hosted on a separate server using a...
Need Help
black_magic1001's avatar
black_magic1001
Icon for Helper I rankHelper I
6 years ago

That ODBC is configured on the machine that hosts power bi correct?  And then that ODBC looks at that URL and send the USER/PASS to make a connection to the QuickBooks Remote Connection Server, which then makes the connection to quickbooks?  Does that sound right.

 

Is the IP of the server I need in IPCONFIG as the ipv4?

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

black_magic1001 - Yes, the IP v4 address should work fine. Open a command prompt (cmd) on the server. Type ipconfig and hit the Enter key. There you can see the ip address of the server.