Locations for Filebased Connections

image_pdfimage_print

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

HTTP

Files from a remote server using the HTTP protocol.
The URL of a 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

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

SSL Mode

Off: SSL is not used. For Report Designer files, this option must be used if Jedox Web uses HTTP protocol.

Trust: SSL certificate will be imported to the keystore if not yet available. For Report Designer files, this option must be used at least once if Jedox Web uses HTTPS protocol to import the certificate.

Verify: SSL certificate is verified. For Report Designer files, this option should be used if Jedox Web uses HTTPS protocol and the certificate is already imported. 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 HTTP Basic authentication.

Password

The password for HTTP Basic authentication.

 

FTP

Files on a FTP server (File Transfer Protocol).

The URL of a FTP request that has a result in in the corresponding file format (csv, xlsx, json, or xml). Note: FTPS is not supported.
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. For Report Designer files, this option must be used if Jedox Web uses HTTP protocol.

Trust: SSL certificate will be imported to the keystore if not yet available. For Report Designer files, this option must be used at least once if Jedox Web uses HTTPS protocol to import the certificate.

Verify: SSL certificate is verified. For Report Designer files, this option should be used if Jedox Web uses HTTPS protocol and the certificate is already imported. 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

 

 

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.
If “Use SSL” is checked, then the connection uses secure mode.

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

 

OneDrive

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

Client ID

 The Azure Client ID (Application ID).

User Name

The username for the access to OneDrive.

Password

The password for the access to OneDrive.

Prerequisites:
1. Office 365 business account.
2. OneDrive business subscription (Free edition is not supported)
3. An Azure AD application. It is defined either by a user or company administrator. (Client-Id is application Id which is required in the OneDrive location definition). This abstract definition exposes Microsoft services to external clients via authentication. All of the applications can be seen via this link: https://apps.dev.microsoft.com/
Brief explanation on how to create an application: https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-create-service-principal-portal
Note that Jedox Integrator supports only native type Azure AD applications.
4. Permissions: The Microsoft “GraphApi Endpoint Service” is used in order to communicate to user’s OneDrive. In the Permission list, OneDrive related permissions have to be given by using the “Grant Permissions” functionality in Azure. The consenting process has to be done via a company administrator or via a user who possesses the required permission.

WebDAV

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

SSL Mode

Off: SSL is not used. For Report Designer files, this option must be used if Jedox Web uses HTTP protocol.

Trust: SSL certificate will be imported to the keystore if not yet available. For Report Designer files, this option must be used at least once if Jedox Web uses HTTPS protocol to import the certificate.

Verify: SSL certificate is verified. For Report Designer files, this option should be used if Jedox Web uses HTTPS protocol and the certificate is already imported. 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.

 

WebHDFS

Files on the Hadoop Distributed File System (HDFS). HDFS is a core component of Apache Hadoop, a framework for distributed storage and processing of very large data sets.
It uses internally the WebdHDFS REST API which is built-in with the default Hadoop installation of Hortonworks HDFS.

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

URL example: hdfs://12.34.56.78:8020

 Host  Name of the host.
Port Name of the port.
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 you can contact the Jedox support.

Note: by default, HDFS runs in non-secure mode, in which no actual authentication is required. The 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. 

image_pdfimage_print
Was this post helpful?
NoYes (+1 rating, 1 votes)
Loading...