How can I connect ssms (local/ on-prem) with palantir foundry?

Ask the Community
,
1

I am new to Palantir Foundry and am currently learning about it through YouTube. I want to use Palantir for my practice project.

Project details: I am working on a data project consisting of about 40 tables in an OLTP system. Now, I want to start working on the OLAP layer. I plan to use Palantir’s Pipeline Builder for transformations, the Ontology feature for data modeling, and the Workshop for reporting. However, I am having difficulty connecting Palantir to SQL Server Management Studio (SSMS).

I have already attempted to connect through a direct connection, but it’s not working, and I suspect I might be doing something incorrectly.

Any tips or help would be greatly appreciated.

2

Hey @Krishna6 , for connecting to on-prem you can use a source with the Foundry Worker runtime and an Agent Proxy egress policy. Here is some documentation on setting up a source with private network access.

Here’s some additional information on setting up your agent.

3

Thank you, @jett. I overlooked that we should use an agent for connecting to on-premises or private connections. I will give it a try now.