Connecting to Deltek Vision or Cosential?

[guymessickaia]

Hi, does anyone have experience with connecting Power BI to Deltek Vision ERP system and/or Cosential DRM system? thanks

[njanney]

Would this be applicable to Deltek Vantagepoint? Has anyone connected it to power bi?

[aadilnaeem]

Yes we can connect Vantagepoint with PowerBI as well.

https://bitechsol.com/financial-analytics-for-deltek-vision/

Thanks

[danielpaduck]

Yes, it is possible to connect Power BI to an ODBC connection if your database is hosted in the Deltek Cloud.  I have made it work with both Deltek Vision and Vantagepoint. 

[Stahseenhussain]

Please help us as well. I have created the connection with Power Bi Desktop but when I publish the report connection gate way not exist on the web.

[danielpaduck]

Hi,

You would just need to set up a data gateway on their production server so that you can query the database.    I would use standard SQL login and not Windows Auth to query the database.  

Dan

[danielpaduck]

Hi, I have a lot of experience connecting Power BI to Deltek Vision/Vantagepoint. What are you looking to do?

[Anonymous]

Any experience connecting Deltek CostPoint to Power BI?

[danielpaduck]

Hi - sorry,  I do not. However, I would imagine it being similar - ODBC connector. 

[donschult]

Apologies for hijacking this post - I've setup an on-prem gateway to connect our Hybrid Data ODBC connection that we have into Deltek Vantagepoint but I'm not getting the setting correct.  I've tried all sorts of combinations but to no avail.
The connectiomn in Power BI itself via ODBC is working perfectly but I now need to schedule a data refresh on the reports using an on-prem gateway.  Is this possible?

[danielpaduck]

Yes, sorry for the delay.  Shoot me an email at danielpaduck@gmail.com

[danielpaduck]

Hi - I was able to figure it out. I was trying to set up data connections with Deltek Flex. 

[arock-well]

@danielpaduck 

I'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!

[danielpaduck]

If 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]

@danielpaduck 

Thanks. The client is using on-premises Deltek Vision, version 7.6. Any suggestions for connecting with that setup?

Thanks

Aaron

[danielpaduck]

You could just connect directly to through SQL Server then. 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. 

[moekita135]

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.

[aadilnaeem]

Hi

Yes we can do this, we provide this service as well

Power BI Consulting Services – bitechsol

Financial Analytics For Deltek Vision Power BI – bitechsol

Thanks

[danielpaduck]

Hi, 

I have been able to connect to both Vision/Vantagepoint in Deltek Cloud.  Deltek allows you to do this with the Data Direct ODBC connection.  The client needs to be on Flex or higher tier.  Let me know if you have any other questions.  Cheers! 

[agarcia0]

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.