This week, the SnapLogic team will be supporting one of our partners, Amazon Web Services, in Las Vegas for the annual AWS re:Invent conference. This gathering of the global AWS community will feature hands-on labs and bootcamps and cover topics such as infrastructure maintenance, and improving developer productivity, network security and application performance.
Are you currently using Amazon Web Services and struggling to find the right integration solution to connect the platform with other cloud and on-premises applications and data sources? Adopting AWS Redshift and looking for a modern data integration solution? If so, check out this demonstration of SnapLogic for AWS.
If you’re attending this Thursday’s AWS Summit in New York and are interested in data warehousing and data integration, come say hi to the SnapLogic team! You can find us at booth #332 where we’ll be talking Redshift integration in the elastic enterprise (and how you can get started with our free trial for Amazon Redshift). We’ll also be showing demonsrations of the SnapLogic Elastic Integration Platform in action.
For those not as familiar with Amazon Redshift, it is a fast, fully managed petabyte-scale data warehouse service offered at one tenth the price of most traditional warehouse solutions. SnapLogic’s Amazon Redshift integration solution enables customers to transfer data into and out of Amazon Redshift – also at a fraction of the cost of traditional solutions. With SnapLogic, data can be moved at any latency (batch, streamed, or via event-based real-time triggers) to meet the requirements of a diverse set of users. Additionally, SnapLogic offers pre-built connectors, called Snaps, to over 160+ different data sources including on-premises applications like traditional ERP and financial applications to social media, mobile and machine data. The goal is to easily and rapidly extract data from its various sources and formats and load it into Amazon Redshift and keep data synchronized with other systems at a significant cost savings for the customer.
We also offer Snap Patterns for Amazon Redshift, allowing organizations to rapidly load and synchronize data from sources such as Oracle, MySQL, SQL Server and PostgreSQL directly into Redshift. The Redshift Snap Patterns are ideal for organizations considering Redshift as a low-cost, faster alternative to traditional data warehousing, and include:
- Data Loading: Accelerate the initial data load or refresh.
- Periodic Data Sync: Determine the frequency of delta data synchronization.
- Data Aggregation: Bring data together from multiple sources for the purposes of cloud data warehousing.
- Slowly Changing Dimension Type 2 (SCD2): Handle powerful transformation tasks with a few clicks.
Full AWS Summit event registration is closed but you can register for the Keynote Live Stream here to tune in. And here are a few options if you can’t make it, but want to see the SnapLogic Elastic Integration Platform in action:
- SnapLogic Amazon free trial demonstration – no on-premises software required with SnapLogic!
- Comprehensive demonstration of SnapLogic focused on Redshift integration (from our cloud analytics webinar)
For a general AWS Redshift and SnapLogic overview as well as best practices from our partner Cervello, I’ve embedded the slides from a recent webinar we hosted below. See you in NYC!
We’re always coming out with new Snaps, which are the building blocks of a SnapLogic pipeline. Snaps perform a single function such as read, write, or acting on data. They are found in the Snap catalog, accessible on the left hand side of Designer. Simply drag a Snap from the Snap catalog onto the workspace to use it in a pipeline, which is a data flow. Snaps are classified as either Core Snaps, meaning that they are available to all customers, or by the Snap Pack for particular applications, technologies or utilities. We also have a Snap SDK for customers and partners to build their own custom Snaps.
Application and Database Snaps
Here is a list of Snap Packs from A-Z. Note that this list is always growing as we introduce new Snaps every few weeks. Each Snap Pack contains many Snaps. For example, here’s a screenshot of what’s in the Active Directory Snap, which was released in May 2014.
- Active Directory
- AWS (Account Creation, EMR Executor, Hive Executor)
- AWS Redshift
- Google Analytics
- Google DFA
- Google Directory
- Microsoft Dynamics AX
- Microsoft Exchange
- Microsoft SQL Server
- Oracle RDBMS
- Oracle EBS
- Hadoop (HDFS Reader and Writer)
Core Snaps are available to all customers with the SnapLogic Elastic Integration Platform. They include the following Snap Packs: Binary, Email, Fixed Width, Flow, REST, Script, SOAP, Transform and XML. Here are examples of Core XML Snaps in the Snap Pack:
Here are examples of SnapLogic Transform Snaps:
For more information on SnapLogic Snaps, be sure to visit our SnapStore and you can learn more about the key concepts in this post. Here’s a demonstration of the SnapLogic Elastic Integration Platform in action to help you get a better understanding of Snaps, Pipelines, Patterns as well as our Monitoring Dashboards.
A hot topic of conversation for us lately has been next-generation cloud analytics and business intelligence (BI), which we addressed recently in How a Modern Approach to Analytics Drives Success in the Enterprise with the help of expert Howard Dresner and SnapLogic partner Tidemark. We also spent some time with the Boulder BI Brain Trust (#BBBT) discussing integration platform as a service (iPaaS) and some our recent cloud integration and analytics survey results.
This week, we hosted a webinar focused on best practices for supercharging cloud analytics, specifically with Amazon Redshift. While Amazon Redshift offers a phenomenal low-cost offering for petabyte scale analytics in the cloud, the secret sauce to customers’ business analytics strategies still remains rooted on the approach, methodologies and the amount of data incorporated into this critical exercise. On the webinar, we discussed best practices for supercharging cloud analytics initiatives, as well as tips and tricks on designing the right information architecture, data models and other tactical optimizations.
Along with SnapLogic’s Senior Director of Product Marketing Maneesh Joshi, we were joined by Tina Adams, a Senior Product Manager from AWS and Brandon Davis of Cervello. Topics discussed included:
- The latest Amazon Redshift feature enhancements
- How the SnapLogic Elastic Integration Platform can speed up your time to value
- Case studies and implementation best practices from experienced practitioners
We’d like to thank our partners from AWS and Cervello for participating in an extremely informative webinar. It was a great opportunity for information and/or integration architects, data warehouse practitioners, systems integrators and BI practitioners to hear more about what can be done with Amazon Redshift and the important role played by fast, multi-point and modern data integration technology. If you’d like to find out how SnapLogic can power your AWS Redshift initiative, be sure to check out our free cloud data integration trial for Amazon Redshift. As Terry Wise of AWS commented when we announced our new Snap Patterns and the Redshift trial, “With SnapLogic’s Integration platform, Amazon Redshift customers can pull massive volumes of data from multiple sources into Amazon Redshift at a fraction of the cost of a traditional data integration solution.”
If you missed the webinar, check out the recording here or get an overview of what we discussed in the slides below:
The SnapLogic team is very excited to announce our new SnapLogic Integration Cloud Free Trial for Amazon Redshift at the AWS Summit in San Francisco. Built on the the most recent innovation from SnapLogic called Snap Patterns, which are are pre-built packaged integrations that customers can configure through a step-by-step wizard, our goal is to help you accelerate your time to value with AWS Redshift by as much as 10x. There’s no coding necessary!
The free trial comes with Snap Patterns for some commonly recurring data integration requirements for Amazon Redshift that are common challenges for cloud data warehousing customers. For starters, the Redshift Loader Patterns take away the complexity of the initial load from Amazon RDS for MySQL, Oracle, SQL Server and PostgreSQL into Amazon Redshift. Users of the SnapLogic Snap Patterns can then use MicroStrategy, Qlikview, Tableau, Tidemark or other leading business intelligence (BI) tools to run analytics and visualize their data in Redshift.
Accelerate cloud data warehouse adoption with prebuilt patterns that can be configured by an automatically-generated series of steps.
Rapidly connect Amazon Redshift to a variety of relational database services including Amazon RDS for MySQL, PostgreSQL, Oracle and SQL Server.
Quickly load data into an Amazon S3 bucket and kick off the Amazon Redshift import process in a single step.
Easily replicate source tables into their Amazon Redshift clusters and detect daily changes to keep data synchronized.
Take advantage of core REST and SOAP Snaps for broader connectivity.
Visually design a variety of data operations using a set of core Snaps such as Binary, Flow, Script, Transform and XML.
Do sophisticated extract, transform and load (ETL) operations such as slowly changing dimensions type 2 (SCD2) and database lookups without any coding.
Start with a free trial of an easy to use wizard and upgrade to the full SnapLogic integration platform as a service (iPaaS) in order to connect to data from Salesforce.com, Teradata, Netezza, SAP, Oracle ERP and other systems without losing any of their existing work.
If you’re ready to get started with the trial, check out the following resources:
Building your First SnapLogic Pipeline Instructional Video to get acquainted with the broader capabilities of the platform
Additional resources are available here:
We look forward to hearing your feedback as this trial powers your cloud analytics initiatives. And if you happen to be at the AWS Summit in San Francisco today, please swing by our booth (#621) for more information!