File Location
You can configure a file location such as FTP, Shared Network Folder, Local Folder, HTTP location, HDFS, or Amazon S3 as a connection in the report server.
Then Data Administrators administrators can use this connection to pull data files (Text, Microsoft Excel, CSV, etc.) from these locations , as if , they are were pulling tables’ data from an RDBMS connection.
This model enables access control security and enables abstraction of abstracts the file source to users other than the other users beyond System Administrator.
This page describes the provider-specific properties and the details you need to input to create connections to folders that contains containing the required data files. There are some Some common properties that are common, you can find those information, herelisted in the common properties section.
Common Properties
Connection Name |
You and end users will identify this connection by this name. | |
Provider | FILES/ STREAM |
: Fixed value for connecting to File systems | |
Driver Type | NETWORKPATH, FTP, HTTP, HDFS, S3, MAPR-M5, KAFKA, SAX, GOOGLE SHEET |
Details are given below
NETWORK PATH
Property |
Values
Description |
Location |
Network path starting with , E:, or
..
= a network location address follows E: = You are configuring a local drive (local to report server machine) absolute path as location .. = You are configuring a local drive path relative to |
the report engine in a location. |
Username |
Type Yourself
OS Username |
Password |
OS password |
FTP
Property |
Description |
Comments
Server |
Internet address of FTP Server |
Port |
The port at which the FTP server is listening | |
Secure |
Yes=SFTP (Secured FTP) No = Normal FTP | |
Passive |
Yes = PASV mode Required when there is a firewall between the report server and the FTP server | |
Location |
Type Yourself
Folder path from home or root (whichever is applicable) under which required data files are available |
Username |
FTP Username | |
Password |
FTP password |
HTTP
Property |
Values
Description |
URI |
Website address | |
Location |
Application + path suffixing the web address | |
Secure |
Yes = HTTPS No |
HDFS
Property |
Values
Description |
Server |
Type Yourself
The IP address of HDFS named node |
Port |
Named node Port | |
Location |
Type Yourself
(Optional)
The default path for the connection on this HDFS Blank = location is root |
Group |
Type Yourself
A user group on HDFS |
User name
Type Yourself
Username | Username on HDFS |
S3
Property |
Description |
Comments
Access Key |
Key Value obtained from Amazon | |
Secret Key |
Key Value obtained from Amazon | |
Bucket |
Type Yourself
Bucket Name where data files will be available |
GOOGLE SHEET
Intellicus Kyvos Reporting has added Google Sheet Sheets as a data source to access data under your Google spreadsheetSpreadsheet. You need to follow the below steps to get the Service Account (client email), Private Key, Client IdID, and Client Secret required for creating a connection in IntellicusKyvos Reporting.
Go to https://console.developers.google.com/ and login log in with your Google account’s account credentials.
Create a new Project.
Go to Dashboard > Enable API to enable Drive API and Sheets API.
Click Credentials to create a Service account key.
Next, create an OAuth client IdID. Click On the Configure Consent screen to give , enter your product name and save it.
Choose Other as Application Type the application type and give it a name to it.
You can now download the credentials that are required to create a connection in Intellicus Kyvos Reporting, as shown in the table below.
Property |
Values
Description |
Service Account |
Key used to enable server-to-server authentication | |
Private Key |
Type Yourself
Key Value obtained from Google |
Client ID |
Client ID Value obtained from Google | |
Client Secret |
Type Yourself
Secret Key Value obtained from Google |
Username |
Username of the Google account | |
Password |
Password of the Google account |