Drivers Datapath

Datapath Capture
Datapath Vision Drivers

Datapath Capture

FTP / SFTP ODBC Driver for CSV files can be used to read delimited files (e.g. CSV / TSV ) stored on FTP site (Classic FTP, SFTP, FTPS sites). Using this driver you can easily integrate FTP / SFTP data inside SQL Server (T-SQL) or your BI / ETL / Reporting Tools / Programming Languages. Write familiar SQL queries to read data without any coding effort. This driver supports latest security standards, and optimized for large data files. It also supports reading compressed files (e.g. GZip /Zip).

This driver is using same high performance data processing engine which was originally developed for CSV Connector in SSIS PowerPack. ODBC PowerPack and SSIS PowerPack, both products share many UI elements and concepts. We wrote many articles to explain various features in one product but concepts are mostly same in both products so hope you can reuse steps explained in different articles even though screenshots /steps may be slightly different.

Feature Summary

Read delimited files (e.g. CSV, TSV) from FTP / SFTP using familiar SQL Query language
Integrate insight any ODBC Compliant Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, SSRS, Informatica, Excel, SSIS)
Support for programming languages such as JAVA, C#, Python, PowerShell and more…
Tight integration with Microsoft SQL Server (With support for Gateway Option – No need to install Driver on Server)
Familiar SQL Query language support including WHERE, ORDER BY, GROUP BY constructs
Support for custom math/ string / datetime / JSON functions in SQL query Language
Read single or multiple files (wildcard pattern supported e.g. *.csv)
Support for reading Zip and Gzip compressed files (stream mode)
Support missing columns at the end (Auto fill with null values)
Option to pivot data (transform columns into rows)
Allow Comments in the CSV file
Advanced error handling such as throw error for empty file, throw error when column count mismatch
Advanced parser options such as Trim fields, Trim headers, Skip rows
Options to ignore blank lines and blank rows (no data for each column)

FTP / SFTP Driver for JSON Files

FTP / SFTP Driver for XML Files

Amazon S3 Driver for CSV Files

Azure Blob Driver for CSV Filess

XML File / SOAP API Driver

CSV File / REST API Driver

Data Gateway

Featured Articles

WDI general datapath interfaces.; 2 minutes to read; a; D; d; In this article 802.11 frame handling and frame metadata. 802.11 frames are passed between WDI and the TAL in the form of NETBUFFERLIST (NBL) chains. Each NBL represents one MSDU. DATAPATH X4 DRIVER. DataPath's more than 25 years of experience in integrated communications and information technology makes us a market leader in trusted communications systems, services and end-to-end solutions for mission critical operations. Shop Controller Express in stock and ready to ship right now!

FTP / SFTP CSV ODBC Driver UI

Configure FTP / SFTP Connection – FTP / SFTP ODBC Driver for CSV files

Integration Scenarios (Reporting / ETL / BI / Programming)

ZappySys ODBC Drivers built using ODBC standard which is widely adopted by industry for a long time. Which mean the majority of BI Tools / Database Engines / ETL Tools already there will support native / 3rd party ODBC Drivers. Below is the small list of most popular tools / programming languages our Drivers support. If your tool / programming language doesn’t appear in the below list, which means we have not documented use case but as long as your tool supports ODBC Standard, our drivers should work fine.

ZappySys ODBC Drivers – Integrate with Excel, Power BI, Tableau, QlikView, QlikSense, Informatica PowerCenter, SQL Server, SSIS, SSAS, SSRS, Visual Studio / WinForm / WCF, Python, C#, VB.net, PHP. PowerShell

BI / Reporting Tools Integration	ETL Tools Integration	Programming Languages Integration
Oracle OBIEE Many more (not in this list)…..	Informatica PowerCenter (Windows) Informatica Cloud SSIS (SQL Integration Services) Oracle OBIEE Many more (not in this list)…..	Visual Studio C++ PHP

ODBC Integration Screenshots in various tools

SQL Query Examples – FTP / SFTP ODBC Driver for CSV Files

ZappySys introduced most innovative way to transform your Cloud Storage files (e.g. CSV / JSON / XML) into Flat table using familiar SQL Query Language. Here are some examples of SQL Queries to read data from Amazon S3, Azure Blob or Secure FTP Storage (SFTP / FTP /FTPS) drivers.

ZappySys Data Gateway (ODBC Bridge for SQL Server / JAVA / Linux / Mac)

ZappySys has developed a unique bridge called ZappySys Data Gateway Service (ZSDG) which can help to access our Drivers in SQL Server or JAVA based Apps or Non-Windows OS (e.g. Mac, Linux). ZappySys Data Gateway service can run in the cloud (VM Exposed to internet) or you can install locally on-premises.

Client application can connect to Data Gateway Service using any Microsoft SQL Server compatible driver (i.e. SQL Server ODBC, OLEDB, ADO.net or JDBC Driver or Linked Server in SQL Server). Data Gateway can be installed on the central server where you can have many users who can connect to Data Gateway to use ZappySys Drivers without installing anything on their machine. Data Gateway Service understands TDS Protocol and Client App can be running on any machine or operating system (MacOS, Linux, Windows).

ZappySys Data Gateway – Connect to JSON, XML, OData, REST API, SOAP data sources using TDS protocol compatible drivers (or any SQL Server ODBC, JDBC, OLEDB, ADO.net driver )

Microsoft SQL Server Integration using Data Gateway Service (T-SQL)

Here is one possible use case of using Data Gateway Service. Any DBA or Non-Programmer can start writing T-SQL queries to use ZappySys Drivers (e.g. REST API, JSON, XML, CSV data source) right inside your usual T-SQL code (You can access data from Salesforce, REST API, JSON, XML, CSV inside Views, Functions or SQL Stored Procedures).

This approach can eliminate any possible ETL work needed to extract data outside of SQL Server, you can start using your existing SQL Skill to achieve previously hard to achieve scenarios without coding.

For many other possible use case of Data Gateway click here.

SQL Server Integration Example – Query REST API / JSON Files / XML Files inside SQL Server using ZappySys Data Gateway Service (Use of Linked Server / OPENQUERY Feature in T-SQL Code / SSMS)

Datapath Vision Drivers

Video Tutorial – Calling ZappySys Drivers inside SQL Server (JSON / REST Driver use case)

Here is a short video to demonstrate a use case of Data Gateway. With this approach you can import data from REST API or any other data source for which ZappySys offers Drivers (e.g. Amazon S3, Azure, SFTP, Salesforce, XML , CSV)

Programming Language Examples

Most programming languages come with out of the box support for ODBC. Which means you can use ZappySys ODBC drivers inside your favorite language. Here are few languages which already support ODBC. We have used JSON Driver / SQL query as an example but concept is same for other drivers too. Refer to help file to learn more about Driver specific Connection String and SQL Query.

PRODUCT OVERVIEW
The ImageDP4 combines a single, powerful graphics processor with improved memory and PCI Express bandwidths to provide responsive performance at up to double the resolution of previous Datapath graphics cards.
Advanced display technology allows up to 16 ImageDP4 graphics cards to be supported by the Datapath display driver, providing a high resolution Windows® desktop comprising up to 64 screens. This ability to present standard Windows® applications alongside full frame-rate video on a single high resolution desktop allows the visualisation of large amounts of data at once to aid effective decision making. To complete the integration into a single desktop, all the outputs of the ImageDP4 graphics card are automatically frame-locked across all cards within a system.
This four channel DisplayPort graphics card is optimised for use with the Datapath Vision range of capture cards for systems requiring video overlays from a wide range of sources and resolutions. Video windows can be positioned and sized anywhere on the multi-screen desktop, while maintaining full frame rate, true colour rendering throughout.
Combining the Vision video capture cards with an ImageDP4 graphics display allows the construction of high-end display wall systems.
The ImageDP4 card natively supports four full-sized DisplayPort outputs for the convenience of high resolution, locking cable connectors and significantly longer cable lengths. Air flow management is optimised through the use of passive cooling, providing high reliability for any multi screen solution.