Settings for different sources of import data

File name

 Specify the path to the local file to be imported.

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.

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.

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.

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.