![]() Right-click Linked Servers, and then click New Linked Server. In SQL Server Management Studio, open Object Explorer, expand Server Objects,.How to create a SQL Server Linked Server to Amazon Redshift To the Amazon Redshift database, you will see the following message: Connection Use the port that the cluster was configured to use when it was launched. By default, Amazon Redshift uses port 5439, but you should In the Amazon Redshift console on the cluster’s details page. The linked tables should appear in the Tables navigation pane on the left.Specify the endpoint for your Amazon Redshift cluster.You are linking multiple tables, you will be prompted to select unique record identifiers for each of the selected tables. To avoid inconsistencies, it is recommended to select the primary key in the Amazon Redshift table as the unique record identifier. ![]() The Select Unique Record Identifier dialog box will prompt you to choose a field or fields that uniquely identify each record in the table.In the Link Tables dialog box, select the table or tables that you want to link to, and click OK.In the Get External Data - ODBC Database dialog box, select Link to the data source by creating a linked table.Linking to Amazon Redshift Data in Microsoft Access Through an ODBC Connection Double-click on the needed table to display its contents. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |