1. Using the Microsoft SQL Server Adapter with Oracle Integration 3
  2. Create a Microsoft SQL Server Adapter Connection
  3. Prerequisites for Creating a Connection

Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the Microsoft SQL Server Adapter:

  • Ensure that you have write permissions on the database.

  • Ensure that you have the required permissions to run stored procedures and packages and SQL statements against the Microsoft SQL Server.

  • Know the database hostname or IP address and the port number.

  • Know the database or instance name.

  • Know the username and password for connecting to the database.