Sudhir Amin is a Database Specialist Solutions Architect at Amazon Web Services. As a native of India, Vikas enjoys playing Cricket and spending time with his family and friends outdoors. Vikas Babu Gali is a Sr. Specialist Solutions Architect, focusing on Microsoft Workloads at Amazon Web Services. If you have any comments or questions, leave them in the comments section. After configuring your heterogeneous linked server, you should be able to run distributed queries including SELECT, UPDATE, and other commands to interact with an external Oracle database instance to meet requirements such as reporting. We also showed how to access data from Oracle database using the TSQL statement against the configured linked server. In this post, we explained how to configure a heterogeneous linked server configuration between Amazon RDS for SQL Server and an Oracle database instance. The following code is an example of using the stored procedure sp_addlinkedserver to create a linked server:įROM OPENQUERY (TestLink, 'SELECT count(*) FROM ALL_TABLES') You can use stored procedures and catalog views to manage linked server definitions. After registration, both the remote and local data source can be referred to with a single logical name. When you’re setting up a linked server, you must register the connection information and data source information with SQL Server properly. Linked server configuration depends on network connectivity and DNS resolution between Amazon RDS for SQL Server and Oracle Server. Set up an Amazon RDS for SQL Server to Oracle linked server Rebooting the RDS instance twice changes the status of the option group from Pending reboot to In sync.Īfter successful reboots, you can see the option group status change to In sync. For more information, see Modifying an Amazon RDS DB instance.Īfter you successfully modify the option group, the status of the option group shows as Pending reboot, indicating a reboot of the RDS for SQL Server DB instance is required after enabling the feature.įor a Multi-AZ RDS instance, a reboot needs to happen on both the primary and secondary RDS instances to have the OLEDB_ORACLE option to take effect. Modify the DB instance and associate the option group created in the previous step to the existing RDS for SQL Server instance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |