Is it possible to connect IBM Cognos to SQL Server and use SSMS query data?
Yes and yes.
Can you point me in the right direction then, Joseph? Do I use an IP address to connect? It is Cognos where the data is on a cloud server.
Can you install a provider for Cognos on the SQL Server and create a linked server?
SSMS won't connect to Cognos directly. It is the Enterprise Manger for SQL Server now. Cognos can connect to SQL Server though.
Yes, I can install a provider for Cognos on the SQL Server and create a linked Server. So I take it like a native driver such as OLEDB?
That would work