September 15, 2017 at 8:11 am
Hi,
We are currently doing a proof of concept with AWS Redshift. We have the cluster running and have created a database via the console.We then downloaded the RedShift ODBC and JDBC drivers and we managed to get a linked server to the cluster and ran a query via OPENQUERY in SSMS.
It appears that it is not possible to use SSMS to connect to the cluster directly and instead have to use 3rd party tools such as JetBrains' DataGrab tool, which we were successfully able to connect to the cluster and query the database with.
So my question is this, is SSMS useless in talking to RedShift or is there a method of connecting it up to the cluster.
Thanks,
Nic
September 15, 2017 at 9:35 am
Redshift is a data warehouse that Amazon built, based on ParAccel technology. The platform and communications aren't standarized. The code you can run is SQL, which is fairly generic in some sense, but the protocols for connecting to the server and issuing code are different. SSMS is built to connect to SQL Server, from Microsoft. It won't connect to Oracle, Redshift, DB2, MySQL, etc. Just SQL Server, Azure SQL Data Warehouse, Azure SQL Database, SQL Server Analysis Services, and that's about it.
September 18, 2017 at 7:43 am
Thanks for the reply Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply