Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do we know that the database is eligible for the configuration of Heterogeneous Connectivity?

April 26, 2017configuration connectivity database eligible Heterogeneous

0

Posted

How do we know that the database is eligible for the configuration of Heterogeneous Connectivity?

1 Answer

0

Posted

The data dictionary tables, views, and packages may already be installed on your Oracle9i server. Check for the existence of Heterogeneous Services data dictionary views, for example, SYS.HS_FDS_CLASS. Log into the Oracle Database as SYSTEM or SYS or as the ID that is eligible to access the data dictionary and then issue the following statement. Select * from SYS.HS_FDS_CLASS; This returns no rows if no HS configuration are done. How to configure the Heterogeneous connectivity?? Step 01 Creation of .udl file (udl stands for universal data link) On Windows Platforms a. Decide a directory where you shall have the .udl file on the Oracle Server where the Oracle Database is living. b. Right click on the right plane and select new and the new text document and create a file c. Rename the file with the extension .udl (ex: MYSQL.udl) d. Go to the SQL Server and create a global user with administrative rights to log into any database that is living on that server e. Test the connectivity and g