6/16/2023 0 Comments Excel power query tutorial oracle![]() ![]() 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
0 Comments
Leave a Reply. |