Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Use the Connect to Oracle dialog box to connect to the Oracle database that you want to migrate.
To access this dialog box, on the File menu, select Connect to Oracle. If you previously connected, the command is Reconnect to Oracle.
Select the data access provider for your connection to the Oracle database. Available providers are the Oracle Client Provider and the OLE DB Provider. The default is Oracle Client Provider.
Select either Standard, TNSNAME, or Connection String mode.
In Standard mode, you enter or select values for the provider, server name, server port, Oracle SID, user name, and password.
In TNSNAME mode, you enter the connect identifier (TNS alias) of the Oracle database, user name, and password. This is the alias of the database as defined in the local tnsnames.ora
file.
In Connection String mode, you provide a connection string.
Important
We don't recommend that you use Connection String mode because the text might include passwords, and it's sent as clear text.
The default is Standard mode.
Enter the Oracle server name. The default server name is the same as the computer name. This is a Standard mode option.
If you use a port number other than 1521 (default) for connections to Oracle, enter the port number. This is a Standard mode option.
Enter the Oracle connect identifier. This is the alias of the database as defined in the local tnsnames.ora
file.
This is a TNSNAME mode option.
Enter the SID for the database. The SID is an identifier that distinguishes the Oracle database on a computer. The default SID for a database is the first eight characters of the database name.
This is a Standard mode option.
Enter the user name that SSMA will use to connect to the Oracle database.
Enter the password for the user name.
If you use the Connection String mode, enter the full connection string for the connection to Oracle.
Connection strings consist of parameter name and value pairs.
For OLE DB connection string information, see Microsoft OLE DB Provider for Oracle Overview.
For SSMA connection strings, always include the Provider parameter. Also, make sure that you include the Port parameter when you connect to Oracle.
Important
We don't recommend that you use Connection String mode because the text might include passwords, and it's sent as clear text.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today