[av_one_full first min_height=\’\’ vertical_alignment=\’av-align-top\’ space=\’\’ row_boxshadow=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’\’ margin=\’0px\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ padding=\’0px\’ column_boxshadow=\’\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight=\’\’ highlight_size=\’\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ aria_label=\’\’ av_uid=\’av-t5vcf\’ sc_version=\’1.0\’]

[av_heading heading=\’AppCan Data Warehouse\’ tag=\’h2\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’entypo-fontello\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’custom-color-heading\’ custom_font=\’#444444\’ icon_color=\’\’ margin=\’\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kn2deejk\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-kn7o03nn\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
The AppCan Data Warehouse allows you direct access to your data in the Data Warehouse (SQL database) for use with reporting systems (e.g Microsoft PowerBI)
[/av_textblock]

[av_hr class=\’custom\’ icon_select=\’no\’ icon=\’ue808\’ font=\’entypo-fontello\’ position=\’center\’ shadow=\’no-shadow\’ height=\’50\’ custom_border=\’av-border-thin\’ custom_width=\’100%\’ custom_margin_top=\’10px\’ custom_margin_bottom=\’30px\’ custom_border_color=\’\’ custom_icon_color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-kn7o0eum\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kn4eehwy\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
To configure the AppCan Data Warehouse, you will need to undertake the following:

1. Request access to the Data Warehouse via AppCan Support
2. Whitelist the IP addresses used to connect to the Data Warehouse
3. Configure which Data Collector apps you need in the Data Warehouse (if required)
4. Connecting to the Data Warehouse

[/av_textblock]

[/av_one_full][av_one_third first min_height=\’\’ vertical_alignment=\’av-align-top\’ space=\’\’ row_boxshadow=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’\’ margin=\’0px\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ padding=\’0px\’ column_boxshadow=\’\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight=\’\’ highlight_size=\’\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ aria_label=\’\’ av_uid=\’av-5pogrz\’ sc_version=\’1.0\’]
[av_heading heading=\’Configure Data Warehouse\’ tag=\’h4\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’entypo-fontello\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’custom-color-heading\’ custom_font=\’#cf2d3d\’ icon_color=\’\’ margin=\’\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kn2cxhdv\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kn2cfgwe\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
About the Data Warehouse
Whitelist IP Addresses
Configure Data Collector Apps
Connecting to the Data Warehouse
[/av_textblock]
[/av_one_third]

[av_one_third min_height=\’\’ vertical_alignment=\’av-align-top\’ space=\’\’ row_boxshadow=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’\’ margin=\’0px\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ padding=\’0px\’ column_boxshadow=\’\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight=\’\’ highlight_size=\’\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ aria_label=\’\’ av_uid=\’av-3n5n0p\’ sc_version=\’1.0\’]
[av_heading heading=\’Data Warehouse Tables\’ tag=\’h4\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’entypo-fontello\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’custom-color-heading\’ custom_font=\’#cf2d3d\’ icon_color=\’\’ margin=\’\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kn3iupiq\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-6zot5\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
Tables in the data warehouse
[/av_textblock]
[/av_one_third]

[av_one_third min_height=\’\’ vertical_alignment=\’av-align-top\’ space=\’\’ row_boxshadow=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’\’ margin=\’0px\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ padding=\’0px\’ column_boxshadow=\’\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight=\’\’ highlight_size=\’\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ aria_label=\’\’ av_uid=\’av-2n1p94\’ sc_version=\’1.0\’]
[av_heading heading=\’Data Warehouse Fields\’ tag=\’h4\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’entypo-fontello\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’custom-color-heading\’ custom_font=\’#cf2d3d\’ icon_color=\’\’ margin=\’\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kn7qtmtx\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-kn7qts5e\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
Data Collectors
Document Distributors
Alerts
Global Data Fields
Users
[/av_textblock]
[/av_one_third]