Exchange (v2): Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(Created page with "=Overview= The "Exchange (NEW)" connector is based on a driver from https://www.cdata.com/. Helpful documentation for using the "Exchange (NEW)" connector can be found here:...")
 
No edit summary
Line 7: Line 7:


==Additional Connection String Parameters==
==Additional Connection String Parameters==
I'm unsure what all can go in this field, but if you need the Body of emails, and possibly other entities, you will want to put "Include Content=true;" into this field.
I'm unsure what all can go in this field.  Here are a couple of items.
 
{|
!Parameter
!Description
|-
|Include Content=true;
|Includes the Body of emails in the results.
|-
|Auth Scheme=NTLM;
|Uses the NTLM Auth Scheme.
|}


==SQL Selection Statement==
==SQL Selection Statement==
Use the Query Builder... hyperlink on the right to build your initial queries.  Check out the CData documentation select page for more information about writing queries, http://cdn.cdata.com/help/CEC/ado/pg_select.htm.
Use the Query Builder... hyperlink on the right to build your initial queries.  Check out the CData documentation select page for more information about writing queries, http://cdn.cdata.com/help/CEC/ado/pg_select.htm.

Revision as of 21:36, 19 January 2018

Overview

The "Exchange (NEW)" connector is based on a driver from https://www.cdata.com/. Helpful documentation for using the "Exchange (NEW)" connector can be found here: http://cdn.cdata.com/help/CEC/ado/pg_alltables.htm.

Origin

Web Service URL

If you are using Office 365 for your Exchange server, then your Web Service URL is https://mail.office365.com/ews/exchange.asmx. If you are hosting Exchange yourself or using another cloud provider, then your URL will look slightly different but will still likely end with exhcange.asmx.

Additional Connection String Parameters

I'm unsure what all can go in this field. Here are a couple of items.

Parameter Description
Include Content=true; Includes the Body of emails in the results.
Auth Scheme=NTLM; Uses the NTLM Auth Scheme.

SQL Selection Statement

Use the Query Builder... hyperlink on the right to build your initial queries. Check out the CData documentation select page for more information about writing queries, http://cdn.cdata.com/help/CEC/ado/pg_select.htm.