Forum Discussion
Impactful Individualcrossroads in fabric
Hi db042190,
Thank you Thomaslleblanc GilbertQ tayloramy, fro your insights.
In Microsoft Fabric, integrating with OneStream depends on how accessible the data is. If APIs are available, REST can be used. Otherwise, exporting the data and importing it through a pipeline is a good option. For your on-premises data warehouse, you can connect using the existing gateway.
Connector overview - Microsoft Fabric | Microsoft Learn
How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn
REST connector overview - Microsoft Fabric | Microsoft Learn
Thank you.
Super UserYou can use the Copy data activity to connection and query a RESTAPI without being a programmer or use a notebook to code it all. I am sure you can get examples from OneStream.
You can also ask for dmps to SFTP and then pick those files up with fabric dataflows or Copy data/job Activities
db042190thx Thomaslleblanc. I do see a onestream connector in pbi desktop which i'll try to use after getting the environment url and an auth acct 9credentials). I will be surprised if its free. we'll see.
According to this post https://learn.microsoft.com/en-us/power-query/connectors/onestream , we'd use (probably be limited to) Dataflow Gen2.
I'd have to go back to my notes to see what that is (maybe data factory in saas?) vs spark notebook.
I sent our peer a request for the url and some auth creds of some kind. I may need to submit an "erp login request" to our service desk. Maybe only after the url is shared.
what about connecting to our dw from fabric? all i know right now is that our gateway is well aware of the server and probably db its on.
BTW, what are dmps to sftps? "dumps" to ftp that originate on onestream?