Forum Discussion
Connecting to Deltek Vision or Cosential?
Responsive ResidentI've been tasked to create dataflows to our on-premises Deltek Vision databases. I can connect directly to the underlying SQL Server tables as I've done with other on-premises databases.
However, was looking to see if you or anyone has other preferred methods like using their API. It appears that there isn't a Certified Connection for it.
I'm interested in what you've done if you have a chance. Thanks!
Helper IIIIf the client is using Deltek Flex First then the only way is to use the Hybrid Data Connection/ODBC. I use the api for coding Webservices and data integrations between systems. Thanks.
- arock-well
Thanks. The client is using on-premises Deltek Vision, version 7.6. Any suggestions for connecting with that setup?
Thanks
Aaron
Within Power BI Desktop, you can just enter the server name and pass through either your Windows credentials (if you have db access rights) or a username/pw. Once published, the destination server should be setup using an On-Premise Gateway. It'll pick it up from your connection in the pbix file and online to schedule it, you'll just need to make sure to "map" it to the destination under the gateway and it'll use the connection string there so you don't need to worry about it using your credentials or db username/pw.
Hi
We priovide Power BI services for Deltek clients and have number of solutions developed for Deltek Vision/Vantagepoint
https://bitechsol.com/financial-analytics-for-deltek-vision/
Thanks
- danielpaduck
If your database is on prem then you could just either use an AD account or SQL account and just write your queries against the database.
With Deltek's initiative to move Vision clients to SaaS and VantagePoint, has anyone been able to connect PowerBI to Vision and VantagePoint SaaS? Thank you.
