{"id":12398,"date":"2026-08-14T00:09:11","date_gmt":"2026-08-14T00:09:11","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12398"},"modified":"2026-08-14T00:09:11","modified_gmt":"2026-08-14T00:09:11","slug":"ssis-tutorial-how-to-get-data-from-hivebrite","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/","title":{"rendered":"SSIS Tutorial: How to get data from Hivebrite"},"content":{"rendered":"<p><!-- Introduction --><\/p>\n<h2>Introduction<\/h2>\n<p class=\"intro-text\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12406  alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo-150x150.jpg\" alt=\"\" width=\"112\" height=\"112\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo-150x150.jpg 150w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo-300x300.jpg 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg 447w\" sizes=\"(max-width: 112px) 100vw, 112px\" \/><\/a>Hivebrite is a community management platform used for memberships, events, directories, and engagement workflows. Many teams need Hivebrite data in SQL Server for reporting, segmentation, and operational analytics.<\/p>\n<p class=\"intro-text\">In this tutorial, you will learn how to connect Hivebrite API data to SQL Server Integration Services (SSIS) by using ZappySys SSIS PowerPack. You can then automate extraction and loading without writing a custom API client.<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-2523\"><h2><span id=\"Prerequisites\">Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, make sure the prerequisites are met:\r\n<ol style=\"margin-left: 1.5em;\">\r\n \t<li>Basic knowledge of SSIS package\u00a0development using\u00a0<em>Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t<li>Make sure the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssdt\/download-sql-server-data-tools-ssdt\">SSIS designer<\/a> is installed.<\/li>\r\n \t<li>Download and install <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/download\/\">ZappySys SSIS PowerPack<\/a>.<\/li>\r\n<\/ol>\r\n<strong>NOTE:<\/strong> If you are planning to deploy packages to a server and schedule their execution later, <a href=\"https:\/\/zappysys.zendesk.com\/hc\/en-us\/articles\/360035974593\" target=\"_blank\" rel=\"noopener\">read this article<\/a>.<\/div>\n<p><!-- Steps --><\/p>\n<h2>Steps<\/h2>\n<h3>Prepare Hivebrite API access<\/h3>\n<ol>\n<li>Sign in to your Hivebrite <a href=\"https:\/\/support.hivebrite.com\/hc\/en-us\/articles\/12953361732508\">admin area<\/a> and go to <strong>Integrations \u2192 External Integrations<\/strong>.<\/li>\n<li>Click <strong>Create a Service App<\/strong> and give it a name.\n<ul>\n<li>Copy the <strong>Client ID<\/strong> (UUID) and <strong>Client Secret<\/strong> shown at creation \u2014 the secret is displayed only once and cannot be retrieved afterward.<\/li>\n<\/ul>\n<\/li>\n<li>Identify your <strong>Authorization Host<\/strong> based on the zone that hosts your community:\n<ul>\n<li><strong>US:<\/strong> <code>auth.us.hivebrite.com<\/code><\/li>\n<li><strong>EU:<\/strong> <code>auth.eu.hivebrite.com<\/code><\/li>\n<li><strong>APAC:<\/strong> <code>auth.apac.hivebrite.com<\/code><\/li>\n<li><strong>CH:<\/strong> <code>auth.ch.hivebrite.com<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3>Create an OAuth2 connection in SSIS<\/h3>\n<ol>\n<li>Create or open your SSIS project and package.<\/li>\n<li>In <strong>Connection Managers<\/strong>, right-click and select <strong>New Connection&#8230;<\/strong>.<\/li>\n<li>Select <strong>ZS-OAUTH<\/strong> from the SSIS connectors list.\n<div id=\"attachment_11825\" style=\"width: 959px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11825\" class=\"size-full wp-image-11825\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png\" alt=\"\" width=\"949\" height=\"447\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png 949w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager-300x141.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager-768x362.png 768w\" sizes=\"(max-width: 949px) 100vw, 949px\" \/><\/a><p id=\"caption-attachment-11825\" class=\"wp-caption-text\">Create a new SSIS OAuth API Connection Manager.<\/p><\/div><\/li>\n<li>Set the following values:\n<ul>\n<li><strong>OAuth Provider:<\/strong> Custom<\/li>\n<li><strong>OAuth Version:<\/strong> OAuth2<\/li>\n<li><strong>OAuth Grant Type:<\/strong> Client Credentials Grant<\/li>\n<li><strong>Client ID:<\/strong> Your Hivebrite Client ID (UUID)<\/li>\n<li><strong>Client Secret:<\/strong> Your Hivebrite Client Secret<\/li>\n<li><strong>Access Token URL:<\/strong> <code>https:\/\/auth.{zone}.hivebrite.com\/oauth2\/token<\/code><\/li>\n<li><strong>Scopes\/Permissions:<\/strong> (leave empty)\n<div id=\"attachment_12405\" style=\"width: 713px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-OAuth-connection-configuration.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12405\" class=\"size-full wp-image-12405\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-OAuth-connection-configuration.png\" alt=\"\" width=\"703\" height=\"637\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-OAuth-connection-configuration.png 703w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-OAuth-connection-configuration-300x272.png 300w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/a><p id=\"caption-attachment-12405\" class=\"wp-caption-text\">Hivebrite &#8211; OAuth connection configuration<\/p><\/div><\/li>\n<\/ul>\n<\/li>\n<li>Go to the <strong>OAuth2 Grant Options<\/strong> tab and add the following to the <strong>Extra attributes for the token request<\/strong> parameter:\n<pre class=\"lang:default decode:true\">audience=partner<\/pre>\n<\/li>\n<li>Then click <strong>OK <\/strong>to save the configuration.\n<div id=\"attachment_12404\" style=\"width: 713px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-OAuth-connection-advanced-configuration.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12404\" class=\"size-full wp-image-12404\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-OAuth-connection-advanced-configuration.png\" alt=\"\" width=\"703\" height=\"637\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-OAuth-connection-advanced-configuration.png 703w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-OAuth-connection-advanced-configuration-300x272.png 300w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/a><p id=\"caption-attachment-12404\" class=\"wp-caption-text\">Hivebrite &#8211; OAuth connection advanced configuration<\/p><\/div><\/li>\n<\/ol>\n<h3>Create and configure JSON Source<\/h3>\n<ol>\n<li>Drag a <strong>Data Flow Task<\/strong> into <strong>Control Flow<\/strong> and open it.\n<div id=\"attachment_11784\" style=\"width: 485px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11784\" class=\"size-full wp-image-11784\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\" alt=\"\" width=\"475\" height=\"178\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png 475w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow-300x112.png 300w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/><\/a><p id=\"caption-attachment-11784\" class=\"wp-caption-text\">Drag and drop Data Flow<\/p><\/div><\/li>\n<li>In <strong>Data Flow<\/strong>, drag and drop <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\" target=\"_blank\" rel=\"noopener\"><strong>ZS JSON Source<\/strong><\/a>.\n<div id=\"attachment_11533\" style=\"width: 553px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11533\" class=\"size-full wp-image-11533\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\" alt=\"\" width=\"543\" height=\"146\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png 543w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag-300x81.png 300w\" sizes=\"(max-width: 543px) 100vw, 543px\" \/><\/a><p id=\"caption-attachment-11533\" class=\"wp-caption-text\">SSIS JSON Source &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Open the JSON Source editor and enable <strong>Use credentials<\/strong>.<\/li>\n<li>Select the Hivebrite OAuth2 connection you created.<\/li>\n<li>Set the API URL using your community&#8217;s API host. Example to extract members:\n<pre class=\"lang:default decode:true\">https:\/\/{your-community}.hivebrite.com\/admin\/v4\/members<\/pre>\n<\/li>\n<li>Set <strong>HTTP Request Method<\/strong> to <strong>GET<\/strong>.<\/li>\n<li>Add the following <strong>HTTP Header<\/strong>:\n<ul>\n<li><strong>Accept:<\/strong> application\/json<\/li>\n<\/ul>\n<\/li>\n<li>Set <strong>JSON Path Filter<\/strong> to <code>$.data[*]<\/code> \u2014 Hivebrite wraps all collection responses under an <code>data<\/code> array.<\/li>\n<li>Click <strong>Preview<\/strong> to confirm rows are returned, then click <strong>OK<\/strong>.\n<div id=\"attachment_12403\" style=\"width: 946px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-JSON-source-example.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12403\" class=\"size-full wp-image-12403\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-JSON-source-example.png\" alt=\"\" width=\"936\" height=\"844\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-JSON-source-example.png 936w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-JSON-source-example-300x271.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-JSON-source-example-768x693.png 768w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/a><p id=\"caption-attachment-12403\" class=\"wp-caption-text\">Hivebrite &#8211; JSON source example<\/p><\/div><\/li>\n<\/ol>\n<h3>Configure destination component<\/h3>\n<ol>\n<li>Add an <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-upsert-destination\/\" target=\"_blank\" rel=\"noopener\"><strong>Upsert destination<\/strong><\/a> (or another destination of your choice, such as a <strong>Trash destination<\/strong> or <strong>JSON\/CSV\/XML destination<\/strong>).<\/li>\n<li>Connect the output arrow from JSON Source to the destination component.<\/li>\n<li>Configure your SQL Server connection and target table.<\/li>\n<li>Check the options you want to use: <strong>Insert<\/strong> or\/and <strong>Update<\/strong>.<\/li>\n<li>Map the source columns to destination columns in the <strong>Mappings<\/strong> section.\n<div id=\"attachment_11912\" style=\"width: 968px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11912\" class=\"wp-image-11912 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png\" alt=\"\" width=\"958\" height=\"645\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png 958w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example-300x202.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example-768x517.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example-272x182.png 272w\" sizes=\"(max-width: 958px) 100vw, 958px\" \/><\/a><p id=\"caption-attachment-11912\" class=\"wp-caption-text\">Hivebrite &#8211; Upsert destination<\/p><\/div><\/li>\n<li>Click <strong>OK<\/strong> and execute the package.<\/li>\n<li>Validate that Hivebrite rows have been loaded into your SQL Server table.\n<div id=\"attachment_12241\" style=\"width: 345px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Upsert-Destination-example.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12241\" class=\"size-full wp-image-12241\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Upsert-Destination-example.png\" alt=\"\" width=\"335\" height=\"236\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Upsert-Destination-example.png 335w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Upsert-Destination-example-300x211.png 300w\" sizes=\"(max-width: 335px) 100vw, 335px\" \/><\/a><p id=\"caption-attachment-12241\" class=\"wp-caption-text\">Hivebrite &#8211; Upsert Destination example<\/p><\/div><\/li>\n<\/ol>\n<p><!-- Conclusion --><\/p>\n<h2>Conclusion<\/h2>\n<p class=\"intro-text\">You now have a repeatable SSIS pattern to extract Hivebrite API data and load it into SQL Server by using ZappySys SSIS PowerPack. With OAuth2 Client Credentials authentication, proper pagination, and column mapping, you can operationalize Hivebrite data for BI and reporting workflows.<\/p>\n<p class=\"intro-text\">Explore the full capabilities of the <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">ZappySys SSIS PowerPack<\/a> to extend this setup with advanced transformations, retry logic, auditing, and scheduling through SQL Server Agent.<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-12354\"><h3>Need Help?<\/h3><p class=\"section-intro\">If you encounter any issues, our support team is here to help:<\/p>\r\n\r\n<ol>\r\n \t<li><strong>Live Chat:<\/strong>\u00a0Open the chat widget\u00a0<em>(bottom right of this page)<\/em><\/li>\r\n \t<li><strong>Email:<\/strong>\u00a0<a href=\"mailto:support@zappysys.com\">support@zappysys.com<\/a><\/li>\r\n \t<li><strong>Support Center:<\/strong>\u00a0<a href=\"https:\/\/zappysys.com\/support\/\">Support | ZappySys<\/a><\/li>\r\n<\/ol><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Hivebrite is a community management platform used for memberships, events, directories, and engagement workflows. Many teams need Hivebrite data in SQL Server for reporting, segmentation, and operational analytics. In this tutorial, you will learn how to connect Hivebrite API data to SQL Server Integration Services (SSIS) by using ZappySys SSIS PowerPack. You can then [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":12406,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>SSIS Tutorial: How to get data from Hivebrite | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS Tutorial: How to get data from Hivebrite - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SSIS Tutorial: How to get data from Hivebrite | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS Tutorial: How to get data from Hivebrite - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-08-14T00:09:11+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg\" \/>\r\n\t<meta property=\"og:image:width\" content=\"447\" \/>\r\n\t<meta property=\"og:image:height\" content=\"447\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/\",\"name\":\"SSIS Tutorial: How to get data from Hivebrite | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg\",\"datePublished\":\"2026-08-14T00:09:11+00:00\",\"dateModified\":\"2026-08-14T00:09:11+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS Tutorial: How to get data from Hivebrite - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg\",\"width\":447,\"height\":447},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS Tutorial: How to get data from Hivebrite\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS Tutorial: How to get data from Hivebrite | ZappySys Blog","description":"SSIS Tutorial: How to get data from Hivebrite - ZappySys Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/","og_locale":"en_US","og_type":"article","og_title":"SSIS Tutorial: How to get data from Hivebrite | ZappySys Blog","og_description":"SSIS Tutorial: How to get data from Hivebrite - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/","og_site_name":"ZappySys Blog","article_published_time":"2026-08-14T00:09:11+00:00","og_image":[{"width":447,"height":447,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg","type":"image\/jpeg"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/","name":"SSIS Tutorial: How to get data from Hivebrite | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg","datePublished":"2026-08-14T00:09:11+00:00","dateModified":"2026-08-14T00:09:11+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS Tutorial: How to get data from Hivebrite - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg","width":447,"height":447},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-hivebrite\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS Tutorial: How to get data from Hivebrite"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12398"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=12398"}],"version-history":[{"count":2,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12398\/revisions"}],"predecessor-version":[{"id":12408,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12398\/revisions\/12408"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/12406"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=12398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=12398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=12398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}