Recent Content
Top 5 SnapLogic Job Opportunities This Week
Data Governance Analyst - Nightwing https://lnkd.in/gpTm_zQu Principal Data and Integration Engineer - Magellan Health https://lnkd.in/gQnpdxw2 Director, CRM systems and Integrations - LiveRamp - https://lnkd.in/gnkjsRV8 Integrations Analyst - The Cheesecake Factory - https://lnkd.in/giUCnvPC Senior Enterprise Data Architect - CBRE - https://lnkd.in/g8xmFahqQ and A with Kalyan Venkat: Timely Metrics from Varied Applications While Meeting Audit Requirements
What were the underlying reasons for the need of data? Need accurate & timely operational and strategic key business metrics from varied applications - has been challenging using multiple ETL tools, data refresh schedules, and data integration points Describe your data strategy and how you executed the strategy. The design focuses on building patterns where 80% of data movement between Source (applications) objects and Target objects– Az Cloud Datalake is tied to executing patterns in SnapLogic. The pattern approach eliminates significant development and testing effort required towards new and updated data from source systems. The use of patterns in data movements allows for well thought of design that is required to trigger data movement only on those pattern certified objects. The data fetch process within a pattern is also designed to be codeless meaning like to like attributes between source and are dynamically mapped in the pipeline – this eliminates need to manage and maintain coding required toward querying data from source and updating target system. Example: one of the enterprise applications has 350+ tables that requires to be updated in Azure Cloud Datalake - instead of developing one to one - 350+ SnapPipelines - using a pattern framework significantly expedited development and delivery schedule - in total there were just 45 Pipelines to address Data refresh both Delta and Full load to Az Cloud Datalake. Comparing with legacy ETL solution that required One to One workflow for each source and target table refresh. Who was and how were they involved in building out the solution? We leveraged SnapLogic offshore Snap Development resources (2) and Internal (1) FTE to deliver Az BigData Solution What were the business results after achieving this data strategy? Using SnapLogic truly expedited design, build and deliver data solutions and met business needs timely. The ability to integrate data from 13+ systems (Enterprise Apps, Cloud Apps, Third-Party SAAS data and list goes on) - most importantly key data metrics are captured during Pipeline Execution, Data Orchestration, Data Ingestion and Post Process Certification - this is a key requirement from Internal Audit to ensure Data Integrity is not compromised Anything else you would like to add? So far we have deployed over 3000+ Snap Pipelines in production and at most we allocated a half hour per week to review any exceptions during Pipeline processing in production. This clearly demonstrates the strength of SnapLogic as a product to move tons of data between source and target and by applying well thought out design ahead greatly benefits towards building robust, and flexible Snap pipelinesWhat is the Integration Nation
1 MIN READ Community is more than just an online platform. It is the coming together of people with a shared interest to discuss common use cases, find solutions, and grow their expertise. At the same time, recognition of customers and individuals that go above and beyond helps develop leaders in an industry. This article describes the Integration Nation, SnapLogic's new community program.Worcester Polytechnic Institute: Data Integration Engineer III, Worcester, MA
Worcester Polytechnic Institute - WPI has an opening for a Data Integration Engineer III role Reporting to the Assistant Director of Integration Services and Data management, the Data Integration Engineer III will be responsible for analyzing, designing, developing, and implementing robust and scalable integrations. This position supports all integration and data management-related services. They will also be a key contributor in maintaining and enhancing the Identity management solution. See the job posting for more information.ANSYS: Senior Integrations Platform Engineer - REMOTE
ANSYS posted the following in the SnapLogic Developers LinkedIn group: ANSYS is hiring! Are you a platform engineering expert with a focus on batch integration work? ANSYS is seeking a Senior Integrations Platform Engineer with hashtag hashtag#AzureDataFactory and/or hashtag hashtag#AzureLogicApps experience, as well as proficiency in ETL tools hashtag hashtag#Boomi, hashtag hashtag#SnapLogic or hashtag hashtag#Informatica. If this sounds like you, check out the full job description below and apply! **Please note, this position is specific to batch integrations. Data Warehouse professionals need not apply. Apply now at https://lnkd.in/eNdfEKyXCommunity Guidelines
Last updated May 31, 2023 This is a Civilized Place for Public Discussion Please treat this discussion forum with the same respect you would a public park. We, too, are a shared community resource — a place to share skills, knowledge and interests through ongoing conversation. These are not hard and fast rules, merely aids to the human judgment of our community. Use these guidelines to keep this a clean, well-lighted place for civilized public discourse. Improve the Discussion Help us make this a great place for discussion by always working to improve the discussion in some way, however small. If you are not sure your post adds to the conversation, think over what you want to say and try again later. The topics discussed here matter to us, and we want you to act as if they matter to you, too. Be respectful of the topics and the people discussing them, even if you disagree with some of what is being said. One way to improve the discussion is by discovering ones that are already happening. Please spend some time browsing the topics here before replying or starting your own, and you’ll have a better chance of meeting others who share your interests. Be Agreeable, Even When You Disagree You may wish to respond to something by disagreeing with it. That’s fine. But, remember to criticize ideas, not people. Please avoid: Name-calling. Ad hominem attacks. Responding to a post’s tone instead of its actual content. Knee-jerk contradiction. Instead, provide reasoned counter-arguments that improve the conversation. Your Participation Counts The conversations we have here set the tone for everyone. Help us influence the future of this community by choosing to engage in discussions that make this forum an interesting place to be — and avoiding those that do not. This platform provides tools that enable the community to collectively identify the best (and worst) contributions: favorites, bookmarks, likes, flags, replies, edits, and so forth. Use these tools to improve your own experience, and everyone else’s, too. Let’s try to leave our park better than we found it. If You See a Problem, Flag It Moderators have special authority; they are responsible for this forum. But so are you. With your help, moderators can be community facilitators, not just janitors or police. When you see bad behavior, don’t reply. It encourages the bad behavior by acknowledging it, consumes your energy, and wastes everyone’s time. Just flag it. If enough flags accrue, action will be taken, either automatically or by moderator intervention. If something needs immediate attention, DM the Community Manager ( dmiller ) or email community@snaplogic.com. Where possible, please include a direct link to the violation and/or a screenshot. In order to maintain our community, moderators reserve the right to remove any content and any user account for any reason at any time. Moderators do not preview new posts in any way; the moderators and site operators take no responsibility for any content posted by the community. Always Be Civil Nothing sabotages a healthy conversation like rudeness: Be civil. Don’t post anything that a reasonable person would consider offensive, abusive, or hate speech. Keep it clean. Don’t post anything obscene or sexually explicit. Respect each other. Don’t harass or grief anyone (publicly or privately), impersonate people, or expose their private information. Respect our forum. Don’t post spam or otherwise vandalize the forum. These are not concrete terms with precise definitions — avoid even the appearance of any of these things. If you’re unsure, ask yourself how you would feel if your post was featured on the front page of the New York Times. This is a public forum, and search engines index these discussions. Keep the language, links, and images safe for family and friends. Keep It Tidy Make the effort to put things in the right place, so that we can spend more time discussing and less cleaning up. So: Don’t start a topic in the wrong category. Don’t cross-post the same thing in multiple topics. Don’t post no-content replies. Don’t divert a topic by changing it midstream. Don’t sign your posts — every post has your profile information attached to it. Rather than posting “+1” or “Agreed”, use the Kudos button and accept solutions. Rather than taking an existing topic in a radically different direction, use Reply as a linked topic. Post Only Your Own Stuff You may not post anything digital that belongs to someone else without permission. You may not post descriptions of, links to, or methods for stealing someone’s intellectual property (software, video, audio, images), or for breaking any other law. Don't post anything that would violate any contractual agreements (i.e., copyright, trade secrets, patents, etc.) or nondisclosure agreements to which you or your organization are a party. Powered by You This site is operated by your friendly local staff and you, the community. If you have any further questions about how things should work here, open a new topic in the Community Exchange category and let’s discuss! If there’s a critical or urgent issue that can’t be handled by a meta topic or flag, contact a community Admin. Terms of Service Yes, legalese is boring, but we must protect ourselves – and by extension, you and your data – against unfriendly folks. We have a SnapLogic Community Terms of Service describing your (and our) behavior and rights related to content, privacy, and laws. To use this service, you must agree to abide by our Terms of Service .Hampshire Trust Bank: Building a More Agile Financial Services Organization
2022 Business Impact Award Nomination Submitted by ⋮IWConnect on behalf of Hampshire Trust Bank. What were the underlying reasons or business implications for the need to automate business processes? As a UK-based specialist bank focused on providing asset finance, specialist mortgages, and development finance solutions, Hampshire Trust Bank (HTB) is continuously innovating and implementing sophisticated solutions to optimize internal business processes. These processes range from Business Intelligence (BI) and reporting to screening and payments integrations. HTB has a clear strategy of acquiring best-of-breed applications to maximize business efficiency and value with new systems that share data and processes within the existing software ecosystem. Each system has its own technology stack on one side and data formats on the other. As a result of this difference, data interoperability became one of the main challenges affecting HTB operational efficiency. Furthermore, considering that data contains personally identifiable information, it required cryptography solutions such as X509 and PGP to be implemented. Once data has been consolidated, screening and monitoring processes are orchestrated to ensure data validity. Paramount among HTB’s concerns were to: support the increased processing of payment transactions per month improve the process of data screening to ensure data validity become more agile and increase customer satisfaction With process resilience of critical importance for any financial services organization, SnapLogic was used to move workload between data centers or strategically use the cloud depending on availability and requirements. Describe your automation use case(s) and business process(es). Use Cases Integration of payments, general ledger, direct debit, and direct credit transactions from asset finance software Alfa to internal and external payment systems Integration of more than 100 reports from Alfa into HTB’s data warehouse Integration of Finova Core Banking Platform’s processes for retail savings customers Risk and fraud detection with implementation of transactions screening with Comply Advantage Business Processes Fully automated processes for customer and employee screening Payments integration with Bottomline and other external providers Consolidation of data into a unified Snowflake Data warehouse for advanced BI analysis and reporting Describe how you implemented your automations and processes. Planning, defining and documenting The process starts by defining the business flow, requirements, and edge cases. Once these things have been defined, the design is documented in detail. A team of business users and technical experts reviews the documentation and approves the design. Implementation The implementation of automation starts by creating pipelines and other assets such as parameterizations or storage locations. Pipelines are executed as Scheduled, Triggered and Ultra tasks. JMS consumers in asynchronous mode are used to read messages from message queues. REST Snaps are used to read data and execute processes for REST endpoints. PGP Snaps are used for cryptography operations, and Script Snap is used for custom cryptographic operations. Data is transformed with a combination of mapper snaps. Results are written into various destination file systems by using File Writer Snaps. Log messages are produced and transferred to Splunk. JIRA tickets are automatically created by using JIRA Create Snap in the case of exceptions. Additionally, email messages and xMatters alerts are sent to the users. Expression libraries are used extensively to parametrize configurations across multiple staging environments. Once the development is complete, the detailed quality assurance process on multiple environments starts before the solution is finally deployed in the production environment. What were the business results after executing the strategy? Integrations combined with specialized banking systems allow the processes to complete faster, more efficiently and with fewer errors across all those systems, dramatically optimizing business processes. Currently, there are more than 50 different systems and apps automated and interoperable in production. By using SnapLogic automations, HTB can support the increased demand and process tens of thousands of payment transactions per month, as well as thousands of screening operations each month. There are tens of thousands of pipeline executions that result in millions of documents every day. Automation plays a key role in both digital transformation and developing a more agile business. Team members can now focus on higher-priority tasks such as strategy, security and customer relationship management. Who was and how were they involved in building out the solution? The solutions were built by a team composed of internal domain experts, consultants from the external systems, architects, integrators and Quality Assurance professionals. Five FTEs were engaged in the projects. In a relationship that lasts three years, ⋮IWConnect acts as the integration implementation partner and assists in the implementation of multiple projects, each lasting from three to 12 months.Skidmore College: Rebuilding Identity Management System with Oracle HCM Cloud
2022 Business Impact Award Nomination Describe your business and technical use case(s) and the challenges the business had. Skidmore was migrating from Oracle Ebiz on-premise to Oracle HCM cloud at the same time changing our Identity Mgmt system to Okta. All of this occurirng during the pandemic, with staff fully remote and in some cases furloughed. We needed to rebuild our entire Identity Mgmt system from the ground up with the new Oracle HCM system and Okta. Snaplogic became the integration hub for all of this work. In less than a year, we rebuilt our IDM system to work with the new Oracle HCM, Ellucian Banner, Okta and Active Directory. Allowing both employees and students to on board quickly access to all of the applications they needed across the organization Describe your strategy and execution to solve the business challenge. We created a database middle layer to store all the IDM information required for all users and built out pipelines within Snaplogic to handle near real time processing of user on and off boarding across the organization. Who was and how were they involved in building out the solution? We had 5-6 staff members working on this solution from start to finish. What were the business results after executing the strategy? Skidmore was able to remove the reliance on a 3rd party black box IDM platform and bring it in house. We also rolled out new features to allow users to pick from a list of potential usernames/emails including the use of “preferred first initial”. What was the ROI you gained from executing the strategy? Full transparency into user provisioning. Cut 3rd party IDM system which was about 50k per year Skidmore_Snaplogic.pptx (1.0 MB)
