Settings for different sources of import data
The settings for this component change depending on the source of your import data.
The component handles data coming from any of the following sources:
-
Local file
-
Remote file
-
EXASol database
-
Oracle database
-
JDBC-compliant database
Local file
The local file is not transferred by uploading the file. Instead, the driver establishes a (secure) web service that sends the URL to the database, and the database retrieves the file from this local web service. Because the port of this service cannot be explicitly defined, this method requires a transparent network between the local Talend Job and the Exasol database.
|
File name |
Specify the path to the local file to be imported. |
Remote file
This method works with a file that is accessible on a server through the following protocols: SCP, SFTP, FTP, HTTP, or HTTPS.
|
Use predefined connection |
It is possible, via the SQL interface, to set up a named connection in the Exasol database itself. Select this option if you want to use such a connection, and provide its name. To know what connections are available, look at the table SYS.EXA_DBA_CONNECTIONS in the database. The connection must contain a URL with one of the following protocols: SCP, SFTP, FTP, HTTP, or HTTPS. The URL must not contain the file name. The file name is always dynamic and must be provided by the component configuration. |
|
Remote file server URL |
Specify the URL to the file server, without the file name itself. |
|
File name |
Specify the name of the file you want to fetch from the server. |
|
Query parameters |
If the web service depends on query parameters, specify them here. For example, if you want to get a file from an HDFS file system via the web service, you need to add some additional parameters such as open=true. |
|
Use user authentication |
Select this check box if you want to use Basic Authentication when connecting to the web server. |
|
Remote user and Remote users password |
Enter the user name and password need to access the web server. |
Exasol database
An Exasol database can also serve as a remote source for the data. The source can be a table or a specific query.
|
Use predefined connection |
It is possible, via the SQL interface, to set up a named connection in the Exasol database itself. Select this option if you want to use such a connection, and provide its name. To know what connections are available, look at the table SYS.EXA_DBA_CONNECTIONS in the database. The username and password must by provided by the component and not as part of the predefined connection. |
|
Exasol database host |
Specify the host of the remote Exasol database. This field can also be used to access a cluster. |
|
Use self defined query |
Select this check box if you want to use a specific query to get the data. This method is preferred if, for example, your data needs to be filtered (using a where condition), joined or converted. |
|
Source query |
If you want to use a specific query, enter the query in this field. |
|
Database or schema |
If you are not using a specific query, enter the schema name for the source table in this field. |
|
Source table |
If you are not using a specific query, enter the table name in this field. The mapping between the source table columns and the target table columns (schema columns) can be set in the advanced settings. |
|
Use user authentication |
Select this check box if you want to use Basic Authentication when connecting to the source database. |
|
Remote user and Remote users password |
Enter the user name and password needed to access the source database. |
Oracle database
An Oracle database can also serve as remote source for the data. Access to an Oracle database requires an Enterprise license for the Exasol database and does not work with the free edition. The source can be a table or a specific query.
|
Use predefined connection |
It is possible, via the SQL interface, to set up a named connection in the Exasol database itself. Select this option if you want to use such a connection, and provide its name. To know what connections are available, look at the table SYS.EXA_DBA_CONNECTIONS in the database. The username and password must by provided by the component and not as part of the predefined connection. |
|
Oracle database URL |
Specify the JDBC URL to the Oracle database. |
|
Use self defined query |
Select this check box if you want to use a specific query to get the data. This method is preferred if, for example, your data needs to be filtered (using a where condition), joined or converted. |
|
Source query |
If you want to use a specific query, enter the query in this field. |
|
Database or schema |
If you are not using a specific query, enter the schema name for the source table in this field. |
|
Source table |
If you are not using a specific query, enter the table name in this field. The mapping between the source table columns and the target table columns (schema columns) can be set in the advanced settings. |
|
Use user authentication |
Select this check box if you want to use Basic Authentication when connecting to the source database. |
|
Remote user and Remote users password |
Enter the user name and password needed to access the source database. |
JDBC-compliant database
The free edition of the Exasol database supports MySQL and PostgreSQL databases, and others are available in the Enterprise edition. The source can be table or a self defined query.
Nearly all enterprise-grade databases provide a JDBC interface.
|
Use predefined connection |
It is possible, via the SQL interface, to set up a named connection in the Exasol database itself. Select this option if you want to use such a connection, and provide its name. To know what connections are available, look at the table SYS.EXA_DBA_CONNECTIONS in the database. The username and password must by provided by the component and not as part of the predefined connection. |
|
JDBC database URL |
Specify the JDBC URL to the source database. |
|
Use self defined query |
Select this check box if you want to use a specific query to get the data. This method is preferred if, for example, your data needs to be filtered (using a where condition), joined or converted. |
|
Source query |
If you want to use a specific query, enter the query in this field. |
|
Database or schema |
If you are not using a specific query, enter the schema name for the source table in this field. |
|
Source table |
If you are not using a specific query, enter the table name in this field. The mapping between the source table columns and the target table columns (schema columns) can be set in the advanced settings. |
|
Use user authentication |
Select this check box if you want to use Basic Authentication when connecting to the source database. |
|
Remote user and Remote users password |
Enter the user name and password needed to access the source database. |