Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Cloud to Cloud ETL

Posted by Dylan Wan on January 16, 2015

I found that Cloud to Cloud ETL is different from the regular ETL running in the on premise env in several ways:

1. Direct Database Access is not available

2. Complex / Nested Objects

3. Paging

4. Volume Restriction

5. File base approach

6. Data Streaming

7. Data Security / Protection

8. Change data capture

9. Translation / System Data Availability

10. Metadata Reverse Engineering

11. API / Interface versioning

12. Frequency of the update / patching

13. Provisioning

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s