Subject: UltraCart - Data Warehouse (Google BigQuery)
From: UltraCart Support Team <[email-masked]>
To: Deeksha Dadu <[email-masked]>
Date: Mon, 27 Jul 2020 13:06:09 +0000

Quickly setup and manage large amounts of customer, item, order and auto order
data using UltraCarts Big Data features!

Data Warehouse(Google BigQuery)

What is a Data Warehouse?

A data warehouse is an enterprise grade system that is used for reporting and
data analysis as a core component of business intelligence. Data warehouses are
the central repositories where data from one or more different sources are
brought together for analysis.

Learn More (
?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6
)

Working with a large historical data set across all our UltraCart accounts, the
UltraCart integration with Google Big Query allows us complete freedom to design
complex reporting using virtually any modern BI tool. Because BigQuery is
designed as a massive scale data warehouse our monthly costs are less than $15
when working with records across all our UltraCart accounts.

Chris G. - Meliorra Brands

Good fit for you?

UltraCart Data Warehouse allows you to quickly create a data warehouse of
customers, items, orders and auto order information with Google BigQuery. It can
be used to feed support systems, write reports, and sync with other data systems
for operational analysis.

Documentation ( https://ultracart.atlassian.net/wiki/spaces/ucdoc/pages/1377822/USPS+Configuration?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 )

What is BigQuery?

BigQuery is an enterprise data warehouse that simplifies data analysis by
enabling easy-to-write, superfast queries using the processing power of Google's
infrastructure. Simply move your data into BigQuery and let Google handle the
hard work. 

Learn More ( https://ultracart.atlassian.net/wiki/spaces/ucdoc/pages/1377822/USPS+Configuration?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 )

Step 1Google Cloud Configuration

Get started by creating a project within Google Cloud. Set up Google BigQuery, a
Cloud Storage bucket and a service account with proper permissions.

Google Cloud Config Docs ( https://ultracart.atlassian.net/wiki/spaces/ucdoc/pages/994705409/Data+Warehouse+BigQuery#Google-Cloud-Configuration?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 )

Step 2UltraCart Configuration

Connect your BigQuery dataset, Cloud Storage bucket and assign your tables, then
activate the feature in UltraCart and you're good to go!

UltraCart Set Up Docs ( https://ultracart.atlassian.net/wiki/spaces/ucdoc/pages/775061505/Setting+up+DHL?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 )

How does UltraCart Data Warehouse work?

UltraCart keeps your data warehouse fresh with the latest changes using secure
communication with your Google Cloud project.

What UltraCart plans support it?

At this time, only large and enterprise plans support this feature.

What does UltraCart Data Warehouse cost?

Free with your large or enterprise plan!

What data does UltraCart Data Warehouse support?

At this time, the objects that are pushed into your data warehouse are:

* Orders
* Auto orders
* Customers
* Items

More FAQ ( https://ultracart.atlassian.net/wiki/spaces/ucdoc/pages/994705409/Data+Warehouse+BigQuery#FAQ?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 )

Pro Services

Need some help getting started? UltraCart can help you get up and running
quickly. We're here to assist you with general account information, payment
processing configuration, StoreFront set up, basic shipping set up, and more.

Contact Pro Services ( https://www.ultracart.com/help/pro-services.html?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 )

| Home ( https://www.ultracart.com?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 ) | Login ( https://secure.ultracart.com?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 ) | Docs ( https://docs.ultracart.com?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 ) | Support (
[email-masked]?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6
) |

Copyright © 2020 UltraCart, All rights reserved.

No longer want to receive these emails? You can unsubscribe here ( https://marketing.ultracart.com/checkout/unsubscribeLoad.do?espCommseqUuid=90c4e5e6-4eab-43b7-a278-521452be95a7&espCommseqStepUuid=6427ffec-62c5-4170-96e5-95c7fbdd2490&espCommseqEmailUuid=85b6addb-b640-46f9-a91f-e1fa929dee8a&espCustomerUuid=c74e4fad-38be-43f0-9e32-d0dc24e764d6&utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Processing+Big+Data&utm_content=85b6addb-b640-46f9-a91f-e1fa929dee8a%7C6427ffec-62c5-4170-96e5-95c7fbdd2490%7C90c4e5e6-4eab-43b7-a278-521452be95a7%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 ).

ultracart.com - , Merced, CA 95340