As a geek turned marketer, my goal is to provide high-value technical content to my fellow data geeks. To better understand them, we started with our corporate data warehouse (EDW) and data management platform (DMP), but it was missing a lot of detailed data.
In addition to that, insights are fragmented across many different systems. Just thinking about a schema and the right questions to ask made my head spin.
So we decided to build a data lake for more flexibility in asking any questions with an ad hoc schema or read approach, against any customer data sets to better understand what our audience wants to consume. We also wanted a foundation for new and advanced analytics techniques against data sets we have yet to derive value from.
Check out this article to find out how I did it, along with all the good and not-so-good results, including some of the things we’re now able to analyze, such as best target audience, lead routing effectiveness and popular data connectivity scenarios.
If you’re going to Oracle’s Modern Customer Experience event on April 26 in Las Vegas, don’t miss my presentation on this same topic: Journey to Marketing Data Lake.
I’ll be discussing how we leveraged standard SQL (JDBC) and REST (OData) interfaces for simple, secure access to cloud marketing data for the data lake, such as Salesforce, Oracle Service Cloud, Eloqua, Marketo and Google Analytics.
READ THE FULL ARTICLE
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.