Locations for File-based Connections

image_pdfimage_print

The following locations can be designated for file-based connections, such as Access, Excel, CSV, JSON, QVX, TDE, and XML:

JedoxFiles

File on the Jedox File Manager (Report Designer).

With “Browse” you can select a file in Report Designer; with “Open File Location” you can change directly in Report Designer.
Option “Use SSL” has to be checked if Jedox Web uses HTTPS protocol.

Note that you can only connect to the Report Designer that is on the same instance as the current Jedox Integrator.

See SSL Configuration for a Standalone Installation for more information.

Top

FileSystem

Files on the file system of the server:

  • File name with an absolute path on the file system of the server.
    Example: C:\Users\xyz\Sample.xlsx
  • File name with relative path to the “data” directory of the Jedox Integrator installation (default: .\tomcat\webapps\etlserver\data\files).
    Example: BikerProducts.csv
  • File residing on a network drive (see instructions in article Accessing network files).
    Example: //net1/Sample.json

Note: in general, the FileSystem location has the best performance, especially for frequent access to small files.

See also Restricting Access to FileSystem Directories.

Top

FTP

Files on an FTP server (File Transfer Protocol). The supported protocol is FTPS (FTP with SSL/TSL) in explicit mode.

Note:  SFTP (SSH File Transfer Protocol) is not supported. FTPS with implicit mode of invoking security is not supported

File name is the URL of an FTP request that has a result in in the corresponding file format (csv, xlsx, json, or xml). Format: ftp://[<user>[:<password>]@]<host>[:<port>]/<url-path>

Examples:
ftp://ftp.heise.de/pub/INDEX
ftp://user001:secretpassword@private.ftp-servers.example.com/mydirectory/myfile.txt

SSL Mode

Off: SSL is not used.
Trust: SSL certificate will be imported to the keystore if not yet available.
Verify: SSL certificate is verified.  Note: if the certificate has not been imported correctly, the following error message occurs: “Unable to find valid certification path to requested target”.

User Name

The username for the  FTP request.

Password

The password for the  FTP request.

Active Mode

 

Top

HTTP

Files from a remote server using the HTTP protocol.

Filename is the URL of an HTTP request that has a result in the corresponding file format (csv, xlsx, json, or xml).
Example: http://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.xml

For this connection, only Basic Authentication is allowed. Other types of authentication, e.g Windows Authentication aren’t supported.

User Name

The username for HTTP basic authentication.
Password The password for HTTP basic authentication.

If an HTTPS request is used, then the SSL certificate will be automatically imported into the keystore.

SSL Mode

Off: SSL is not used.
Trust: SSL certificate will be imported to the keystore if not yet available.
Verify: SSL certificate is verified. Note: if the certificate has not been imported correctly, the following error message occurs: “Unable to find valid certification path to requested target”.

Top

OneDrive

Files on the file-hosting service OneDrive, operated by Microsoft. OneDrive for Business is an integral part of Office 365 or SharePoint Server and provides a place in the cloud where you can store, share, and sync your work files.

Client ID

The application ID in Azure Active Directory (also called App-ID or Client-ID)

User Name

The username for access to OneDrive.

Password

The password for access to OneDrive.

Prerequisites:
1. Office 365 business account.
2. OneDrive business subscription (Free edition is not supported)

Note:
To connect to One Drive from Jedox, you have to create an application (app) in Azure Active Directory (Azure AD). This can be done from one of these Microsoft links: https://portal.azure.com or https://apps.dev.microsoft.com. The application type must be client-native. For the access of One Drive, the required delegated permissions for the API “Microsoft Graph” have to be assigned to this app. In the registered app, the permissions have to be granted to each account, either by the individual user for their own account or by an administrator of the application for all users. For more information see https://docs.microsoft.com/en-us/azure/active-directory/active-directory-integrating-applications.

Top

WebDAV

Files on a server that provides WebDAV (Web Distributed Authoring and Versioning) support.

SSL Mode

Off: SSL is not used.
Trust: SSL certificate will be imported to the keystore if not yet available.
Verify: SSL certificate is verified. Note: if the certificate has not been imported correctly, the following error message occurs: “Unable to find valid certification path to requested target”.

User Name

The username to access the WebDAV file server.

Password

The password to access the WebDAV file server.

Top

WebHDFS

Hadoop Distributed File System (HDFS) is a core component of Apache Hadoop, a framework for distributed storage and processing of very large data sets. Internally, it uses the WebdHDFS REST API, which is built into the default Hadoop installation of Hortonworks HDFS.

File name is the address of the namenode server of the HDFS. It starts with the protocol prefix “hdfs://” followed by the hostname and the port.

File name example: hdfs://12.34.56.78:8020

If you receive an error message like “Error in HDFS location: sandbox-hdp.hortonworks.com” while running an extract, you can either define in Hadoop:

Mapping the Internal Nodes to External URLs

or you can add “IP address sandbox-hdp.hortonworks.com” to the file hosts.

Path of the file hosts on Windows: %systemroot%\system32\drivers\etc\hosts
Path of the file hosts on Linux: /etc/hosts

Example of possible entry in file hosts:

13.93.26.183 sandbox-hdp.hortonworks.com

Supported Distributions

The location supports the Hadoop distribution of Hortonworks Data Platform (HDP) in version HDP 2.5.
http://hortonworks.com/hdp/. If you are interested in other distributions or other versions, please contact Jedox Support.

Note: by default, HDFS runs in non-secure mode, in which no actual authentication is required. Secure mode, in which each user and service has to be authenticated by Kerberos, is currently not supported in the Hadoop package for Jedox Integrator. 

Top

image_pdfimage_print