An out-of-the-box connector is available for the NFS Server/instance. It provides support for crawling file objects, folders, and profiling sample data.
Connector Capabilities
The drivers used by the connector are given below:
Driver / API |
Version |
Details |
Java rt.jar(1.8) |
1.8 |
Comes with JDK version |
Technical Specifications
The connector capabilities are shown below:
Crawling
Feature |
Supported Objects |
Remarks |
Crawling |
Files/Folders |
While crawling FileFolders will be cataloged by default. |
Profiling
Please see Profiling Data for more details on profiling.
Feature |
Details |
Remarks |
File Profiling |
Row count, Columns count, View sample data |
|
Sample Profiling |
Supported |
By default, the service account provided for the connector will be used for any user operations. If the service account has to write privileges, then Insert / Update / Delete operations can be executed.
Pre-requisites:
To use the connector, the following need to be available:
- Connection details as specified in the following section should be available.
- An admin/service account for crawling and profiling.
- To upload a file (s), the user should have the ‘WRITE’ permission on the NFS folder path (main or its sub-level folder).
- The minimum privileges required are:
Operation |
Access Permission |
Connection validate |
Read/Write(To upload these files user should have Write permission.) |
Catalog files/folders |
Read |
Profile files/folders |
Read |
Connection Details
The following connection settings should be added for connecting to an NFS database:
Property |
Details |
Database Type |
NFS |
Connection Name |
Select a Connection name for the NFS connector. The name you specify is a reference name to identify your SQL Server database connection in OvalEdge easily. Example: NFS Server Connection |
NFS URL |
Valid path to start crawling files and folders. E.g.,/Users/xyz/Downloads |
Validation occurs when the URL is correctly given. Once connectivity is established, additional configurations for crawling and profiling can be specified:
Crawler settings:
Property |
Details |
Crawler Configuration |
|
Crawler Options |
FileFolders by default enabled |
Profiler Settings |
|
Profile Options |
No Existence for Profile |
Profile Rules |
No Profile Rules Exist |
Note: Supported File Types: CSV, XLS, XLSX, JSON, AVRO, PARQUET, ORC, TXT and GZ