Skip to main content

Connessione ad un database Oracle

In questa procedura viene descritto il metodo più semplice per la connessione a un database Oracle. Se il driver Oracle appropriato non è installato, Alteryx ne richiede l'installazione.

  1. Drag an Input Data tool or Output Data tool onto the canvas and select it.

  2. In the Configuration window, select Set Up a Connection. Then, select Data sources. In the Oracle section, select Quick connect.

  3. Alteryx Designer checks your system for an Oracle driver.

    • If a driver that you can use to connect to Oracle already exists, you see the Oracle Database Connection window. Proceed to the next step.

    • If you don't have a driver installed, you see the Oracle Client Not Found window. Select an installation location and then select Install to download and install the Oracle Instant Client driver. The installation location must have at least 2 GB of free space. For information about this driver, go to Oracle.

  4. In Connection Name, enter a new connection name or select an existing connection. Designer stores new connections in the Manage Data Connections window.

    • Select an existing connection:

      • View and select any System connection or any User connection you've created.

      • Data Source Name (DSN) connections configured in the ODBC driver aren't listed. To configure ODBC and OLEDB connections, go to ODBC and OLEDB database connections.

    • Modifica una connessione esistente:

      • When you select an existing connection, you can modify all connection properties except Type.

      • If you are an admin, you can modify any System connection or any User connection you've created.

      • If you are a non-admin user, you can only modify the User connections you've created.

      • If you modify a connection property (for example, Host), you must re-enter your password.

  5. Select a connection Type:

    • User: Creates a connection that only you can use. User connections are visible only by the user who created them.

    • System: (Selectable only by administrator users) Creates a connection for any user on a machine. System connections are visible to all users.

  6. In Host, enter the Oracle database server host name or IP address.

  7. Enter the Port number for the Oracle database. The default value is 1521.

  8. Enter a Service Name, if desired. The service name defaults to the global database name if you leave this field blank.

  9. Enter your Credentials for the server. See Manual connection setup for more information on authentication requirements.

  10. Select Test to test the connection.

  11. Select OK.

Nota

Se ti connetti a un database Oracle contenente dati codificati Unicode®, seleziona Supporto Force SQL WChar nella finestra Configurazione dello strumento Dati di input . Designer tratta quindi le colonne di caratteri come SQL_WCHAR, SQL_WVCHAR o SQL_WLONGVARCHAR.

Metodi di connessione a Oracle alternativi

DSN con ODBC, OLEDB

Per istruzioni sulle connessioni ODBC e OLEDB, consulta Connessioni ai database ODBC e OLEDB .

Nome del server TNS noto

Se un amministratore ha già configurato un server TNS:

  1. Seleziona Altri database > Oracle OCI .

  2. Fornisci il nome del server TNS e le tue credenziali.

  3. Fai clic su OK .

Caricatore Bulk

Se si verificano problemi di prestazioni quando scrivi in Oracle, utilizza il caricatore bulk:

  1. Nel menu a discesa Configurazione dello strumento Dati di output , seleziona Altri database > Oracle Bulk .

  2. Fornisci il nome del server TNS e le tue credenziali.

  3. Fai clic su OK .

In questa sezione: