ODBC CSV / REST API Driver
Query CSV and flat files from disk or HTTP endpoints using SQL.
Read local CSV / TSV files or REST API responses in CSV with plain SQL. Handle OAuth, JWT and pagination, read large files fast, and query the data from Power BI, Excel, SSIS, Python or SQL Server, all without writing code.
Included in the Standard edition and above
- Any ODBC-compliant tool
- Runs in your environment
- SQL Server via Data Gateway
- 32-bit and 64-bit

At a glance
What the CSV / REST API Driver can do
Query CSV and flat files from disk or HTTP endpoints using SQL.
Familiar SQL
Use WHERE, ORDER BY, GROUP BY and built-in math, string, date and JSON functions on top of the data source.
- Standard SELECT syntax
- Custom functions in the SQL dialect
- Driver options in a WITH clause
CSV & flat files
Read delimited files from disk or an HTTP endpoint and query them as tables.
- Delimiter, header and encoding options
- Local files and URLs
- Wildcard patterns
REST API downloads
Call an API that returns CSV, with custom headers, body and pagination.
- GET and POST
- Pagination options
- OAuth and Basic authentication
Works with the tools you have
Any ODBC-compliant tool can use the DSN: Power BI, Tableau, Qlik, SSRS, Informatica, Excel and SSIS.
- Create a DSN once, reuse it everywhere
- 32-bit and 64-bit ODBC
- Stored in the standard ODBC Data Source Administrator
Use it from code
Connect from Java, C#, Python, PowerShell and more with an ODBC connection string that names the DSN.
- Standard ODBC connection strings
- Parameterized queries
- Same SQL as in the UI
SQL Server via Data Gateway
Query the driver from SQL Server (linked server / OPENQUERY) without installing it on the SQL Server machine, through the Data Gateway.
- No driver install on the server
- Works with SQL Server 2012 through 2025 (32/64 bit)
- Same DSN, same SQL
See all features
- Read /write CSV data from Web API / REST API or local CSV files 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 functions in SQL query Language
- The unparalleled performance with large file support
- POST data to API server, Upload File to server (Support MultiPart File Upload).
- Latest security standards such as OData, OAuth and JWT (RFC 7519) (Call services like Google API, Facebook …)
- Call API using Dynamic Token Authenticate or Basic authorization (i.e. UserID / Password)
- Reading from multiple files using wildcard pattern (e.g. Year??_data*.json)
- HTTP Request with Custom Headers / Body / URL Parameters.
- REST API Pagination Support to consume multiple requests / loop (many options explained here and here)
- HTTPS / SSL / TLS 1.2 Support for more secure communication
- Support for passing cookies
- Support for Proxy Server
SQL Server 2012–2025
Ways to use it
Pick how you reach your data.
Configure the DSN once, then query it from any ODBC tool or from SQL Server.
Query CSV files with SQL.
Point SRC at a file or wildcard.
- Delimiter and header options
- Wildcard patterns
- Local files and URLs

Read CSV from an API endpoint.
Set the URL, method, headers and body, then query the CSV the endpoint returns.
- GET or POST
- Pagination options
- Authentication

Query it from SQL Server with Data Gateway.
Expose the driver through the ODBC PowerPack Data Gateway and create a linked server in SQL Server. The driver does not have to be installed on the SQL Server machine.
- Linked server or OPENQUERY
- No driver install on the server
- Works with SQL Server 2012 through 2025 (32/64 bit)

Inside the UI
The driver UI, step by step.
Real screens from the ZappySys ODBC driver configuration.
Create the DSN
Add a user or system DSN and pick the CSV / REST API Driver.
SQL example
Write SQL. Get a flat table.
The driver reads local files or Web API responses, flattens the CSV and lets you use WHERE, ORDER BY, GROUP BY and functions on top. Below: a sample document, the SQL query and the rows it returns.
-
Sample CSV data
A small CSV file on disk. Point
SRCat a URL instead and the same query reads a Web API response.CustomerID,CompanyName,City C1,Company 1,Atlanta C2,Company 2,Boston C3,Company 3,Atlanta -
Run the SQL query
SQL Query
SELECT CustomerID, CompanyName FROM $ WHERE City = 'Atlanta' ORDER BY CompanyName WITH ( SRC = @'C:\Data\customers.csv' )Paste the statement into the driver’s Query Editor, or run it from any ODBC tool or language.
WITH (…) clause carries driver options, so a single DSN can read many sources.
-
Rows returned to your tool
CustomerID CompanyName C1 Company 1 C3 Company 3 Connect Power BI, Excel, SSIS, Python or SQL Server to the DSN to get the same rows.
Illustrative input and output. More query samples are in the online help.
SQL query examples
Copy a query, change the source, run it.
19 of the 40 examples from the CSV / REST API Driver help. Open one to see the SQL.
Read files, API responses and objects as rows.
Query CSV API Service
This example shows how to query CSV API service. In order to see table list you must populate required connection parameters on the parameter grid
SELECT * FROM $
WITH(
SRC='https://zappysys.com/downloads/files/test/invoices.csv'
,ColumnDelimiter=','
,HasColumnHeaderRow='True'
--,DateFormatString='yyyy-MM-dd HH:mm:ss'
--,FileCompressionType='GZip' --or-- Zip --or-- None
--,SkipRows='5'
--,SkipHeaderCommentRows='5'
)
Query Single File
This example shows how to query single CSV file (For multiple file use wildcard (i.e. *.csv)). This example selects root level hierarchy (i.e $ as table name). Use table selector from toolbar to exact data from different hierarchy (i.e table).
SELECT * FROM $ WITH (SRC='C:\Data\cust-1.csv')
Query Multiple Files
This example shows how to query multiple CSV files using wildcard (i.e. *.csv). This example selects root level hierarchy (i.e $ as table name). Use table selector from toolbar to exact data from different hierarchy (i.e table).
SELECT * FROM $
WITH (
SRC='C:\Data\cust*-?.csv'
--,RECURSIVE='True' --Include files from sub folder
)
Query direct CSV string (embedded inside query)
This example shows how to query direct CSV string embedded inside query. This is useful for testing purpose. In real world this may not be the case because data may be coming from File or URL (API call).
SELECT * FROM $
WITH
(DATA='Name|Age|Income|Hiredate
Bob|55|5000.00|2018-01-01
Sam|51|2000.00|2016-02-01
John|45|3000.00|2014-07-01
'
,ColumnDelimiter='|'
)
Query Command line Output (Console Capture / MS DOS / PowerShell)
This example shows how to return data from command line output / batch file. To treat Data as command line simply prefix source command line with cmd:>. Here is more information about streaming data from command line output.
SELECT * FROM $
WITH(
Data='cmd:>powershell -executionpolicy bypass -Command "[System.IO.StreamReader]::new((Invoke-WebRequest -URI https://zappysys.com/downloads/files/test/invoices.csv).RawContentStream).ReadToEnd()"'
--Data='cmd:>powershell -executionpolicy bypass -Command "echo col1`,col2`r`n1`,AA`r`n2`,BB|Out-File c:\temp\dump.csv ; more c:\temp\dump.csv"'
,ColumnDelimiter=','
--,ColumnDelimiter='SELECT * FROM $
WITH(
Data='cmd:>powershell -executionpolicy bypass -Command "[System.IO.StreamReader]::new((Invoke-WebRequest -URI https://zappysys.com/downloads/files/test/invoices.csv).RawContentStream).ReadToEnd()"'
--Data='cmd:>powershell -executionpolicy bypass -Command "echo col1`,col2`r`n1`,AA`r`n2`,BB|Out-File c:\temp\dump.csv ; more c:\temp\dump.csv"'
,ColumnDelimiter=','
--,ColumnDelimiter='\0003' --{TAB} char may not work in some cases if cmd:> mode used in Data='...'
,IgnoreBlankLines=1 --//ignore empty lines in Console Output
,HasColumnHeaderRow='True'
--,DateFormatString='yyyy-MM-dd HH:mm:ss'
--,SkipRows='5'
--,SkipHeaderCommentRows='5'
)
03' --{TAB} char may not work in some cases if cmd:> mode used in Data='...'
,IgnoreBlankLines=1 --//ignore empty lines in Console Output
,HasColumnHeaderRow='True'
--,DateFormatString='yyyy-MM-dd HH:mm:ss'
--,SkipRows='5'
--,SkipHeaderCommentRows='5'
)
Escape Sequence (String Literals with new lines, tabs)
This example shows how to use escape sequence in String Literals (Quoted values (single quotes) in WITH, SELECT or some other clause if driver supports). You can use @ symbol before string literal to allow special characters (e.g. \r \n \t \v \u0041 \\).
SELECT * FROM $
WITH
(DATA=@'Name|Age|Income|Hiredate\r\nBob\u0041|55|5000.00|2018-01-01\r\nSam|51|2000.00|2016-02-01\r\nJohn|45|3000.00|2014-07-01\r\n'
,ColumnDelimiter='|'
)
Query with static Metadata (META option / Override Mode)
This example shows how to supply custom Metadata rather than relying dynamic metadata detection (based on 300 rows scanning). If you run query you can click on [View Metadata] button to generate default metadata.
SELECT * FROM $
WITH
(DATA='id,checknumber,name
1,0001,AAA
2,0002,BBB
3,0003,CCC
'
--//Method-1: >>>DIRECT META (compact mode)<<<
,META='id:int;checknumber:string(10);name:string(10)'
-- Add: @OverrideMode:1 in the column list to override meta for only specific column(s) - In below example we are changing default datatype/length for id and checknumber, all other columns are dynamic so dont have to supply in META clause
--,META='@OverrideMode:1;id:int;checknumber:string(10)'
--//Method-2: >>>DIRECT META (csv mode)<<<
--,META='[{Name:"id",Type:"Int32"},{Name:"checknumber",Type:"String",Length:10},{Name:"name",Type:"String",Length:10}]'
-- Add: @OverrideMode entry in the column list to override meta for only specific column(s). No need to set Type for that entry - In below example we are changing default datatype/length for id and checknumber, all other columns are dynamic so dont have to supply in META clause
--,META='[{Name:"@OverrideMode"}, {Name:"id",Type:"Int32"},{Name:"checknumber",Type:"String",Length:10}]'
--//Method-3: >>>META from File <<<
--,META='c:\data\meta.csv'
--//Method-4: >>>META from Internal Storage - Just refer entry by name <<<
--,META='MY_META_STORAGE_NAME'
)
Authentication, pagination, POST requests and parent/child URL calls.
Basic Authentication (User Id/Password)
This example shows how to query CSV API service which requires basic authentication. In order to see table list you must populate required connection parameters on the parameter grid
--Credentials via Query
SELECT * FROM $ WITH (SRC='https://zappysys.com/downloads/files/test/invoices.csv'
,DataConnectionType='HTTP'
,CredentialType='Basic'
,UserName='user1'
,Password='pass123')
--Credentials inside connection string [Use Data source setup grid >> Select Connection = HTTP (Click Configure) >> Set Credential type=Basic, UserId=user1, Password=pass123]
--SELECT * FROM $ WITH (SRC='https://zappysys.com/downloads/files/test/invoices.csv')
NTLM / Windows Authentication
This example shows how to query CSV API service which requires windows authentication (NTLM).
--Credentials via Query
SELECT * FROM $
WITH (SRC='http://yourhost/some-service',DataConnectionType='HTTP',CredentialType='Ntlm')
--Credentials inside connection string [Use Data source setup grid >> Authentication type=Ntlm]
--SELECT * FROM $ WITH (SRC='http://yourhost/some-service')
OAuth 2.0 Authentication (3-Legged) – Custom API Example
This example shows how to query CSV API service which requires OAuth2 authentication.
--Credentials via Query
SELECT * FROM $ WITH (
SRC='http://yourhost/api/some-service'
,DataConnectionType='OAuth'
,UseCustomApp='True'
,OAuthVersion='OAuth2'
,AuthUrl='https://yourhost/api/authorize'
,TokenUrl='https://yourhost/api/token'
,ClientId='xxxxxxxxxxx'
,ClientSecret='xxxxxxxxxxxxx'
,AccessToken='xxxxxxxxxxx'
,RefreshToken='xxxxxxxxxxx' --//This is only obtained from UI by clicking Generate Token Button
)
--Credentials inside connection string [Use Data source setup grid >> Authentication type=OAuth >> Click OAuth Button to configure connection]
SELECT * FROM $ WITH (SRC='http://yourhost/api/some-service')
OAuth 2.0 Authentication (3-Legged) – Google API Example
This example shows how to query Google API using OAuth2 authentication. For demo its using Google Analytics API but you can apply same concept for other OAuth2 compatible Google API.
--Credentials via Query
--Check this link to learn more about how to generate ClientId / ClientSecret >> https://zappysys.com/blog/register-google-oauth-application-get-clientid-clientsecret/
--To get Access Token and Refresh Token >> Goto properties grid >> Change Authentication type=OAuth >> Click OAuth Button to configure connection >> Select Provider='Google' >> Use Custom App >> Select Scope and click Generate Token >> Save tokens to file
SELECT * FROM $ WITH
(
SRC='https://www.googleapis.com/analytics/v3/metadata/ga/columns'
,UseCustomApp='True'
,DataConnectionType='OAuth'
,ServiceProvider='Google'
,ClientId='3855xxxxxx-xxxxxxxxxxxxxxxxx.apps.googleusercontent.com'
,ClientSecret='qF7axxxxxxxxxxxWfs'
,AccessToken='ya29.GlsxxxxxxxxxIam'
,RefreshToken='1/pFOxxxxxxxxxxgU' --//This is only obtained from UI by clicking Generate Token Button
)
--Credentials inside connection string [Use Data source setup grid >> Authentication type=OAuth >> Click OAuth Button to configure connection]
SELECT * FROM $ WITH (SRC='https://www.googleapis.com/analytics/v3/metadata/ga/columns')
Dynamic Token Authentication (2 Steps) – Query REST API
This example shows how to call REST API Service using Dynamic Token approach. Learn how to authenticate using userid / password to obtain temporary token which can be passed to call API. Also learn how to pass Body, Headers using HTTP POST.
SELECT * FROM $
WITH(
Src='https://zappysys.com/downloads/files/test/rest-getdata.aspx?format=csv'
--,RequestMethod='POST'
--,RequestData='sessionid=[$token$]"'
,Header='Content-Type: text/plain || Accept: */* || Cache-Control: no-cache'
,DataConnectionType='HTTP'
,CredentialType='TokenDynamic'
,UserName='MyUser001'
,Password='P@$$w0rdAAc12'
,AuthScheme='{none}'
,TokenUrl='https://zappysys.com/downloads/files/test/rest-login.aspx'
,TokenRequestData='{ user:"[$userid$]", password:"[$password$]" }'
,TokenRequestMethod='POST'
,TokenResponseContentFilter='$.sessionid'
,TokenRequestHeaders='Content-Type:application/json | Accept:*/* | Cache-Control:no-cache'
,TokenResponseContentType='Json'
)
Paginate based on URL Parameter (Loop until certain StatusCode)
This example shows how to paginate API calls where you need to pass page number via URL. Driver keeps incrementing page number and calls next URL until last page detected (401 error). There are few ways to indicate last page (e.g.
SELECT * FROM $
WITH (
SRC='https://zappysys.com/downloads/files/test/page-csv.aspx?page=1&mode=DetectBasedOnResponseStatusCode'
,PagingMode='ByUrlParameter'
,PagingByUrlAttributeName='page'
,PagingByUrlEndStrategy='DetectBasedOnResponseStatusCode'
,PagingByUrlCheckResponseStatusCode=401
,IncrementBy=1
)
Functions, GROUP BY, CASE, UNION, temp tables and more.
Handling Large Dataset / Avoid OutOfMemory Error (Using Disk for Query Engine)
Advanced Query can invokes ClientSide query Engine which means entire table is fetched in memory for processing causing OutOfMemory Exception (OOM). To avoid this error you can specify Disk based Temporary storage for query engine.
SELECT * FROM $
WITH(
Src='https://zappysys.com/downloads/files/test/cust-1.csv?really-large-file=1'
,TempStorageMode='Disk' --or 'Memory'
--OR
--,TempStorageMode=1 --//Memory=0, Disk=1
)
String Manipulation
This example shows how to use string functions. When you use function your entire dataset is first cached locally and then transformation is applied so you may notice some speed degradation.
SELECT
substr('ZappySys', 1, 5)
, printf('%s %s %.2f', 'v1', CompanyName, CompanyId)
, ('Str1' || CompanyName || 'Str2') as ConcatExample
, upper('ZappySys')
, lower('ZappySys')
, replace('ZappySys', 'Sys', 'XYZ')
, instr('ZappySys', 'Sys')
, trim(' Zappy Sys ') trim1
, trim('@@@ZappySys@@@', '@') trim2
, rtrim(' ZappySys ')
, ltrim(' ZappySys ')
, length( CompanyName )
FROM $ WITH (
DATA='CompanyId,CompanyName
1000,ZappySys
1001,Microsoft
1002,Amazon
')
Control flow
This example shows how to use math functions. When you use function your entire dataset is first cached locally and then transformation is applied so you may notice some speed degradation.
SELECT
COALESCE(10,20) coalesce1 --returns first non-null arg
,COALESCE(null,20) coalesce2 --returns first non-null arg
,COALESCE(null,20,30,40) coalesce3 --returns first non-null arg
,IFNULL(null,20) --returns first non-null arg. Same function as COALESCE but simple (just two arguments allowed)
,NULLIF(20,20) nullif1 --returns null if both argument same
,NULLIF(10,20) nullif2 --returns null if both argument same
FROM $ WITH (
DATA='CompanyId,CompanyName
1000,ZappySys
1001,Microsoft
1002,Amazon
')
Date/Time
This example shows how to use date/time functions. When you use function your entire dataset is first cached locally and then transformation is applied so you may notice some speed degradation. CSV driver supports following 5 datetime functions.
SELECT
DATE('now') date_now
,STRFTIME('%Y-%m-%dT%H:%M:%f','now') formatted_Date_time
,DATETIME('now') datetime_now
,DATE('now','localtime') datetime_now_local
,TIME('now') time_now
,JULIANDAY('now')
,DATE('now', 'start of month', '+1 month' , '-1 day' ) dt_modify1
,DATE('now', '+5 day') dt_modify2
FROM $ WITH (
DATA='CompanyId,CompanyName
1000,ZappySys
1001,Microsoft
1002,Amazon
')
Math
This example shows how to use math functions. When you use function your entire dataset is first cached locally and then transformation is applied so you may notice some speed degradation.
SELECT
abs(-500)
,random()
,round(1000.236, 2)
FROM $ WITH (
DATA='CompanyId,CompanyName
1000,ZappySys
1001,Microsoft
1002,Amazon
')
Regular Expression
This example shows how to regular expression functions.
SELECT
regex_ismatch(SSN, '\d{3}-\d{3}-\d{4}') IsValidSSN, --check pattern found
regex_replace(SSN, '\d','*') MaskedSSN, --search/replace pattern
regex_search(SSN, '\d{4}') SSNLast4Digits, --extract substring using pattern search
regex_search(Email, '(?<name>\w+)@(?<domain>\w+.com)',0, 2) DomainOf1stEmailByIndex, --extract 1st email (zero based index) and get domain name (by group name). For 2nd argument you can use numeric index or named argument. Both arguments are zero based index.
regex_search(Email, '(?<name>\w+)@(?<domain>\w+.com)',2, 2) DomainOf3rdEmailByIndex, --extract 3rd email (zero based index) and get 2nd part of match (i.e. domain name). Both arguments are zero based index.
regex_search('a@x.com | b@y.com | c@z.com', '(?<name>\w+)@(?<domain>\w+.com)','-0', 2) DomainOfLastEmail, --extract last email (use negative sign in quote - zero based index) and get 2nd part of match (i.e. domain name). Both arguments are zero based index.
regex_search(
'a@x.com | b@y.com | c@z.com'
, '(?<name>\w+)@(?<domain>\w+.com)'
, '*' --occurrence match index ( * , N or -N ) negative number will do reverse find (e.g. to get last match use -0 , to get second last use -1)
, 2 --group index from match (default is full match or -1)
--, 0 -- ignore case for pattern match (0=strict match, 1=ignore case, default is 0)
--, 0 -- throw error if not matched 0=don't throw error, 1=throw error
--, '#' -- separator for multi match
) GetAllDomains --extract domains from all emails and show as email (zero based index) and get 2nd part of match (i.e. domain name). Both arguments are zero based index.
FROM $ WITH (DATA= 'SSN,Email
111-222-4444,a@x.com | b@y.com | c@z.com
111-X2Z-AB44,a@x.com | b@y.com | c@z.com
')
Run the same query from SQL Server or your own code.
SQL Server (linked server)
Query the driver from SQL Server through the Data Gateway. The driver does not have to be installed on SQL Server.
-- SQL Server: create a linked server to the ZappySys Data Gateway (here [ZAPPY_GATEWAY]),
-- then run the driver query through OPENQUERY.
SELECT *
FROM OPENQUERY([ZAPPY_GATEWAY], 'SELECT * FROM $
WITH (
SRC=''C:\Data\cust*-?.csv''
--,RECURSIVE=''True'' --Include files from sub folder
)')
C# (System.Data.Odbc)
using System;
using System.Data.Odbc;
// Use a DSN ("DSN=MyZappyDsn;") or name the driver directly
using (var conn = new OdbcConnection("DRIVER={ZappySys CSV Driver};"))
{
conn.Open();
var cmd = new OdbcCommand(@"SELECT * FROM $
WITH (
SRC='C:\Data\cust*-?.csv'
--,RECURSIVE='True' --Include files from sub folder
)", conn);
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
for (int i = 0; i < rdr.FieldCount; i++)
Console.Write("{0}={1} ", rdr.GetName(i), rdr[i]);
Console.WriteLine();
}
}
}
Python (pyodbc)
import pyodbc
# Use a DSN ("DSN=MyZappyDsn;") or name the driver directly
conn = pyodbc.connect("DRIVER={ZappySys CSV Driver};")
cursor = conn.cursor()
cursor.execute(r"""
SELECT * FROM $
WITH (
SRC='C:\Data\cust*-?.csv'
--,RECURSIVE='True' --Include files from sub folder
)
""")
for row in cursor.fetchall():
print(row)
conn.close()
PowerShell
$conn = New-Object System.Data.Odbc.OdbcConnection
$conn.ConnectionString = "DRIVER={ZappySys CSV Driver};" # or "DSN=MyZappyDsn"
$conn.Open()
$cmd = $conn.CreateCommand()
$cmd.CommandText = @'
SELECT * FROM $
WITH (
SRC='C:\Data\cust*-?.csv'
--,RECURSIVE='True' --Include files from sub folder
)
'@
$table = New-Object System.Data.DataTable
(New-Object System.Data.Odbc.OdbcDataAdapter($cmd)).Fill($table) | Out-Null
$conn.Close()
$table | Format-Table
Java (JDBC through Data Gateway)
// Java uses the ZappySys Data Gateway and the Microsoft SQL Server JDBC driver.
// On the gateway, add a data source (here "MyZappySource") that uses the ZappySys CSV Driver.
import java.sql.*;
String url = "jdbc:sqlserver://localhost:5000;databaseName=MyZappySource;user=MyGatewayUser;password=MyPassword;encrypt=false";
String sql = "SELECT * FROM $\n"
+ "WITH (\n"
+ " SRC='C:\\Data\\cust*-?.csv'\n"
+ " --,RECURSIVE='True' --Include files from sub folder\n"
+ ")";
try (Connection conn = DriverManager.getConnection(url);
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql)) {
while (rs.next()) {
System.out.println(rs.getString(1));
}
}
PHP (odbc_connect)
<?php
$conn = odbc_connect("DRIVER={ZappySys CSV Driver};", "", ""); // or "DSN=MyZappyDsn"
$sql = <<<'SQL'
SELECT * FROM $
WITH (
SRC='C:\Data\cust*-?.csv'
--,RECURSIVE='True' --Include files from sub folder
)
SQL;
$rs = odbc_exec($conn, $sql);
while ($row = odbc_fetch_array($rs)) {
print_r($row);
}
odbc_close($conn);
Articles
Guides and tutorials for the CSV / REST API Driver
Compatibility and requirements
Built for Windows, and for your own environment.
- Windows 11, 10, 8 and 7, and Windows Server 2022, 2019, 2016, 2012 R2 and 2008
- .NET Framework 4.x. The JDBC Bridge Driver also needs Java 8 or later
- 32-bit and 64-bit ODBC drivers. SQL Server 2012 through 2025 through the Data Gateway
- Self-hosted: drivers run in your Windows process, business data does not pass through ZappySys servers, and credentials stay in your DSN
- Free trial of ODBC PowerPack: test with your own data before you buy
FAQ
Questions about the CSV / REST API Driver
Which tools and languages can use this driver?
Any ODBC-compliant tool, such as Power BI, Tableau, Qlik, SSRS, Informatica, Excel and SSIS. You can also connect from Java, C#, Python, PowerShell and other languages with an ODBC connection string.
Do I need to install the driver on SQL Server?
No. With the Data Gateway option the driver runs on the gateway machine and SQL Server connects to it through a linked server.
Which edition includes the CSV / REST API Driver?
The CSV / REST API Driver is included in the Standard, Professional and Enterprise editions of ODBC PowerPack. See the edition comparison for the full list.
Can I query a CSV file from a URL?
Yes. SRC can be a local path, a wildcard pattern or an HTTP URL.
Can I save a query to reuse it?
Yes. Save a query as a virtual table or a stored procedure (custom objects) in the DSN. Tools then see it like a normal table, and a procedure can take parameters. See custom objects in ODBC drivers.
Is there an SSIS version?
Yes. This driver uses the same data engine as the CSV File Source in SSIS PowerPack.
Which SQL Server and Windows versions are supported?
Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014 and 2012 (32/64 bit) through the Data Gateway. See the system requirements.
Can I try it before buying?
Yes. Download ODBC PowerPack, create a DSN and test your own data before you buy.
Start your free trial today
Install ODBC PowerPack and add a CSV / REST API Driver DSN.
Preview your data in the driver UI before you connect your tool.
- One DSN, many toolsPower BI, Excel, SSIS, Python and SQL Server can all use it.
- Free trialTest the driver with your own data before you buy.
- Live supportHelp during your trial and after purchase.
Open Help FileBrowse all ODBC PowerPack drivers
New purchases may be eligible for refund review within 30 days. See the refund policy.
Talk to an engineer before or during your trial.