Use this statement to create a connection.
- You need to have the system privilege CREATE CONNECTION.
- If the OR REPLACE option has been specified and the connection already exists, the rights for DROP CONNECTION are also needed.
- You can use external connections within the IMPORT and EXPORT statements. Users must have the corresponding access rights to the connection (through GRANT). The connection, including the ADMIN OPTION, is automatically granted to the creator.
- Connections can control the read access for users who want to use scripts for processing data from local buckets stored in BucketFS. For more information, refer to the BucketFS section.
- You can define an Exasol connection, a native connection to an Oracle database, a JDBC connection to any database, or a connection to a file server. Some JDBC drivers are already delivered as default and are visible in EXAoperation. The JDBC drivers can be addressed within the connection string (for example, jdbc:mysql, jdbc:postgres). You can additionally configure Manage JDBC Drivers in EXAoperation and choose them by the DRIVER option of the IMPORT/EXPORT command if the prefix is ambiguous.
- The declaration of username and password is optional and can be specified within the IMPORT and EXPORT statements.
- Invalid connection data will not be noticed before the usage within the IMPORT and EXPORT statements.
- For a list of all database connections, refer to the system table EXA_DBA_CONNECTIONS.
- Rename a connection by using the RENAME command.
Only the pre-installed JDBC drivers, marked gray in EXAoperation, are tested and officially supported. However, our support team will try to help you in case of problems with other drivers.
CREATE CONNECTION ftp_connection TO 'ftp://192.168.1.1/' USER 'agent_007' IDENTIFIED BY 'secret'; CREATE CONNECTION exa_connection TO '192.168.6.11..14:8563'; CREATE CONNECTION ora_connection TO '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.54)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))'; CREATE CONNECTION jdbc_connection_1 TO 'jdbc:mysql://192.168.6.1/my_db'; CREATE CONNECTION jdbc_connection_2 TO 'jdbc:postgresql://192.168.6.2:5432/my_db?stringtype=unspecified';