How to Setup Multiple On-Prem Databases to Then Bring Data into Onelake
Hi there, I have just enabled the Fabric trial for my organisation and I am attempting to bring our clients data into Onelake to report off. I am very new to all this, hence looking for some guidance. This client has three sites (NZ,AU,US) and we support their on-prem ERP software. This software uses a Firebird database, therefore I am using the ODBC connector on each server. My questions are: 1. Do I need to RDP into each server, open Fabric through a browser and bring in the tables I need to Onelake via ODBC & connect the on-prem Gateway for LIVE refresh? 2. Once i've done this, can I then access all the data from my local PC within Powerbi desktop to create their reports? 3. Why does the OBDC connector bring in the data initally, then the on-prem application allow it to refresh live? What is the difference between these applications? I made this diagram just to get my head around it, can anyone tell me is this correct? If anyone has extra advice around this, it would be so greatly appreciated! Thank you!
