ElasticSearch Connector
Documentation
Version: 3
Documentation
Home » API Integration Hub » ElasticSearch Connector » In SSIS > Getting Started

Using ElasticSearch Connector in SSIS

To use ElasticSearch Connector you will have to download & install SSIS PowerPack. There are two versions of SSIS PowerPack to download: TRIAL and FULL:

Download SSIS PowerPack

Download TRIAL VERSION if you are trying it out (30-days fully functional product).

or

Download FULL VERSION if you already have purchased the product.

Install SSIS PowerPack

By installing SSIS PowerPack you will install ZappySys SSIS Tasks and Components. Installing SSIS PowerPack is pretty straightforward. Installing a TYPICAL version will install components required for each version of SQL Server.

Video Tutorial - Read ElasticSearch data

This video covers following and more so watch carefully. After watching this video follow the steps described in this article.

  • How to download SSIS PowerPack for ElasticSearch integration
  • How to configure connection for ElasticSearch
  • How to Read data from ElasticSearch
  • Features about SSIS API Source
  • Using ElasticSearch Connector

How to find installed SSIS Tasks/Components?

After installation, new ZappySys SSIS tasks/components will appear under SSIS toolbox, when using from within Control Flow and Data Flow. Check in both places and verify that new components are present.

  1. Open Visual Studio (i.e. SSDT or SQL Server Data Tools)
  2. Open existing SSIS Project or Create new by clicking on Project > Business Intelligence > Integration Services Project
  3. Once SSIS Package Designer is open, Click on the Control Flow Tab and locate SSIS Toolbox. If toolbox is hidden then right click in the blank designer surface area and click SSIS Toolbox menu item
  4. Check SSIS Toolbox. Any items starting with ZS are ZappySys SSIS PowerPack Tasks
  5. Do the same thing to find Data Flow Components
  6. Click on Data Flow Tab and you will see SSIS Toolbox will refresh. Any items starting with ZS are ZappySys SSIS PowerPack Components
  7. To use them, simply drag and drop ZappySys SSIS PowerPack connectors into the workspace
ssis-toolbox-where-is-control-flow-task-data-flow-components.png

What if SSIS PowerPack connectors are not visible

If connectors are not visible, then try following the steps described in this page: What should I do if I don't see ZappySys SSIS PowerPack connectors in SSIS toolbox in Visual Studio.

Conclusion

Once you have installed SSIS PowerPack you are ready to use ElasticSearch Connector. To see how to start using it check the next section -- Read from ElasticSearch