Settings for different sources of import data - 7.1

EXASolution

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Database components > EXASolution components
Data Quality and Preparation > Third-party systems > Database components > EXASolution components
Design and Development > Third-party systems > Database components > EXASolution components
EnrichPlatform
Talend Studio

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 EXASolution 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 EXASolution 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 EXASolution 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 EXASolution 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 EXASolution 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 EXASolution 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 EXASolution 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 EXASolution 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 EXASolution 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.