Connection to File (CSV)

image_pdfimage_print

Jedox Integrator can import or export structured text files, known as flat files or CSV files (comma-separated-value files).

Main settings

Location

The location of the file with following options:

  • File System
  • URL
  • Report Designer

File name

File System location:

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

URL location*:

Report Designer location:

  • A filename with path in Report Designer.
    Example: //Default/Public Files/sample.csv
    Note: In case of access to a remote Report Manager the following syntax is used:
    <remote_ip>:<port>//<path>
    Example:
    12.34.56.78:80//Default/Public Files/sample.csv

Header (true or false)

If set, the entries of the first line are used as column headers.

Data delimiter

Separators between the columns in the text file, e.g. “,”.

  • Tab as data delimiter: \t
  • For blank value (” “) as data delimiter: #space

Enclosure character

The enclosure character of the columns. Possible enclosure characters are “, ‘ or none.

Advanced settings

Encoding

The most prevalent character encodings are “UTF-8” (default), “ASCII”, and “latin1” (Windows standard).

A list of all character codes can be found at http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html
From this list you can also enter manually a character code into the field ‘Encoding’. Note that this connection only supports file encodings as provided by the Java Runtime Environment.

Use escape character

If set, the character “\” invokes an alternative interpretation of the subsequent character. 
Example: “1\”Hello\”2” is interpreted as 1”Hello”2

SSL Mode

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

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

Verify: The 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”.

*If the location is URL, there are 2 additional fields for HTTP Basic Authentication:

Username

The username for HTTP Basic authentication

Password

The password for HTTP Basic authentication

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