This video will demonstrate how to connect or integrate SharePoint in SSIS package using OData.
http://pragmaticworks.com/Products/Task-Factory/Feature/Connectivity/SSIS-Rest-Source This video gives an overview of the SSIS Rest Source that gives you the ability to pull data from any rest enabled web service into your data flow in SSIS.
How to connect to an OData datasource using SharePoint Online and Business Connectivity Services using BCS Meta Man. www.lightningtools.com
See how to upload files and their metadata to SharePoint using SSIS with Task Factory. Download a trial of Task Factory here: http://www.taskfactory.com.
Sharepoint Connection in SSIS
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)
If you're unfamiliar with it, SSIS can initially seem intimidating. A quick start approach can get you up and running - without the 700-page manual. See how practical data migration, beyond what you could accomplish using the Microsoft Dynamics CRM Data Import Wizard, can be accomplished quickly with the right guide and tools from SQL Server SSIS. More Microsoft Dynamics CRM Webcasts: http://msdynamicsworld.com/webcasts
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.
Microsoft SSIS was low on new features in a couple of releases and now it is catching up really quickly - and we want you to catch up with us and Microsoft. There were a lot of new features in 2016 and 2017, and they include connectivity, OS, operating on big data, and many many more. We will be covering selective new features such as how to operate an Azure blobs, do AlwaysOnEncryption, updating Odata in our session SSIS 2016/2017 Intermediate Virginia Mushkatblat has 20 years of development and architectural experience with critical data-intensive applications. She has worked in companies ranging from start-ups to international conglomerates with the range of requirements, including those of 24/7 and batch processing, and lead teams of DB developers, architects and administrators. She has worked in entertainment, technology, e-commerce, and financial industries. She holds Masters Degrees in Engineering and in Computer Science and originated several patents.