In this mode the SID and Port settings are not used, and you need to specify the
#Excel power query tutorial oracle software#
Have Oracle Client software installed on your PC. To use the OCI connection mode for connection to an Oracle database, you should Then you need to specify connection string parameters for the corresponding protocol in the Advanced parameters.
To enable use of SSH or SSL, you need to add the corresponding prefix to the Host parameter - ssh:// for the SSH protocol and tcps:// for SSL.
Port - the number of a port to communicate with listener on the server.SID - the unique name for an Oracle database instance.It also can accept a TNS descriptor or specify a secure protocol to use and optionally, a port after a colon. Host - the DNS name or IP address of the Oracle server to which to connect.The following parameters are used for connecting Excel to Oracle database the Direct connection mode The requiredĬonnection parameters are different for different connection modes. The OCI connection mode requires Oracle Client installed. The DirectĬonnection mode allows connecting Oracle to Excel without any additional Two connection modes can be used in Excel Add-in for Oracle connections. Parameters in the Connection Editor dialog box. To connect Excel to Oracle database, you need to enter the necessary connection