Home
Videos uploaded by user “ZappySys”
SSIS REST Api Web Service Task (Consume RESTful Service using HTTP GET, POST)
 
03:50
In this video you will learn how to call REST API Web Service in SSIS. For more info: http://zappysys.com/Products/SSIS-Powerpack/ssis-rest-api-web-service-task/ Features ◾Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST ) ◾Support for windows or basic authentication ◾Save response to variable or file ◾Filter JSON response using JSONPath to extract specific value inside response text ◾Filter XML response using XPath to extract specific value inside response text ◾Validate response using custom rules such as Response Code must be less than 300, Response Content must contain XYZ string, Response Header must contain certain key/value pair … etc ◾Support for Testing UI ◾Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} {{User::MyDate,yyy-MM-dd}} {{User::MyAmount,C}} ) ◾Use of BASE64 format specifiers (e.g. {{User::Creds,BASE64ENC}} will replace value with Base64 Encoded string and {{User::Creds,BASE64DEC}} will decode Base64 string. This is very useful for sending Authorization Headers which is usually base64 encoded ◾Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)
Views: 15415 ZappySys
SSIS JSON Export Task - Generate JSON file from SQL Server, MySQL or Oracle Tables
 
06:07
Generate JSON file from relational Database such as SQL Server, MySQL, Oracle in few clicks. For more info: http://zappysys.com/products/ssis-powerpack/ssis-export-json-file-task/ ◾Export multiple tables/views to JSON files (e.g. Sales% or do SalesJan|SalesFeb) ◾Export SQL query output to JSON file ◾Inbuilt Layout Editor for creating complex JSON with nested structure (Document Array, Value Array, Nested attributes ◾Automatically Split exported JSON data into multiple files by Size or Number of records ◾Automatically Split exported JSON data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country) ◾Support for Compression and Append ◾Create Multi content JSON documents ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
Views: 5129 ZappySys
SSIS Tutorial - Get data from XML / SOAP Web Service in SSIS (Import into SQL Server)
 
15:37
For more information about SOAP/XML in SSIS visit https://zappysys.com/blog/calling-soap-web-service-in-ssis-xml-source/ This video covers information regarding calling SOAP web service in SSIS and load data into SQL Server. You will learn following topics. - What is SOAP Web Service - What is WSDL - Using SoapUI Tool to test SOAP / REST API (Free Download) - How to create SSIS Package to call / load SOAP Web Service data into SQL Server ================================ About SSIS XML Source ================================ Read more: https://zappysys.com/products/ssis-powerpack/ssis-xml-source/ SSIS XML Source can be used to consume multiple XML files or XML formatted response from SOAP Web service or REST API Web Service. It supports advanced filtering along with flexible approach to configure request parameters for web service. Features: Read XML data from any SOAP/REST API Web Service using methods such as GET/POST. Read XML data from single or multiple XML files (use of wildcard allowed. e.g. c:\data\*.xml) Unparalleled performance with large file support (See how we processed 3 million rows in 3 mins) Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node). Support for passing custom headers to SOAP or REST Web service Support for looping through multiple files using wildcard pattern (e.g. *.xml). REST API Paging support to loop through multiple requests (see) Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit) ================================ About SSIS PowerPack ================================ SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to boost your productivity using easy to use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more. SSIS PowerPack also includes high quality FREE commercial components and tasks with full support/upgrade…. Download 30 days FREE Trial from below link https://zappysys.com/products/ssis-powerpack/download ================================ Why SSIS PowerPack? ================================ Coding free, drag and drop high performance suite of Custom SSIS Components and SSIS Tasks Used by many companies around the globe Compatible with SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016 and now 2017 *New* Support for 32bit and 64bit Server/Desktop OS Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT No license needed if you are developing/testing in BIDS/SSDT Rapid update cycle and prompt support (See what's new). We will help you over phone, web meetings and via email. 30 days money back guarantee if not satisfied for whatever reason. For more info: https://zappysys.com/products/ssis-powerpack/
Views: 2301 ZappySys
SSIS Web API Destination - POST data to URL and parse response (REST, SOAP, JSON, XML)
 
19:00
Learn how to POST data to API in few clicks. Integrate REST API in your SQL Server environment using SSIS drag and drop components. For more information visit http://zappysys.com/products/ssis-powerpack/ssis-web-api-destination-connector/ SSIS Web API Destination can be used to POST data to any API end point such as JSON API (i.e. POST to REST API) or POST to XML API (i.e. SOAP Web Service). This task provides several advanced options which makes it possible to connect virtually any API Service. Features • POST data to any API endpoint without coding (Read more…) • Support for windows / basic authentication, client certificate and OAuth (Read more…) • Support for File upload, REST API POST using Multipart/form-data (Read more…) • Support for Cookies (Read more…) • Support for Response Output (includes ResponseText and StatusCode) • Support for Error Output (Redirect failed request) • Support for easy Test UI (see request/response) • Support for Bulk Mode (Group multiple requests into single body) • Support for advanced options (e.g. Gzip compression, timeout, Set SSL/TLS protocols. TLS 1.2 supported) • Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} ) • Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
Views: 2924 ZappySys
SSIS Google Analytics Source - Read data from Google Analytics Platform and load into SQL Server
 
05:08
Learn how to read data from Google Analytics without Coding or learning Complex REST API provided by google. Click here to learn more http://zappysys.com/products/ssis-powerpack/ssis-google-analytics-source-connector/ ===================== Description ===================== SSIS Google Analytics Source connector can be used to read data from Google Analytics Service without learning complex API. Easy to use interface allows you extract large amount of data adjusting parameters such as dimensions, metrics, filters, sortby, date range etc. You can also use inbuilt reports or specify direct query URL to get desired data. ===================== Features ===================== ◾Intuitive user interface makes google analytics data integration super easy and fast without learning complex APIs or scripting language ◾Support for OAuth 2.0 Authentication and Google service account (*.p12 certificate file) ◾Support for Proxy Server ◾Easy to use interface with three different ways to query google analytics data (1) Build query from UI (2) Use built in query templates (3) Use direct query ◾Support for dynamic dimensions, metrics, segments, filters and sortby fields (e.g. supply these values at runtime) ◾Live preview support at design time ◾Support for AdWords, AdSense, Ad Exchange and DoubleClick for Publisher (DFP)
Views: 3809 ZappySys
SSIS JSON File Source - Read JSON file or Web Service URL (REST, ODATA)
 
03:59
Learn how to Read JSON Data in SSIS from RESTful Web Service or JSON Files. For more info: http://zappysys.com/products/ssis-powerpack/ssis-json-file-source/ Features ◾Bulk extract/output JSON data from File ◾Bulk extract/output JSON data from Web Service Url (with OData REST API Support) ◾Support for reading JSON string or file/url path from SSIS Variable ◾Support for JSONPath expression ◾Support for looping through multiple files using wild card pattern (e.g. *.json). ◾Support for HTTP Request with Custom Headers (Useful when JSON is coming from REST API services where you supply credentials or API Key). ◾Support for very large JSON files ◾Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)
Views: 12462 ZappySys
SSIS Excel Source - Read XLSX file (Import to SQL Server) without 64bit driver
 
04:16
SSIS Excel File Source Connector can be used to Read from Excel files (xls / xlsx format) and import to SQL Server / other target such as Oracle, Flat File without installing any Microsoft Office Driver (64bit). Extract Sheet by name (Table mode) or write SQL query to extract / filter data. To read more click here https://zappysys.com/products/ssis-powerpack/ssis-excel-file-source/ ====================== Features ====================== Support for reading Excel Workbook using Table mode or SQL Query mode Support for Office 2007 Excel files (*.XLSX) means you can read more than 64000 rows Support for 64-bit mode without any additional driver unlike native SSIS Excel Connector Support for outputting data in raw or formatted mode Support for flexible metadata detection mode so you can get accurate datatypes Support for Password protected workbooks Support for SQL Server 2005, 2008, 2012, 2014, 2016, 2017 (32 bit / 64 bit)
Views: 1558 ZappySys
SSIS Amazon Redshift Data Transfer Task - Load Data into Redshift from SQL Server, MySQL, Flat Files
 
07:07
Load huge volume of data from any data source (e.g. SQL Server, MySQL, FlatFile) to Amazon Redshift in few clicks. Read more here http://zappysys.com/products/ssis-powerpack/ssis-amazon-redshift-data-transfer-task/ Features: ◾Extremely fast way to load on-premises data to Amazon Redshift in few clicks ◾Load millions of records in few minutes to Amazon Redshift from any database system (e.g. SQL Server, Oracle, MySQL, DB2) ◾Load data to Amazon Redshift from Flat Files ◾Support for Client side and Server Side Encryption ◾Automatic file archiving support ◾Automatic file compression support to reduce bandwidth and cost ◾Rich error handling and logging support to troubleshoot Redshift Data warehouse loading issues ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
Views: 5317 ZappySys
ZappySys SSIS PowerPack Intro  - ETL Tool for connected world
 
02:47
ZappySys SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to boost your productivity using easy to use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more. Why SSIS PowerPack? ================================== Coding free, drag and drop high performance suite of Custom SSIS Components and SSIS Tasks Used by many companies around the globe Compatible with SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016 and now 2017 *New* Support for 32bit and 64bit Server/Desktop OS Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT No license needed if you are developing/testing in BIDS/SSDT Rapid update cycle and prompt support (See what's new). We will help you over phone, web meetings and via email. 30 days money back guarantee if not satisfied for whatever reason. SSIS Custom Tasks and Connectors ============================== SSIS JSON Parser Task SSIS XML Parser Task SSIS Compression Task (Zip/Unzip) SSIS Send HTML Email Task SSIS Regex Parser Task SSIS Logging Task SSIS Download File Task SSIS Timer Task SSIS DummyData Source SSIS Trash Destination SSIS Set Variable Transform SSIS Secure FTP Task (FTP,FTPS,SFTP) SSIS Export XML File Task SSIS Advanced File System Task SSIS Validation Task SSIS Amazon Redshift Cluster Management Task SSIS REST API Web Service Task SSIS Export Excel File Task SSIS Export JSON File Task SSIS Export CSV File task SSIS Amazon S3 Cloud Storage Task SSIS Azure Blob Storage Task SSIS Amazon Redshift Data Transfer Task SSIS Amazon Redshift ExecuteSQL Task SSIS Amazon DynamoDB ExecuteSQL Task SSIS MongoDB ExecuteSQL Task SSIS Reporting Services (SSRS) Task SSIS Google Analytics Source SSIS HTML Table Source SSIS JSON Source (REST API Source) SSIS XML Source (File / SOAP / REST Web Service) SSIS MongoDB Source SSIS Azure Table Storage Source SSIS Amazon DynamoDB Source SSIS MongoDB Destination SSIS Azure Table Storage Destination SSIS Amazon AWS DynamoDB Destination SSIS JSON Parser Transform SSIS XML Parser Transform SSIS XML Generator Transform SSIS JSON Generator Transform SSIS Secure FTP JSON File Source (New) SSIS Salesforce API Task (Call REST/SOAP API) SSIS Salesforce Source SSIS Salesforce Destination SSIS Dynamics CRM Source SSIS Dynamics CRM Destination SSIS Web API Destination SSIS Amazon Redshift Source SSIS Amazon SQS Source SSIS Amazon SQS Destination SSIS Azure Queue Storage Source SSIS Azure Queue Storage Destination SSIS JSON File Destination SSIS XML File Destination SSIS CSV File Source (With API Support) (New) SSIS CSV Parser Transform (New) SSIS Excel File Source (New) SSIS Excel File Destination (New) SSIS Amazon S3 CSV File Source (New) SSIS Amazon S3 CSV File Destination (New) SSIS Amazon S3 XML File Source (New) SSIS Amazon S3 JSON File Source (New) SSIS Azure Blob CSV File Source (New) SSIS Azure Blob CSV File Destination (New) SSIS Azure Blob XML File Source (New) SSIS Azure Blob JSON File Source (New) SSIS Secure FTP CSV File Source (New) SSIS Secure FTP CSV File Destination (New) SSIS Secure FTP XML File Source (New) SSIS Secure FTP JSON File Source (New) OAuth Connection Providers ============================== Custom API Provider Google API Provider Facebook API Provider Twitter API Provider LinkedIn API Provider Dropbox API Provider Yahoo API Provider Amazon API Provider Amazon Marketplace Web Service (MWS) API Provider Amazon AWS (Amazon Web Services) API Provider eBay – Sandbox API Provider eBay – Production API Provider Tumblr API Provider MicrosoftLive API Provider Assembla API Provider CodeProject API Provider Foursquare API Provider GitHub API Provider Instagram API Provider MailRu API Provider SoundCloud API Provider SourceForge API Provider Vkontakte API Provider Yandex API Provider MailChimp API Provider HubSpot API Provider Xero (Private App) API Provider Amazon AWS API v4 (Amazon Web Services) API Provider (Call AWS EC2, S3, Glacier, Lambda, SQS, API Gateway and many more API)
Views: 143840 ZappySys
SSIS Amazon S3 Storage Task - Upload, Download, Delete and Manage S3 Files/Buckets (AWS Cloud)
 
03:31
Learn how to interact with Amazon S3 Storage Files or Buckets in SSIS with just few clicks. For more info: http://zappysys.com/products/ssis-powerpack/ssis-amazon-s3-task/ ◾30+ Amazon S3 operations for S3 buckets and files (e.g. Download, Upload, Copy, Delete…) ◾Download small or very large S3 Files (i.e. AWS S3 file) to local machine ◾Upload small or very large local file(s) to AWS S3 service ◾Support for Delete, Rename, List, Get Property, Copy, Move, Create, Set Permission … and many more operations ◾Support both Encryption types (Client Side and Server Side). For client side AES 256 and RSA 1024 Algorithms supported ◾Support for Get List operation so you can use SSIS ForEachLoop to loop through files ◾Download, Upload, Copy, Delete are multi threaded (i.e. fast parallel operations) ◾Support for virtual folder structure (e.g. myroot/folder1/subfolder/myfile.txt ◾Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)
Views: 4296 ZappySys
SSIS Secure FTP Task (SFTP, FTPS / SSL) - Upload, Download, Delete FTP files in few clicks
 
07:39
SSIS SFTP Task can perform many operations using SFTP, FTP/SSL (i.e. FTPS) or Classic FTP Protocol. It supports many advanced options and various authentication mechanism (e.g. NTLM, Kerberos, Client Certificate, Private Key). Features ============= * Support for multiple FTP protocols such as SFTP, FTP, FTPS (i.e. FTP/SSL) * Support for Public/Private Key for SSH File Transfer * Support for explicit/implicit FTP connection using SSL/TLS encryption * Perform common FTP file operations such as file upload file, download file, delete file, create file, rename file, get file info list as ADO.net table (Useful for FTP file looping using ForEach Loop), get single file property (e.g. name, size, exists status) * Perform common FTP directory operations such as create folder, delete folder, get folder info list as ADO.net table (Useful for FTP folder looping using ForEach Loop) * Support for SFTP Server fingerprint verification and SSL Certificate Thumbprint verification before you send credentials or any other data to remote server * Support for multi file operation using wild card pattern or complex include/exclude pattern using regular expression * Support for ZLib compression for FTP and SSH based compression for SFTP. * Support for restoring timestamp after file transfer * Support for X509 Client Certificate along with UserID/Password Authentication * Support for Kerberos/NTLM Authentication along with Single-Signon option * Support for proxy with advanced options (Socks4, Socks4a, Socks5, HttpConnect Proxy type) * Support for Upload/Download Speed throttling For more information visit http://zappysys.com/products/ssis-powerpack/ssis-sftp-task-ftp-ftps/
Views: 3516 ZappySys
SSIS Export Excel Task - Generate excel Dynamically
 
06:39
Learn how to export data into Excel using SSIS. Generate excel dynamically from multiple tables or query. Learn more http://zappysys.com/products/ssis-powerpack/ssis-export-excel-file-task/ =============================== This video covers =============================== ◾How to export Excel files from multiple tables ◾How to export Excel file from SQL query ◾How to export data into multiple Sheets by row count/size or group column =============================== SSIS Export Excel File Task =============================== SSIS Export Excel File Task is your one stop solution to create excel reports/workbooks from SSIS. You don’t need any drivers, no need to worry about metadata issue you face with native SSIS Excel Task. We worked hard to take care most painful tasks for exporting data from any relational source to Excel. Features ◾Export multiple tables/views to Excel files (e.g. Sales% or do SalesJan|SalesFeb) ◾Support for all major office versions (e.g. Office 2003, 2007, 2013) ◾Export SQL query output to Excel file ◾Completely dynamic approach without limitation of DataFlow Stict Metadata ◾Option to export data to specific starting location in Excel Sheet (e.g A5 will start writng to 5th row 1st column) ◾Support for Password protected excel file ◾Option to clear range of cell before writing data to existing excel workbook (e.g. A1:D5000 will clear A to D columns from 1st to 5000 rows) ◾Automatically Split exported Excel data into multiple files by Size or Number of records ◾Automatically Split exported Excel data into multiple files or tabs when Split By Column (e.g. SplitBy=Country will create new file for each country, if SplitOnTab option specified then data written to new excel tab rather than file for each new group) ◾Support for Compression and Append ◾Fully managed means works out of the box on 32-Bit and 64-Bit without any change (Native SSIS Excel functionality is 32bit only). ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
Views: 3290 ZappySys
SQL Server - Import REST API / Read JSON File / XML File / SOAP (Pagination, OAuth, OData)
 
04:53
Learn how to Import data from REST API to SQL Server, Read JSON Files or XML Files inside SQL Server using T-SQL code. ZappySys ODBC Driver supports many advanced settings such as API Pagination to call virtually any API. For more information visit https://zappysys.com/products/odbc-powerpack/ ================================== About ODBC PowerPack ================================== ODBC PowerPack is a collection of high performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favourite Reporting / ETL tools (i.e. Power BI, Tableau, Qlik, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. ================================== Main Features ================================== ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files. Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API) Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp... ) Support very large JSON / XML files Support for Caching engine to reduce query time Support for retry options (To handle intermittent failures) Support for API pagination options (Many ways to paginate large API response) Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS) Comes with ZappySys Data Gateway Service which allows to use ZappySys Drivers without installing anything on their machine ================================== What's included ================================== - ODBC Driver for JSON Files / REST API - ODBC Driver for XML Files / SOAP API - Data Gateway Service ================================== ZappySys Data Gateway Service (ZSDG) ================================== ZappySys has developed a unique proxy service called ZappySys Data Gateway Service (ZSDG) it can run in cloud or you can install locally. 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 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 understand TDS Protocol and Client App can be running on any machine or operating system (MacOS, Linux, Windows). ================================== App Integration Scenarios (Reporting / ETL / BI / Analytics Tools) ================================== ZappySys ODBC API Drivers built using ODBC standard which is widely adopted by industry since long time. Which mean majority of BI Tools / Database Engines / ETL Tools already comes will ODBC Driver support. Below is the small list which can take advantage of ZappySys ODBC drivers. If your app doesn't appear in the below list, which means we have not tested or documented use case but as long as your tool support ODBC Standard, our drivers should work fine. Tableau Microsoft Power BI Informatica PowerCenter (Windows Edition) QlikView MS Excel SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) T-SQL (SQL Server Query Language) Visual Studio Oracle OBIEE ================================== Programming Language Support ================================== Most programming languages comes with out of the box support for ODBC. Which means you can use ZappySys ODBC drivers inside your favourite language. Here are few languages which already support ODBC. C# C++ JAVA (using JDBC-ODBC Bridge or using ZappySys Data Gateway via SQL Server JDBC) Python PHP PowerShell T-SQL (Using Linked Server) ================================== Keywords: ================================== SQL Server REST API, Read from REST API in SQL Server, How to load JSON file in SQL Server, How to import JSON to SQL Server, Access JSON in SQL Server, Access REST API in SQL Server, JSON to SQL Server, XML to SQL Server, Import JSON API into SQL Server. Import JSON File into SQL Server. Import REST API into SQL Server. Load JSON file in SQL Server 2008. Import JSON File in SQL Server 2012 / SQL Server 2014.
Views: 1844 ZappySys
ODBC PowerPack Intro - Loading JSON into Excel (Read from REST API URL or Files)
 
08:01
Read more at https://zappysys.com/products/odbc-powerpack/ This demo shows how use ZappySys API drivers to load json data into excel but same concepts can be applied for loading JSON /XML or REST API data into any other ODBC Compliant Apps (e.g. Power BI, Informatica, SQL Server, Crystal Reports / Business Objects, SSRS, SSIS) What is ODBC PowerPack? ========================== ODBC PowerPack is a collection of high-performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favorite Data Engine / Reporting / ETL tools (i.e. SQL Server, Power BI, Tableau, Qlik, SSRS, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. Our drivers can be called from your favorite programming languages such as JAVA, C#, Python etc. Main Features of ODBC PowerPack ================================ ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files. Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API) Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp… ) Support very large JSON / XML files Support for Caching engine to reduce query time Support for retry options (To handle intermittent failures) Support for API pagination options (Many ways to paginate large API response) Tight integration with SQL Server (Call REST API from T-SQL Code) Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS) Support for popular programming languages such as JAVA, C#, Python Keywords: ======================== loading json into excel load json data into excel load rest api data into excel how to load json file into excel how to read rest api data in excel call rest api in excel
Views: 480 ZappySys
How to call Salesforce REST API in SSIS (JSON API)
 
02:29
SSIS Salesforce API Task can be used to call any Salesforce.com API (e.g. REST/SOAP) which can be in XML or JSON format. This task provides easy way to save response into file or variable. For more information visit https://zappysys.com/products/ssis-powerpack/ssis-salesforce-api-task/ Features Support for calling any Salesforce REST API (RESTful API) Support for calling any Salesforce SOAP API (XML API) Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST ) Save response to variable or file Filter JSON response using JSONPath to extract specific value inside response text Filter XML response using XPath to extract specific value inside response text Validate response using custom rules such as Response Code must be less than 300, Response Content must contain XYZ string, Response Header must contain certain key/value pair … etc Support for Testing UI Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} {{User::MyDate,yyy-MM-dd}} {{User::MyAmount,C}} ) Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)
Views: 288 ZappySys
SSIS MongoDB Destination - Generate and load JSON Documents into MongoDB Collection
 
07:41
Learn how to generate nested JSON documents then load into MongoDB Collection. Read more: http://zappysys.com/products/ssis-powerpack/ssis-mongodb-destination/ Features: ◾Bulk load data to MongoDB using SSIS Connector ◾Support for loading Raw JSON documents from any source or generated by JSON Generator Transform ◾Multiple data operations supported such as Reload and Insert ◾Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)
Views: 2391 ZappySys
SSIS Azure Blob Storage Task - Upload, Download, Delete and Manage Blob
 
03:51
Learn how to interact with Azure Blob Storage in SSIS using drag and drop. Manage Azure Blob and Containers without coding. For more info: http://zappysys.com/products/ssis-powerpack/ssis-azure-blob-storage-task/ Features: ◾30+ azure storage operations for Azure Blob Storage (Such as Download, Upload, Copy, Delete…) ◾Download small or very large Azure Blob (i.e. Cloud Storage file) to local machine ◾Upload small or very large local file(s) to Azure Blob Storage ◾Support for Delete, Rename, List, Get Property, Copy, Move, Create, Set Permission … and many more operations ◾Support for Get List operation so you can use SSIS ForEachLoop to loop through files ◾Download, Upload, Copy, Delete are multi threaded (i.e. fast parallel operations) ◾Support for virtual folder structure (e.g. myroot/folder1/subfolder/myfile.txt ◾Support for SQL Server 2012, 2014 (32 bit and 64 bit)
Views: 2492 ZappySys
SSIS MongoDB Source - Read multiple arrays from JSON document
 
11:10
By default SSIS MongoDB Source can read only one hierarchy using JSON Path expression. But what if you want to parse data from multiple arrays found in same document (e.g. $.Orders[*] and $.Products[*] )? This video explains how to achieve that.
Views: 300 ZappySys
SSIS XML Tutorial Part 1 - Introduction (Export / Create XML / POST to SOAP API URL)
 
02:42
In this video you will learn how to generate a complex XML using SSIS (Create XML file using SSIS Control Flow Task / Data Flow Component). You will find this video helpful if you want to export XML data from a SQL Server (or other source e.g. Oracle, MySQL, DB2) to an XML file, you will also learn how to POST XML data to SOAP Web Service URL or submit XML-based REST API URL.. To see all SSIS XML Tasks and other REST / SOAP API related components check this link https://zappysys.com/products/ssis-powerpack ============================== SSIS Components used in this Video ============================== ZappySys PowerPack provides these components to deal with various XML generation scenarios: * SSIS Export XML Task * SSIS XML File Destination * SSIS XML Generator Transform In case you are watching this video but want to read XML files, use SSIS XML Source component or SSIS XML Parser Transform to parse XML from upstream column. ============================== SSIS Export XML File Task ============================== Use Export XML Task when you want to export XML from a database with great performance. Export XML Task supports SQL Server or any other database that you can connect to using ODBC or OLEDB drivers. You can export XML to a file, Azure Blob Storage, Amazon S3 Storage, SFTP or FTPS. With Export XML Task you can export a table as is with minimal configuration or export to a custom layout XML. https://zappysys.com/products/ssis-powerpack/ssis-export-xml-file-task/ Features: * Export multiple tables/views to XML files (e.g. Sales% or do SalesJan|SalesFeb) * Export SQL query output to XML file * Inbuilt Layout Editor for creating complex XML with nested structure (Document Array, Value Array, Nested attributes * Automatically Split exported XML data into multiple files by Size or Number of records * Automatically Split exported XML data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country) * Support for Compression and Append * Create Multi content XML documents * Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory * Articles/Tutorials: XML related articles ============================== SSIS XML File Destination ============================== XML File Destination is very similar to Export XML Task, except that it can use anything from upstream in a Data Flow and then save an XML to a file. XML File Destination, as well as Export XML Task and XML Generator Transform, which I will speak about in a moment, all support multiple data inputs. It means that you can have, for example, Customers as one input, Orders as another, and then join these two on a key to write customers with all their corresponding orders as child elements. https://zappysys.com/products/ssis-powerpack/ssis-xml-destination/ Features: * Generate complex XML document from single or multiple inputs * Easy to use drag & drop layout Editor for creating complex JSON with nested structure * Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory ============================== SSIS XML Generator Transform ============================== Finally, use XML Generator Transform when you have data coming from upstream in a Data Flow and yet you still need to pass the generated XML downstream. For example, you want to generate an XML that you need to save to a database or submit it to an XML-based API. https://zappysys.com/products/ssis-powerpack/ssis-xml-generator-transform/ Features: * Create simple or nested XML documents inside DataFlow Task using simple drag and drop approach * Ability to create nested XML from Multiple datasets * Ability to create single XML document for all input records or create one document for each input row from ROOT dataset * Preview XML structure as you change layout on User Interface * Ability to join different type of datasets (e.g. SQL Server, Flat File, Excel) to create parent-child relation for nested XML * Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory ============================== SSIS Web API Destination ============================== SSIS Web API Destination can be used to POST data to any API end point such as JSON API (i.e. POST to REST API) or POST to XML API (i.e. SOAP Web Service). This task provides several advanced options which makes it possible to connect virtually any API Service. https://zappysys.com/products/ssis-powerpack/ssis-web-api-destination-connector/ Features: * POST data to any API endpoint without coding (Read more…) * Support for windows / basic authentication, client certificate and OAuth (Read more…) * Support for File upload, REST API POST using Multipart/form-data (Read more…) * Support for Cookies (Read more…) * Support for Response Output (includes ResponseText and StatusCode) * Support for Error Output (Redirect failed request) * Support for easy Test UI (see request/response)
Views: 373 ZappySys
SSIS MongoDB Source - Use SQL Like Query Language for reading MongoDB Collection
 
05:18
In this video learn how to query from MongoDB data using SQL Language. Read More: http://zappysys.com/products/ssis-powerpack/ssis-mongodb-source/ Features: ◾Extract data from MongoDB collection using SSIS Adapter ◾Support for SQL Query for MongoDB. No need to learn new json style query language from MongoDB ◾Support for SQL Server 2005, 2008, 2012, 2014,2016 (32 bit and 64 bit)
Views: 1714 ZappySys
Read from Dynamics CRM in SSIS - Import from CRM 365 Online / On-Premises
 
06:36
Learn how to read from Dynamics CRM in SSIS, Import CRM 365 data and load into SQL Server using SSIS Dynamics CRM Source. For more information visit https://zappysys.com/products/ssis-powerpack/ SSIS Dynamics CRM Source Connector can be used to read data from Microsoft Dynamics CRM Service such as Dynamics 365 Online or On-Premises installation. You can use simple Table mode or write custom Query to extract desired data. Features ================== - Multiple modes (i.e. Table or Query) to read data from Dynamics CRM Online or On-Premises version - Support for FetchXML Query language - Support for automatic conversion between UTC date/time and Local date/time - Intuitive user interface with Dynamics CRM Object Browser - Support for data preview, max rows, batch size - Support for Dynamic query (using SSIS Variable placeholder e.g. {{User::MyVar}} ) - Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory
Views: 364 ZappySys
Tutorial - Create XML file using SSIS Task / POST to SOAP API URL / Export XML data from SQL Server
 
36:15
In this video you will learn how to generate a complex XML using SSIS (Create XML file using SSIS Control Flow Task / Data Flow Component). You will find this video helpful if you want to export XML data from a SQL Server (or other source e.g. Oracle, MySQL, DB2) to an XML file, you will also learn how to POST XML data to SOAP Web Service URL or submit XML-based REST API URL.. To see all SSIS XML Tasks and other REST / SOAP API related components check this link https://zappysys.com/products/ssis-powerpack ============================== SSIS Components used in this Video ============================== ZappySys PowerPack provides these components to deal with various XML generation scenarios: * SSIS Export XML Task * SSIS XML File Destination * SSIS XML Generator Transform In case you are watching this video but want to read XML files, use SSIS XML Source component or SSIS XML Parser Transform to parse XML from upstream column. ============================== SSIS Export XML File Task ============================== Use Export XML Task when you want to export XML from a database with great performance. Export XML Task supports SQL Server or any other database that you can connect to using ODBC or OLEDB drivers. You can export XML to a file, Azure Blob Storage, Amazon S3 Storage, SFTP or FTPS. With Export XML Task you can export a table as is with minimal configuration or export to a custom layout XML. https://zappysys.com/products/ssis-powerpack/ssis-export-xml-file-task/ Features: * Export multiple tables/views to XML files (e.g. Sales% or do SalesJan|SalesFeb) * Export SQL query output to XML file * Inbuilt Layout Editor for creating complex XML with nested structure (Document Array, Value Array, Nested attributes * Automatically Split exported XML data into multiple files by Size or Number of records * Automatically Split exported XML data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country) * Support for Compression and Append * Create Multi content XML documents * Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory * Articles/Tutorials: XML related articles ============================== SSIS XML File Destination ============================== XML File Destination is very similar to Export XML Task, except that it can use anything from upstream in a Data Flow and then save an XML to a file. XML File Destination, as well as Export XML Task and XML Generator Transform, which I will speak about in a moment, all support multiple data inputs. It means that you can have, for example, Customers as one input, Orders as another, and then join these two on a key to write customers with all their corresponding orders as child elements. https://zappysys.com/products/ssis-powerpack/ssis-xml-destination/ Features: * Generate complex XML document from single or multiple inputs * Easy to use drag & drop layout Editor for creating complex JSON with nested structure * Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory ============================== SSIS XML Generator Transform ============================== Finally, use XML Generator Transform when you have data coming from upstream in a Data Flow and yet you still need to pass the generated XML downstream. For example, you want to generate an XML that you need to save to a database or submit it to an XML-based API. https://zappysys.com/products/ssis-powerpack/ssis-xml-generator-transform/ Features: * Create simple or nested XML documents inside DataFlow Task using simple drag and drop approach * Ability to create nested XML from Multiple datasets * Ability to create single XML document for all input records or create one document for each input row from ROOT dataset * Preview XML structure as you change layout on User Interface * Ability to join different type of datasets (e.g. SQL Server, Flat File, Excel) to create parent-child relation for nested XML * Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory ============================== SSIS Web API Destination ============================== SSIS Web API Destination can be used to POST data to any API end point such as JSON API (i.e. POST to REST API) or POST to XML API (i.e. SOAP Web Service). This task provides several advanced options which makes it possible to connect virtually any API Service. https://zappysys.com/products/ssis-powerpack/ssis-web-api-destination-connector/ Features: * POST data to any API endpoint without coding (Read more…) * Support for windows / basic authentication, client certificate and OAuth (Read more…) * Support for File upload, REST API POST using Multipart/form-data (Read more…) * Support for Cookies (Read more…) * Support for Response Output (includes ResponseText and StatusCode) * Support for Error Output (Redirect failed request) * Support for easy Test UI (see request/response)
Views: 638 ZappySys
POST data to REST API URL in Power BI (Use JSON / XML ODBC Drivers for Web API and Files)
 
14:16
For more information check https://zappysys.com/products/odbc-powerpack/ This demo shows how use ZappySys API drivers to load JSON / XML REST API into Power BI or any other ODBC Compliant Apps (e.g. Excel, Informatica, SQL Server, Crystal Reports / Business Objects, SSRS, SSIS) What is ODBC PowerPack? ========================== ODBC PowerPack is a collection of high-performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favorite Data Engine / Reporting / ETL tools (i.e. SQL Server, Power BI, Tableau, Qlik, SSRS, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. Our drivers can be called from your favorite programming languages such as JAVA, C#, Python etc. Main Features of ODBC PowerPack ================================ ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files. Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API) Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp… ) Support very large JSON / XML files Support for Caching engine to reduce query time Support for retry options (To handle intermittent failures) Support for API pagination options (Many ways to paginate large API response) Tight integration with SQL Server (Call REST API from T-SQL Code) Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS) Support for popular programming languages such as JAVA, C#, Python Keywords: ======================== power bi post data to url power bi rest api post request call rest api in power bi how to call http post in power bi for rest api
Views: 576 ZappySys
SSIS XML Source - Read from XML Files, SOAP Web Service or Consume REST API
 
12:17
Learn how to read XML data in SSIS. Parse XML and load into database (e.g. SQL Server). Read from XML files, SOAP Web Service or REST API. Learn more http://zappysys.com/products/ssis-powerpack/ssis-xml-source/ ============================= Description: ============================= SSIS XML Source can be used to consume multiple XML files or XML formatted response from SOAP Web service or REST API Web Service. It supports advanced filtering along with flexible approach to configure request parameters for web service. ============================= Features: ============================= ◾Read XML data from any SOAP/REST API Web Service using methods such as GET/POST. ◾Read XML data from single or multiple XML files (use of wildcard allowed. e.g. c:\data\*.xml) ◾Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node). ◾Support for passing custom headers to SOAP or REST Web service ◾Support for looping through multiple files using wildcard pattern (e.g. *.xml). ◾REST API Paging support to loop through multiple requests (see) ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
Views: 5441 ZappySys
SSIS JSON Parser - Read multiple arrays extracted from API response
 
05:46
In this video learn how to extract multiple hierarchies from JSON document using SSIS JSON Source and JSON Parser Transform.
Views: 1884 ZappySys
Tableau - Read from REST API / JSON File / XML File /  SOAP Web Service (Pagination, OData, OAuth)
 
03:15
Learn how to read data from REST API, JSON Files or XML Files inside Tableau. ZappySys ODBC Driver supports many advanced settings such as API Pagination to call virtually any API. For more information visit https://zappysys.com/products/odbc-powerpack/ ================================== About ODBC PowerPack ================================== ODBC PowerPack is a collection of high performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favourite Reporting / ETL tools (i.e. Power BI, Tableau, Qlik, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. ================================== Main Features ================================== ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files. Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API) Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp... ) Support very large JSON / XML files Support for Caching engine to reduce query time Support for retry options (To handle intermittent failures) Support for API pagination options (Many ways to paginate large API response) Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS) Comes with ZappySys Data Gateway Service which allows to use ZappySys Drivers without installing anything on their machine ================================== What's included ================================== - ODBC Driver for JSON Files / REST API - ODBC Driver for XML Files / SOAP API - Data Gateway Service ================================== ZappySys Data Gateway Service (ZSDG) ================================== ZappySys has developed a unique proxy service called ZappySys Data Gateway Service (ZSDG) it can run in cloud or you can install locally. 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 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 understand TDS Protocol and Client App can be running on any machine or operating system (MacOS, Linux, Windows). ================================== App Integration Scenarios (Reporting / ETL / BI / Analytics Tools) ================================== ZappySys ODBC API Drivers built using ODBC standard which is widely adopted by industry since long time. Which mean majority of BI Tools / Database Engines / ETL Tools already comes will ODBC Driver support. Below is the small list which can take advantage of ZappySys ODBC drivers. If your app doesn't appear in the below list, which means we have not tested or documented use case but as long as your tool support ODBC Standard, our drivers should work fine. Tableau Microsoft Power BI Informatica PowerCenter (Windows Edition) QlikView MS Excel SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) T-SQL (SQL Server Query Language) Visual Studio Oracle OBIEE ================================== Programming Language Support ================================== Most programming languages comes 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. C# C++ JAVA (using JDBC-ODBC Bridge or using ZappySys Data Gateway via SQL Server JDBC) Python PHP PowerShell T-SQL (Using Linked Server) ================================== Keywords: ================================== Tableau REST API, Read from REST API in Tableau, How to load JSON file in Tableau, How to import JSON to Tableau, Access JSON in Tableau, Access REST API in Tableau, JSON to Tableau, XML to Tableau, Import JSON API into Tableau. Import JSON File into Tableau. Import REST API into Tableau.
Views: 1720 ZappySys
Salesforce Update using SSIS - Bulk Update from SQL Server
 
04:07
Read more here https://zappysys.com/products/ssis-powerpack/ssis-salesforce-destination-connector/ SSIS Salesforce Destination Connector can be used to load large amount of data from any source to Salesforce.com without any programming. You can use simple drag and drop mapping to perform Bulk Insert/Upsert/Update and Delete operations Features Load data into Salesforce.com from any source with drag and drop user interface Support multiple write operations (e.g. Bulk Insert, Update, Delete, Upsert) Support for executing assignment rule after Update/Insert operation for Case, Lead or Account Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)
Views: 19 ZappySys
How to call Salesforce API in SSIS (SOAP / REST API / XML / JSON )
 
06:59
SSIS Salesforce API Task can be used to call Salesforce API (REST or SOAP) which can be in XML format or JSON format. This task provides an easy way to save response into file or variable. For more information check https://zappysys.com/products/ssis-powerpack/ssis-salesforce-api-task/ Features Support for calling any Salesforce REST API (RESTful API) Support for calling any Salesforce SOAP API (XML API) Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST ) Save response to variable or file Filter JSON response using JSONPath to extract specific value inside response text Filter XML response using XPath to extract specific value inside response text Validate response using custom rules such as Response Code must be less than 300, Response Content must contain XYZ string, Response Header must contain certain key/value pair … etc Support for Testing UI Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} {{User::MyDate,yyy-MM-dd}} {{User::MyAmount,C}} ) Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit) Salesforce API call Examples: =========================== In this video you will learn following things 1. Call Salesforce REST API in SSIS (Call JSON API) 2. Call Salesforce SOAP API in SSIS (Call XML API) 3. Use of SoapUI tool
Views: 215 ZappySys
Power BI - Read REST API / JSON File / XML File / SOAP (Pagination, OAuth, OData)
 
03:40
Learn how to Read data from REST API, JSON Files or XML Files inside Power BI. ZappySys ODBC Driver supports many advanced settings such as API Pagination to call virtually any API. For more information visit https://zappysys.com/products/odbc-powerpack/ ================================== About ODBC PowerPack ================================== ODBC PowerPack is a collection of high performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favourite Reporting / ETL tools (i.e. Power BI, Tableau, Qlik, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. ================================== Main Features ================================== ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files. Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API) Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp... ) Support very large JSON / XML files Support for Caching engine to reduce query time Support for retry options (To handle intermittent failures) Support for API pagination options (Many ways to paginate large API response) Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS) Comes with ZappySys Data Gateway Service which allows to use ZappySys Drivers without installing anything on their machine ================================== What's included ================================== - ODBC Driver for JSON Files / REST API - ODBC Driver for XML Files / SOAP API - Data Gateway Service ================================== ZappySys Data Gateway Service (ZSDG) ================================== ZappySys has developed a unique proxy service called ZappySys Data Gateway Service (ZSDG) it can run in cloud or you can install locally. 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 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 understand TDS Protocol and Client App can be running on any machine or operating system (MacOS, Linux, Windows). ================================== App Integration Scenarios (Reporting / ETL / BI / Analytics Tools) ================================== ZappySys ODBC API Drivers built using ODBC standard which is widely adopted by industry since long time. Which mean majority of BI Tools / Database Engines / ETL Tools already comes will ODBC Driver support. Below is the small list which can take advantage of ZappySys ODBC drivers. If your app doesn't appear in the below list, which means we have not tested or documented use case but as long as your tool support ODBC Standard, our drivers should work fine. Tableau Microsoft Power BI Informatica PowerCenter (Windows Edition) QlikView MS Excel SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) T-SQL (SQL Server Query Language) Visual Studio Oracle OBIEE ================================== Programming Language Support ================================== Most programming languages comes 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. C# C++ JAVA (using JDBC-ODBC Bridge or using ZappySys Data Gateway via SQL Server JDBC) Python PHP PowerShell T-SQL (Using Linked Server) ================================== Keywords: ================================== Power BI REST API, Read from REST API in Power BI, How to load JSON file in Power BI, How to import JSON to Power BI, JSON to XLSX, JSON to PowerBI, XML to Power BI, XML to XLSX. Import JSON API into PowerBI. Import JSON File into Power BI. Import REST API into PowerBI.
Views: 3320 ZappySys
Informatica - Read from REST API / JSON File and load to SQL (XML SOAP, OData, OAuth, Pagination)
 
05:52
Learn how to read data from REST API, JSON Files or XML Files inside Informatica PowerCenter. ZappySys ODBC Driver supports many advanced settings such as API Pagination to call virtually any API. For more information visit https://zappysys.com/products/odbc-powerpack/ ================================== About ODBC PowerPack ================================== ODBC PowerPack is a collection of high performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favourite Reporting / ETL tools (i.e. Power BI, Tableau, Qlik, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. ================================== Main Features ================================== ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files. Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API) Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp... ) Support very large JSON / XML files Support for Caching engine to reduce query time Support for retry options (To handle intermittent failures) Support for API pagination options (Many ways to paginate large API response) Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS) Comes with ZappySys Data Gateway Service which allows to use ZappySys Drivers without installing anything on their machine ================================== What's included ================================== - ODBC Driver for JSON Files / REST API - ODBC Driver for XML Files / SOAP API - Data Gateway Service ================================== ZappySys Data Gateway Service (ZSDG) ================================== ZappySys has developed a unique proxy service called ZappySys Data Gateway Service (ZSDG) it can run in cloud or you can install locally. 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 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 understand TDS Protocol and Client App can be running on any machine or operating system (MacOS, Linux, Windows). ================================== App Integration Scenarios (Reporting / ETL / BI / Analytics Tools) ================================== ZappySys ODBC API Drivers built using ODBC standard which is widely adopted by industry since long time. Which mean majority of BI Tools / Database Engines / ETL Tools already comes will ODBC Driver support. Below is the small list which can take advantage of ZappySys ODBC drivers. If your app doesn't appear in the below list, which means we have not tested or documented use case but as long as your tool support ODBC Standard, our drivers should work fine. Tableau Microsoft Power BI Informatica PowerCenter (Windows Edition) QlikView MS Excel SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) T-SQL (SQL Server Query Language) Visual Studio Oracle OBIEE ================================== Programming Language Support ================================== Most programming languages comes 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. C# C++ JAVA (using JDBC-ODBC Bridge or using ZappySys Data Gateway via SQL Server JDBC) Python PHP PowerShell T-SQL (Using Linked Server) ================================== Keywords: ================================== Informatica REST API, Read from REST API in Informatica, How to load JSON file in Informatica, How to import JSON to Informatica, Access JSON in Informatica, Access REST API in Informatica, JSON to Informatica, XML to Informatica, Import JSON API into Informatica. Import JSON File into Informatica. Import REST API into Informatica.
Views: 2543 ZappySys
SSIS Azure Table Storage Connector - Bulk Read / Write data without Coding
 
08:00
Learn how to read from Azure Table Storage and load into SQL Server. Also learn how to bulk load data into Azure Table Storage in few clicks. Learn more http://zappysys.com/products/ssis-powerpack/ssis-azure-table-storage-destination/ ================================== About Azure Table Source Connector ================================== ================================== About Azure Table Destination Connector ================================== ◾Bulk load/write data to Azure Table Storage Table from SSIS dataflow ◾Interact and write data like a normal table, no need to learn complex APIs ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
Views: 653 ZappySys
SSIS CSV File Source - Read multiple CSV files, Import Gzip, Extract REST API data
 
06:38
SSIS CSV File Source (Advanced Flat file source) can be used to read CSV data from local files or Web API (REST API). You can extract data from single or multiple files (wildcard pattern supported). Also you can read compressed files (*.gz) without extracting files on disk. For more info check this link https://zappysys.com/products/ssis-powerpack/ssis-csv-file-source-flat-file-web-api/ ============= Features ============= Support for reading CSV data from Web API call or file(s) stored on local disk Support for reading single or multiple files (wildcard pattern supported e.g. *.csv) Support for reading zip and gzip compressed files (stream mode) Support for OAuth and HTTP Basic Authentication along with many security features Support for missing columns at the end (Auto fill with null values) Support for data pivot (transform columns into rows) Support for comments in the file Support for advanced error handling such as throw error for empty file, throw error when column count mismatch Support for Advanced parser options such as Trim fields, Trim headers, Skip rows Support for ignoring blank lines and blank rows (no data for each column) Support for Dynamic file path using variable placeholder (e.g. c:\data\{{User::MyFolder}}\*.csv ) Support for SQL Server 2005, 2008, 2012, 2014, 2016, 2017 (32 bit / 64 bit) ============= Keywords ============= Import compressed CSV file in SSIS Read from CSV format API in SSIS Import multiple Flat files in SSIS
Views: 384 ZappySys
ZappySys ODBC PowerPack - Drivers for JSON, REST API, XML, SOAP
 
10:12
ODBC PowerPack is a collection of high performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favourite Reporting / ETL tools (i.e. Power BI, Tableau, Qlik, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. ================================== Main Features ================================== ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files. Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API) Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp... ) Support very large JSON / XML files Support for Caching engine to reduce query time Support for retry options (To handle intermittent failures) Support for API pagination options (Many ways to paginate large API response) Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS) Comes with ZappySys Data Gateway Service which allows to use ZappySys Drivers without installing anything on their machine ================================== What's included ================================== - ODBC Driver for JSON Files / REST API - ODBC Driver for XML Files / SOAP API - Data Gateway Service ================================== ZappySys Data Gateway Service (ZSDG) ================================== ZappySys has developed a unique proxy service called ZappySys Data Gateway Service (ZSDG) it can run in cloud or you can install locally. 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 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 understand TDS Protocol and Client App can be running on any machine or operating system (MacOS, Linux, Windows). ================================== App Integration Scenarios (Reporting / ETL / BI / Analytics Tools) ================================== ZappySys ODBC API Drivers built using ODBC standard which is widely adopted by industry since long time. Which mean majority of BI Tools / Database Engines / ETL Tools already comes will ODBC Driver support. Below is the small list which can take advantage of ZappySys ODBC drivers. If your app doesn't appear in the below list, which means we have not tested or documented use case but as long as your tool support ODBC Standard, our drivers should work fine. Tableau Microsoft Power BI Informatica PowerCenter (Windows Edition) QlikView MS Excel SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) T-SQL (SQL Server Query Language) Visual Studio Oracle OBIEE ================================== Programming Language Support ================================== Most programming languages comes 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. C# C++ JAVA (using JDBC-ODBC Bridge or using ZappySys Data Gateway via SQL Server JDBC) Python PHP PowerShell T-SQL (Using Linked Server)
Views: 521 ZappySys
SSIS Salesforce Source - Read / Extract data using Table or SOQL Query mode and load to SQL Server
 
05:03
Read more here https://zappysys.com/products/ssis-powerpack/ssis-salesforce-source-connector/ SSIS Salesforce Source Connector can be used to extract large amount of data from Salesforce.com without any programming. You can use simple Table mode or Query mode with full SOQL query language support (SOQL=Salesforce.com Object Query Language). Features Multiple modes to read data from Salesforce CRM (i.e. Table or Query) Support for SOQL Query Language (Salesforce Object Query Language) Support for automatic conversion between UTC date/time and Local date/time Intuitive user interface with Salesforce Object Browser Support for data preview, max rows, batch size Support for Dynamic query (using SSIS Variable placeholder e.g. {{User::MyVar}} ) Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)
Views: 224 ZappySys
Generate multiple CSV files in SSIS Dynamically (Split by size/rows, Compress GZip)
 
06:35
Learn how to export relational source to CSV files in SSIS. Generate CSV files dynamically from Tables/Query. Learn more http://zappysys.com/products/ssis-powerpack/ssis-export-csv-file-task/ ============================ This video covers ============================ ◾ How to export multiple tables to CSV files from any data source ◾ How to export query output to CSV files ◾ How to split files based on row count / size or groupby column ◾ How to compress exported files in GZip format ============================ SSIS Export CSV File Task (Dynamic CSV File) ============================ SSIS Export CSV File Task is your one stop solution to create multiple CSV files (Flat Files) from SSIS. Say good bye to all MetaData related issues in DataFlow. We worked hard to take care most painful problems for exporting data from relational source (e.g. SQL Server, MySQL) to CSV. Features ◾Export multiple tables/views to CSV files (e.g. Sales% or do SalesJan|SalesFeb) ◾Export SQL query output to CSV file ◾Completely dynamic approach without limitation of DataFlow Strict Metadata ◾Split exported CSV data into multiple files by Size or Number of records ◾Split data into multiple files based on value from specific column (e.g. If you exporting customers and you specify SplitBy=Country then create new file for each country will be created for customer data) ◾Support for Compression and Append ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
Views: 3485 ZappySys
Load data into Dynamics CRM using SSIS - Insert, Update, Delete, Upsert
 
23:20
Learn how to load SQL Server data into Dynamics CRM using SSIS (Bulk Insert, Upsert, Delete, Update). Read below article for step by step tutorial. https://zappysys.com/blog/load-dynamics-crm-using-ssis-insert-upsert-delete-update/ Above article covers following topics. 1 Introduction 2 Requirements 3 Getting Started 3.1 Configure SSIS Dynamics CRM Connection 3.2 Bulk Insert – SQL Server data Import into Dynamics CRM using SSIS 3.3 Bulk Upsert – Update or Insert Dynamics CRM Records in SSIS 3.3.1 Create Alternate Key for CRM Upsert 3.3.2 Configure SSIS CRM Destination for Upsert 3.3.3 Handling Inserted / Updated Records Output 3.4 Bulk Update – Modify Dynamics CRM Records in SSIS 3.5 Bulk Delete – Delete Dynamics CRM Records in SSIS 4 Error Handling 5 Handling Special Data Types (PartyList, Lookup, PickList) 6 Conclusion 6.1 Share this: 6.2 Related ====================================== SSIS Dynamics CRM Destination Connector (Dynamics 365 / On-Premises CRM) ====================================== SSIS Dynamics CRM Destination Connector can be used to perform bulk insert, update, delete and upsert operation on Microsoft Dynamics CRM Service such as Dynamics 365 Online or On-Premises installation. Features ------------- Bulk Insert data to Microsoft Dynamics CRM service from any source such as SQL Server, JSON, Oracle Support for Bulk Upsert (Insert or Update) Support for Bulk Delete Support for New record Output (Useful to detect New vs Updated when you use Upsert) Support for Error Handling (Error output for failed records) Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory =========================================== Here is another article which explains how to read data from Dynamics 365 or On Premises CRM Instance. https://zappysys.com/blog/ssis-dynamics-crm-read-import-crm-365-onpremises/ This article covers following topics. 1 Introduction 2 Requirements for SSIS Dynamics CRM read component 3 SSIS Dynamics CRM Source – Video Tutorial 4 Getting started with SSIS Dynamics CRM read component 4.1 Configure Dynamics CRM Connection 4.2 How to create a Dynamics CRM Source 4.3 Configure SQL Server Destination 4.4 Load Dynamics CRM Data to SQL Server 5 How to query Dynamics CRM 5.1 How to generate a FetchXML query using UI 5.2 SELECT All Columns (*) 5.3 SELECT Specified Columns and Alias with SSIS Dynamics CRM 5.4 WHERE (AND conditions) 5.5 WHERE (OR conditions) 5.6 WHERE (Mixing AND / OR conditions) 5.7 SELECT DISTINCT (Exclude duplicates) 5.8 SELECT TOP using SSIS Dynamics CRM read 5.9 GROUP BY / Aggregate functions 5.10 INNER JOIN (matching child records) 5.11 LEFT OUTER JOIN (‘not in’ type query) 5.12 ORDER BY 5.13 OPERATOR – Equal ( = ) 5.14 OPERATOR – Not Equal ( != ) 5.15 OPERATOR – Greater Than 5.16 OPERATOR – Less Than 5.17 OPERATOR – IN (Check for multiple matching values) 5.18 OPERATOR – NULL (Check for NULL values) 5.19 OPERATOR – NOT NULL (Check for NOT NULL values) 5.20 OPERATOR – LIKE (Pattern search) 5.21 OPERATOR – NOT LIKE (Pattern search) 5.22 OPERATOR – UNDER (Find all children for given hierarchy) with the SSIS Dynamics CRM read task 5.23 Using DateTime Operators with the SSIS Dynamics CRM read task 5.24 Query – All activities (sort, outer join, alias) with the SSIS Dynamics CRM read task 6 How to use SSIS variables with Fetch XML in SSIS for SSIS Dynamics 7 CRM read ===================================================== SSIS Dynamics CRM Source Connector (Dynamics 365 / On-Premises CRM) ===================================================== SSIS Dynamics CRM Source Connector can be used to read data from Microsoft Dynamics CRM Service such as Dynamics 365 Online or On-Premises installation. You can use simple Table mode or write custom Query to extract desired data. Features ------------- Multiple modes (i.e. Table or Query) to read data from Dynamics CRM Online or On-Premises version Support for FetchXML Query language Support for automatic conversion between UTC date/time and Local date/time Intuitive user interface with Dynamics CRM Object Browser Support for data preview, max rows, batch size Support for Dynamic query (using SSIS Variable placeholder e.g. {{User::MyVar}} ) Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory
Views: 471 ZappySys
SSIS XML Tutorial Part 4 - Using SSIS XML Generator Transform (POST to SOAP or REST API URL)
 
10:11
Finally, use XML Generator Transform when you have data coming from upstream in a Data Flow and yet you still need to pass the generated XML downstream. For example, you want to generate an XML that you need to save to a database or submit it to an XML-based API. https://zappysys.com/products/ssis-powerpack/ssis-xml-generator-transform/ Features: * Create simple or nested XML documents inside DataFlow Task using simple drag and drop approach * Ability to create nested XML from Multiple datasets * Ability to create single XML document for all input records or create one document for each input row from ROOT dataset * Preview XML structure as you change layout on User Interface * Ability to join different type of datasets (e.g. SQL Server, Flat File, Excel) to create parent-child relation for nested XML * Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory ============================== SSIS Web API Destination ============================== SSIS Web API Destination can be used to POST data to any API end point such as JSON API (i.e. POST to REST API) or POST to XML API (i.e. SOAP Web Service). This task provides several advanced options which makes it possible to connect virtually any API Service. https://zappysys.com/products/ssis-powerpack/ssis-web-api-destination-connector/ Features: * POST data to any API endpoint without coding (Read more…) * Support for windows / basic authentication, client certificate and OAuth (Read more…) * Support for File upload, REST API POST using Multipart/form-data (Read more…) * Support for Cookies (Read more…) * Support for Response Output (includes ResponseText and StatusCode) * Support for Error Output (Redirect failed request) * Support for easy Test UI (see request/response)
Views: 61 ZappySys
Call SSRS Reports in SSIS Package (Email or Export SSRS on demand including SharePoint Report)
 
09:57
Learn how to call SSRS Reports in SSIS Package (Export from Reporting Services or Local RDL files). Check this link http://zappysys.com/products/ssis-powerpack/ssis-report-generator-task/ ============================================= This video covers ============================================= ◾ Export SSRS reports from server ◾ Export SSRS reports from SharePoint ◾ Export SSRS reports in local mode (*.rdl file) without need of server ◾ Export SSRS reports data-driven mode using config table ============================================= SSIS Reporting Services Task (SSIS Report Generator Task) ============================================= SSIS Report Generator Task can be used to export or email SSRS reports inside SSIS Package. This task also supports dynamic data driven export which can export several reports to disk and email to specified users based on settings stored in sql table. Features ◾Automate reporting services report export and email process using SSIS. ◾Support for SSRS 2005/2008/2012. ◾Support for Local report which requires no connectivity to SSRS server, just provide rdl file and runtime connection to export report. ◾Support for Sharepoint Integrated Mode. ◾Export report in xls, pdf, doc, xml, mhtml and csv format ◾Send report as attachment to list of users ◾Support for Data Driver export process. You can configure reports, recipients, file format and many other options inside Database table to drive your automated export process ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
Views: 8015 ZappySys
How to call Salesforce SOAP API in SSIS (XML API)
 
04:31
SSIS Salesforce API Task can be used to call any Salesforce.com API (e.g. REST/SOAP) which can be in XML or JSON format. This task provides easy way to save response into file or variable. For more information visit https://zappysys.com/products/ssis-powerpack/ssis-salesforce-api-task/ Features Support for calling any Salesforce REST API (RESTful API) Support for calling any Salesforce SOAP API (XML API) Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST ) Save response to variable or file Filter JSON response using JSONPath to extract specific value inside response text Filter XML response using XPath to extract specific value inside response text Validate response using custom rules such as Response Code must be less than 300, Response Content must contain XYZ string, Response Header must contain certain key/value pair … etc Support for Testing UI Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} {{User::MyDate,yyy-MM-dd}} {{User::MyAmount,C}} ) Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)
Views: 124 ZappySys
SSIS Xml Generator Transform - Create XML from multiple data sources
 
13:28
In this video tutorial you will learn following things * How to produce nested XML from multiple data sources inside SSIS Data Flow * How to produce nested XML from single data sources inside Data Flow * Save generated XML into local file * Techniques shown in this video can be applied to the following task/component - SSIS XML Generator Transform - SSIS Export XML File Task ============================== SSIS XML Generator Transform ============================== SSIS XML Generator Transform can be used to generate single or multiple XML documents from any type of datasources (e.g. SQL Server, MySQL, Flat File, Excel) inside dataflow task. Features ======= ◾Create simple or nested XML documents inside DataFlow Task using simple drag and drop approach ◾Ability to create nested XML from Multiple datasets ◾Ability to create single XML document for all input records or create one document for each input row from ROOT dataset ◾Preview XML structure as you change layout on User Interface ◾Ability to join different type of datasets (e.g. SQL Server, Flat File, Excel) to create parent-child relation for nested XML ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit) http://zappysys.com/products/ssis-powerpack/ssis-xml-generator-transform/ ============================== SSIS Export XML File Task ============================== SSIS Export XML File Task SSIS Export XML File Task can be used to generate simple or complex XML files out of relational data source such as SQL Server, Oracle, MySQL. In few clicks you can create desired XML Shape from single or multiple tables (Parent/Child Nested Documents) Features ◾Export multiple tables/views to XML files (e.g. Sales% or do SalesJan|SalesFeb) ◾Export SQL query output to XML file ◾Inbuilt Layout Editor for creating complex XML with nested structure (Document Array, Value Array, Nested attributes ◾Automatically Split exported XML data into multiple files by Size or Number of records ◾Automatically Split exported XML data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country) ◾Support for Compression and Append ◾Create Multi content XML documents ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit) http://zappysys.com/products/ssis-powerpack/ssis-export-xml-file-task/
Views: 1861 ZappySys
How to insert or update MongoDB array items using SSIS (Load JSON File, Use $set, $push operator)
 
17:00
In this video tutorial you will learn following things. For more information check https://zappysys.com/products/ssis-powerpack/ssis-mongodb-destination/ * How to execute MongoDB Shell commands in SSIS (e.g. create Collection) * How to load JSON data into MongoDB collection from JSON file - Using SSIS JSON Source Connector * How to update MongoDB array items (First level array) - Using SSIS MongoDB Destination Connector * How to insert new items into MongoDB Array (use $push operator) - Using SSIS MongoDB Destination Connector ========================= About SSIS MongoDB Destination Connector ========================= ◾Bulk load data to MongoDB using SSIS Connector ◾Support for loading Raw JSON documents from any source or generated by JSON Generator Transform or other method ◾Multiple data operations supported such as Reload and Insert ◾Support for Bulk Upsert (Update or Insert) ◾Support for Bulk Delete ◾Support for inserting/updating/removing values from inner array (e.g. Insert New Order inside existing Customer Document) ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit) ========================= About SSIS JSON Source Connector ========================= ◾Read data from JSON files or RESTful API services (such as Twitter, Zendesk) ◾De-normalize nested JSON into flat document just like regular database table ◾Support for JSONPath expression to extract sub-documents or array (see also: Extract multiple arrays using JSON Parser Transform) ◾Support for OAuth 1.0 and 2.0 security standard which is adopted by major cloud services (e.g. Google API, Facebook, Salesforce, Dynamics CRM, Office 365, MailChimp and many more..) ◾Support for OData format (Read more) ◾Support for Basic authorization (Passing UserID and Password to REST API Service) ◾Support for looping through multiple files using wild card pattern (e.g. *.json). ◾Support for HTTP Request with Custom Headers. ◾Support for REST API Paging (3 different methods) – Loop through multiple requests (explained here and here) ◾Support for very large JSON files ◾Support for Pivoting (Convert Columns to Rows) ◾Ability to output and indent raw JSON from inner array ◾Support for SSL3 and TLS 1.2 protocol for encryption ◾Support for passing cookies ◾Support for Proxy ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit) ========================= About SSIS JSON Generator Transform ========================= ◾Create simple or nested JSON documents inside DataFlow Task using simple drag and drop approach ◾Ability to create nested JSON from Multiple datasets ◾Ability to create single JSON document for all input records or create one document for each input row from ROOT dataset ◾Preview JSON structure as you change layout on User Interface ◾Support Sub document, Value Array and Document Array ◾Ability to join different type of datasets (e.g. SQL Server, Flat File, Excel) to create parent-child relation for nested JSON ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
Views: 910 ZappySys
Salesforce Upsert using SSIS - Bulk Update or Insert records from SQL Server
 
04:46
Read more here https://zappysys.com/products/ssis-powerpack/ssis-salesforce-destination-connector/ SSIS Salesforce Destination Connector can be used to load large amount of data from any source to Salesforce.com without any programming. You can use simple drag and drop mapping to perform Bulk Insert/Upsert/Update and Delete operations Features Load data into Salesforce.com from any source with drag and drop user interface Support multiple write operations (e.g. Bulk Insert, Update, Delete, Upsert) Support for executing assignment rule after Update/Insert operation for Case, Lead or Account Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)
Views: 115 ZappySys
SSRS - How to read for REST API / JSON File / XML Service (OData OAuth, Pagination)
 
03:38
Learn how to read data from REST API, JSON Files or XML Files inside SSRS (Microsoft SQL Server Reporting Services). ZappySys ODBC Driver supports many advanced settings such as API Pagination to call virtually any API. For more information visit https://zappysys.com/products/odbc-powerpack/ ================================== About ODBC PowerPack ================================== ODBC PowerPack is a collection of high performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favourite Reporting / ETL tools (i.e. Power BI, Tableau, Qlik, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. ================================== Main Features ================================== ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files. Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API) Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp... ) Support very large JSON / XML files Support for Caching engine to reduce query time Support for retry options (To handle intermittent failures) Support for API pagination options (Many ways to paginate large API response) Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS) Comes with ZappySys Data Gateway Service which allows to use ZappySys Drivers without installing anything on their machine ================================== What's included ================================== - ODBC Driver for JSON Files / REST API - ODBC Driver for XML Files / SOAP API - Data Gateway Service ================================== ZappySys Data Gateway Service (ZSDG) ================================== ZappySys has developed a unique proxy service called ZappySys Data Gateway Service (ZSDG) it can run in cloud or you can install locally. 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 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 understand TDS Protocol and Client App can be running on any machine or operating system (MacOS, Linux, Windows). ================================== App Integration Scenarios (Reporting / ETL / BI / Analytics Tools) ================================== ZappySys ODBC API Drivers built using ODBC standard which is widely adopted by industry since long time. Which mean majority of BI Tools / Database Engines / ETL Tools already comes will ODBC Driver support. Below is the small list which can take advantage of ZappySys ODBC drivers. If your app doesn't appear in the below list, which means we have not tested or documented use case but as long as your tool support ODBC Standard, our drivers should work fine. Tableau Microsoft Power BI Informatica PowerCenter (Windows Edition) QlikView MS Excel SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) T-SQL (SQL Server Query Language) Visual Studio Oracle OBIEE ================================== Programming Language Support ================================== Most programming languages comes 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. C# C++ JAVA (using JDBC-ODBC Bridge or using ZappySys Data Gateway via SQL Server JDBC) Python PHP PowerShell T-SQL (Using Linked Server) ================================== Keywords: ================================== SSRS REST API, Read from REST API in SSRS, How to load JSON file in SSRS, How to import JSON to SSRS, Access JSON in SSRS, Access REST API in SSRS, JSON to SSRS, XML to SSRS, Import JSON API into SSRS. Import JSON File into SSRS. Import REST API into SSRS.
Views: 1370 ZappySys
Query/Read data from Amazon DynamoDB Table, Write JSON documents into DynamoDB
 
11:30
Learn how to Create/Drop Amazon DynamoDB Table, How to Query DynamoDB Table, Read, Write JSON documents in bulk. Visit http://zappysys.com/products/ssis-powerpack/ssis-dynamodb-source/ ================================ This video covers ================================ ◾How to create/drop AWS DynamoDB Table in SSIS ◾How to load JSON documents into Amazon DynamoDB using SSIS Connector ◾How to read/query DynamoDB data using SSIS Connector How to extract inner array and output data as JSON ================================ SSIS Amazon DynamoDB Source ================================ Amazon DynamoDB Source can be used to extract large amount of data from Amazon DynamoDB. This component supports SQL like query language to query DynamoDB data without worrying about complex API. Amazon DynamoDB is a cloud based NoSQL data storage service from Amazon AWS http://zappysys.com/products/ssis-powerpack/ssis-dynamodb-source/ Features ◾Bulk extract/output Amazon DynamoDB data ◾Support for SQL Like queries using proprietary Query engine, no need to learn complex AWS APIs ◾Complete JSON support such as extract data from inner array using JSON Path ◾Support for extracting raw JSON documents from DynamoDB ◾Support for both SCAN and QUERY Mode available in DynamoDB ◾Support for data preview ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit) ================================ SSIS Amazon DynamoDB Destination ================================ Amazon DynamoDB Destination can be used to bulk insert large amount of records to Amazon DynamoDB storage from any data source using SSIS. Amazon DynamoDB is a cloud based NoSQL data storage service from Amazon AWS http://zappysys.com/products/ssis-powerpack/ssis-dynamodb-source/ Features ◾Bulk load data to Amazon DynamoDB Table ◾Bulk Delete support ◾Support for loading raw JSON documents rather than mapping each column ◾Support for multi threaded parallel load ◾Interact and write data like a normal table, no need to learn complex APIs ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit) ================================ SSIS Amazon DynamoDB ExecuteSQL Task ================================ Amazon DynamoDB ExecuteSQL Task can be used to execute ad-hoc commands for Amazon DynamoDB (e.g. DDL statements such as Create/Drop collection, DML statements such as Insert, Update, Delete or Run JavaScript and shell commands.) http://zappysys.com/products/ssis-powerpack/ssis-amazon-dynamodb-executesql-task/ Features ◾Intuitive user interface with many examples makes DynamoDB learning super easy and fast ◾Support for executing DDL statements such as Create/Drop table ◾Support for executing DML statements such as Select/Insert/Update/Delete ◾Support for saving RawResult (e.g. JSON response) into SSIS variable ◾Support for saving SingleValue from response such as count or size from getStats function response. ◾Support for saving FullResultset as ADO.net dataset (e.g. select * from mytable) can be stored as ADO.net recordset (can be used with ForEachLoop container task for looping).
Views: 3583 ZappySys
Load data into Redshift using ZappyShell Command Line tools
 
07:25
Learn how to load data into redshift using simple command line. Read more.. http://zappysys.com/products/zappyshell/amazon-redshift-command-line-tools/ Command line for Amazon Redshift ◾Import data to AWS Redshift database from files or relational source (e.g. MySQL, Oracle, SQL Server) ◾Import huge amount of data (millions of rows) in few minutes with parallel load techniques ◾Load local flat files to Redshift in just single line command (option to compress data files to *.gz to speed up transfer) ◾Support for Client side encryption using AES 256 Key ◾Load data from any data source (ODBC,ADO.net or OLEDB) using sql query ◾Import compressed data files (*.gz) to redshift ◾Archive files, error reporting, file splitting, many other features ====================== Examples: ====================== ############################################## #below command will import data from any relation source (e.g. SQL Server) into redshift DB ############################################## import Db --source-driver ADONET_MSSQL --source-query "SELECT top 10000 ROW_NUMBER()Over(order by a.CustomerID) Id , a.*,b.*,c.OrderID ,c.OrderDate,c.Freight FROM customers a,products b,orders c" --maxrows-perfile 1000 --source-stagepath "c:\redshift\stage" --target-table "customerdata" --target-stagepath "bw-rstest/cmdstage" --target-truncate --logfile "c:\redshift\log.txt" --region us-east-1 --accesskey "AKIA*****************" --secretkey "lPi+XQ************************" --source-connstr "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;" --target-connstr "Host=mytestcluster-1.csu********.us-east-1.redshift.amazonaws.com;Port=5439;Database=dev;UserName=masteruser;Password=*********;EnableSsl=true;Timeout=30;CommandTimeout=3600;" ############################################## #below command will import local files in redshift DB ############################################## import file --source-path "c:\data\files\*.part.csv" --source-stagepath "c:\redshift\stage" --target-table "customerdata" --target-stagepath "bw-rstest/cmdstage" --target-truncate --logfile "c:\redshift\log.txt" --region us-east-1 --accesskey "AKIA*****************" --secretkey "lPi+XQ************************" --source-connstr "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;" --target-connstr "Host=mytestcluster-1.csu********.us-east-1.redshift.amazonaws.com;Port=5439;Database=dev;UserName=masteruser;Password=*********;EnableSsl=true;Timeout=30;CommandTimeout=3600;" ############################################## #Import SQL Server records to Redshift Cluster - With Encryption turned on ############################################## #=========================== #Step-1 : Create your encryption key (This step only required first time. Once encryption key is generated you can reuse it) #=========================== mkkey "c:\private.key" --aes #=========================== #Step-2 : Load your data to redshift #=========================== import Db --enc-key "c:\private.key" --source-driver ADONET_MSSQL --source-query "select ROW_NUMBER()Over(order by a.CustomerID) Id, a.*,b.*,c.OrderID,c.OrderDate,c.Freight from customers a,products b,orders c" --source-stagepath "c:\redshift\stage" --target-table "customerdata" --target-stagepath "bw-rstest/cmdstage" --logfile "c:\redshift\log.txt" --region us-east-1 --accesskey "AKIA*****************" --secretkey "lPi+XQ************************" --source-connstr "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;" --target-connstr "Host=mytestcluster-1.csu********.us-east-1.redshift.amazonaws.com;Port=5439;Database=dev;UserName=masteruser;Password=*********;EnableSsl=true;Timeout=30;CommandTimeout=3600;"
Views: 1268 ZappySys
POST data to API URL using SSIS - Read from JSON REST API and submit to another web service
 
07:22
Read more https://zappysys.com/products/ssis-powerpack/ssis-web-api-destination-connector/ In this video we will look into common pattern of handling API read/Write using drag and drop SSIS Connectors for JSON / REST API. ====================================================== SSIS JSON Source (File, REST API, OData Connector) ====================================================== JSON Source Connector can be used to extract and output JSON data stored in local JSON files, JSON data coming from REST API webservice calls (Web URL) or direct JSON String. Component also supports JSONPath to filter data from nested array/sub-documents. This component is optimized to work with very large files. Features ======== Read data from JSON files or RESTful API services (such as Twitter, Zendesk) De-normalize nested JSON into flat document just like regular database table Unparalleled performance with large file support (See how we processed 3 million rows in 3 mins) Support for JSONPath expression to extract sub-documents or array (see also: Extract multiple arrays using JSON Parser Transform) Support for OAuth 1.0 and 2.0 security standard which is adopted by major cloud services (e.g. Google API, Facebook, Salesforce, Dynamics CRM, Office 365, MailChimp and many more..) Support for OData format (Read more) Support for Basic authorization (Passing UserID and Password to REST API Service) Support for looping through multiple files using wild card pattern (e.g. *.json). Support for HTTP Request with Custom Headers. Support for REST API Paging (3 different methods) – Loop through multiple requests (explained here and here) Support for 2D arrays and Complex Transformation (See this article and this for Google BigQuery) Support for Pivoting (Convert Columns to Rows) Ability to output and indent raw JSON from inner array Support for SSL3 and TLS 1.2 protocol for encryption Support for passing cookies Support for Proxy Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit) ====================================================== SSIS Web API Destination (POST data to URL) ====================================================== SSIS Web API Destination can be used to POST data to any API end point such as JSON API (i.e. POST to REST API) or POST to XML API (i.e. SOAP Web Service). This task provides several advanced options which makes it possible to connect virtually any API Service. Features ========== POST data to any API endpoint without coding (Read more…) Support for windows / basic authentication, client certificate and OAuth (Read more…) Support for File upload, REST API POST using Multipart/form-data (Read more…) Support for Cookies (Read more…) Support for Response Output (includes ResponseText and StatusCode) Support for Error Output (Redirect failed request) Support for easy Test UI (see request/response) Support for Bulk Mode (Group multiple requests into single body) Support for advanced options (e.g. Gzip compression, timeout, Set SSL/TLS protocols. TLS 1.2 supported) Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} ) Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)
Views: 1581 ZappySys
SSIS XML Tutorial Part 3 - Using SSIS XML File Destination (Generate XML File in Data Flow)
 
13:28
XML File Destination is very similar to Export XML Task, except that it can use anything from upstream in a Data Flow and then save an XML to a file. XML File Destination, as well as Export XML Task and XML Generator Transform, which I will speak about in a moment, all support multiple data inputs. It means that you can have, for example, Customers as one input, Orders as another, and then join these two on a key to write customers with all their corresponding orders as child elements. https://zappysys.com/products/ssis-powerpack/ssis-xml-destination/ Features: * Create XML file from single or multiple inputs in Data Flow * Create simple or nested XML documents inside DataFlow Task using simple drag and drop approach * Ability to create nested XML from Multiple datasets * Ability to create single XML document for all input records or create one document for each input row from ROOT dataset * Preview XML structure as you change layout on User Interface * Ability to join different type of datasets (e.g. SQL Server, Flat File, Excel) to create parent-child relation for nested XML * Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory
Views: 177 ZappySys
Import JSON to Excel (Load JSON File or REST API  with Pagination)
 
02:33
Learn how to Import JSON to Excel (Load JSON File to Excel / Import REST API data to Excel 2017 / 2016. ZappySys ODBC Driver supports many advanced settings such as API Pagination to call virtually any API. For more information visit https://zappysys.com/products/odbc-powerpack/ ================================== About ODBC PowerPack ================================== ODBC PowerPack is a collection of high performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favourite Reporting / ETL tools (i.e. Power BI, Tableau, Qlik, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. ================================== Main Features ================================== ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files. Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API) Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp... ) Support very large JSON / XML files Support for Caching engine to reduce query time Support for retry options (To handle intermittent failures) Support for API pagination options (Many ways to paginate large API response) Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS) Comes with ZappySys Data Gateway Service which allows to use ZappySys Drivers without installing anything on their machine ================================== What's included ================================== - ODBC Driver for JSON Files / REST API - ODBC Driver for XML Files / SOAP API - Data Gateway Service ================================== ZappySys Data Gateway Service (ZSDG) ================================== ZappySys has developed a unique proxy service called ZappySys Data Gateway Service (ZSDG) it can run in cloud or you can install locally. 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 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 understand TDS Protocol and Client App can be running on any machine or operating system (MacOS, Linux, Windows). ================================== App Integration Scenarios (Reporting / ETL / BI / Analytics Tools) ================================== ZappySys ODBC API Drivers built using ODBC standard which is widely adopted by industry since long time. Which mean majority of BI Tools / Database Engines / ETL Tools already comes will ODBC Driver support. Below is the small list which can take advantage of ZappySys ODBC drivers. If your app doesn't appear in the below list, which means we have not tested or documented use case but as long as your tool support ODBC Standard, our drivers should work fine. Tableau Microsoft Power BI Informatica PowerCenter (Windows Edition) QlikView MS Excel SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) T-SQL (SQL Server Query Language) Visual Studio Oracle OBIEE ================================== Programming Language Support ================================== Most programming languages comes 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. C# C++ JAVA (using JDBC-ODBC Bridge or using ZappySys Data Gateway via SQL Server JDBC) Python PHP PowerShell T-SQL (Using Linked Server) ================================== Keywords: ================================== Excel REST API, Read from REST API in Excel, How to load JSON file in Excel, How to import JSON to Excel, JSON to XLSX, JSON to Excel, XML to Excel, XML to XLSX. Import JSON API into Excel. Import JSON File into Excel. Import REST API into Excel.
Views: 3030 ZappySys
SSIS XML Tutorial Part 2 - Using SSIS Export XML File Task (Output SQL Server Data to XML)
 
08:40
Use Export XML Task when you want to export XML from a database with great performance. Export XML Task supports SQL Server or any other database that you can connect to using ODBC or OLEDB drivers. You can export XML to a file, Azure Blob Storage, Amazon S3 Storage, SFTP or FTPS. With Export XML Task you can export a table as is with minimal configuration or export to a custom layout XML. https://zappysys.com/products/ssis-powerpack/ssis-export-xml-file-task/ Features: * Export multiple tables/views to XML files (e.g. Sales% or do SalesJan|SalesFeb) * Export SQL query output to XML file * Inbuilt Layout Editor for creating complex XML with nested structure (Document Array, Value Array, Nested attributes * Automatically Split exported XML data into multiple files by Size or Number of records * Automatically Split exported XML data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country) * Support for Compression and Append * Create Multi content XML documents * Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory * Articles/Tutorials: XML related articles
Views: 282 ZappySys
SSIS Salesforce Destination - Bulk insert, update, delete and upsert (load from SQL Server table)
 
13:40
Read more here https://zappysys.com/products/ssis-powerpack/ssis-salesforce-destination-connector/ SSIS Salesforce Destination Connector can be used to load large amount of data from any source to Salesforce.com without any programming. You can use simple drag and drop mapping to perform Bulk Insert/Upsert/Update and Delete operations Features Load data into Salesforce.com from any source with drag and drop user interface Support multiple write operations (e.g. Bulk Insert, Update, Delete, Upsert) Support for executing assignment rule after Update/Insert operation for Case, Lead or Account Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)
Views: 512 ZappySys