Archive for the ‘Project Management’ category

KSA Higher Customs Duty June 2020

June 29th, 2020

The Kingdom of Saudi Arabia (KSA) has published the new list of goods on which higher customs duty rates which are effective from 20 June 2020.

Earlier the Customs duty increased was supposed to be effective from 10 June 2020.

Further, in view of the VAT rate increase to be effective 1st July 2020, it is recommended for the businesses operating in KSA to do an impact assessment to identify the impact of VAT and Customs duty increase on their business.

KSA VAT changes 1 July 2020

June 29th, 2020

The Government of the Kingdom of Saudi Arabia (KSA)announced that the Value Added Tax (VAT) rate will increase to 15% from the current 5%, effective 1 July 2020.The increase is one theof additional measures taken by the KSA government in response to the economic impact of the COVID-19 crisis, due to the decline in government revenue resulting from lower oil prices, reduced economic activity and increased healthcare expenditure.

How could this impact your business?
In addition to the increased VAT rate, businesses in KSA should expect an increased level of scrutiny from the General Authority of Zakat and Tax (GAZT), as VAT becomes a more important source of revenue.

Businesses whose sales are partially or fully VAT exempt, will experience an increase in costs as a direct effect of the rate increase. Nevertheless, the rate increase will impact all industry sectors in KSA and not primarily the Financial Services, Insurance and Real Estate sectors. All consumers will finally bear the brunt of the increases and it is not clear whether a lower rate of VAT, may still continue to apply to such items as food and utilities, to mitigate the impact.

We advise to review existing contracts that provide for continuous or periodic supplies of goods/services, and consider the required documentation changes that should be effected before 1 July 2020. Be clear on the correct rate of VAT to charge on contracts and supplies that span both June and July 2020. As o the 2018 introduction of VAT shows, transitional rules can be difficult to implement.

The rate increase will also impact cash-flow for businesses due to the timing difference between the payment and recovery of VAT, so cash flow planning will take on renewed significance.

Review the internal systems and processes to reflect the increased VAT rate. What systems and report need update and testing when.

We remind taxpayers that the window for voluntary disclosures without incurring penalties remains open only until tomorrow 30 June 2020, he rate increase heightens the importance for businesses to ensure they are fully compliant from a VAT perspective.

Security, Agile and DevOps

June 13th, 2020

As we move to an era of no code citizen developers there is increasing risk that security remains an afterthought when organizations are building software. The latest Verizon threat report identified that web application attacks have doubled, and that cloud-based data is under attack. The surge in web app security breaches in 2019 further solidifies that ‘crowd funded’ testing is no substitute for proper QA. The whole agile /DevSecOps approach has done much to improve user feedback to developers to improve the functionality and speed to market of business solutions, but informal end user tests alone are not sufficient where security is concerned,

With the rush to embrace digital services, organizations are too often focused on the speed of release rather than on the quality of services. To accelerate the pace of digital transformation, security must be a fundamental part of software development. To develop code faster, you should also identify vulnerabilities sooner. Otherwise, you run the risk of DevOps, simply creating software with vulnerabilities, more quickly.Embed security within all aspects of your software deign and development process rather than expect it to be bolted on as an afterthought. The threat is real sophisticated and growing. Criminals also use automation and Machine intelligence to identify and to attack vulnerabilities faster.

Attackers recently hijacked powerful machine-learning clusters inside Microsoft’s Azure cloud-computing service so that they could mine cryptocurrency at the expense of the customers who rented services. The nodes, which were misconfigured by customers, made the perfect target for so-called cryptojacking schemes. Machine-learning tasks typically require vast amounts of computing resources. By redirecting thsoe to perform the compute-intensive workloads required to mine digital coins, the attackers found a means to generate large amounts of currency at little, or no cost.

The infected clusters were running Kubeflow, an open source framework for machine-learning applications in Kubernetes, which is itself an open source platform for deploying scalable applications across large numbers of computers. Microsoft said compromised clusters it discovered numbered in the “tens.” Many of those ran an image available from a public repository, apparently to save users the hassle of creating one themselves. Upon further inspection, Microsoft investigators discovered it contained code that surreptitiously mined the Monero cryptocurrency.

After finding the infected clusters, investigators turned their attention to how the machines were compromised. For security, the dashboard that allows administrators to control Kubeflow is, by default, accessible only through istio ingress, a gateway that’s typically located at the edge of the cluster network. The default setting prevents people across the Internet from accessing the dashboard and making unauthorized changes to the cluster.

This week Yossi Weizman, a security-research software engineer in the Azure Security Center, said : “We believe that some users chose to do it for convenience. Without this action, accessing the dashboard requires tunneling through the Kubernetes API server and isn’t direct. By exposing the Service to the Internet, users can access the dashboard directly. However, this operation enables insecure access to the Kubeflow dashboard, which allows anyone to perform operations in Kubeflow, including deploying new containers in the cluster.”

Once attackers have access to the dashboard, they have multiple options for deploying backdoored containers in the cluster. For instance, attackers can create what’s known as a Jupyter Notebook server that runs on the cluster. They can then place a malicious image inside of the Jupyter Notebook. If a Jupyter Notebook is already installed, it can be maliciously modified.
Weizman wrote.:” Azure Security Center has detected multiple campaigns against Kubernetes clusters in the past that have a similar access vector: an exposed service to the Internet. However, this is the first time that we have identified an attack that targets Kubeflow environments specifically.”

SnapLogic May 2020 many enhancements – ask Synergy Software Systems

May 14th, 2020

We are thrilled to announce the general availability of the May 2020 release of the SnapLogic Intelligent Integration Platform (IIP).

New Iris artificial intelligence (AI) innovations within this release allow you to build painless integrations, increase collaboration within your organization with new Stickies, and automate workflows with new SAP S/4HANA Snaps, among many more.

New Mask Snap, powered by Iris AI: Simplify data masking!

As you work with a variety of data in your dev and test environments, it is always good practice to shield and protect sensitive information. Masking sensitive or personally identifiable information such as: social security numbers (SSN), email addresses, names, street addresses, and birthdates is easy with our new Mask Snap.

With the Mask Snap, Iris AI is embedded in every step :
- suggestions on the fields you should mask,
- recommended search mode,
- recommended match mode,
- recommended masking options

You can remove or mask fields, and it works with all data types, including highly-nested JSON.

We continue to enhance our industry-leading AI technology to make it easy for you to build integrations and automations, easily and painlessly. With the new May 2020 release, as you are configuring a database or an application Snap, Iris AI now provides configuration recommendations such as schema name, object name. To provide these recommendations, Iris employs over five years of metadata information and usage patterns to intelligently determine the most commonly used schemas and objects in your organization.

From source to destination, Iris AI continues to simplify schema mappings – map even complex schemas in minutes. With the May 2020 release, Iris now provides target recommendations in Mapper for exact matches between source and destination schemas.

Boost collaboration with peers using Stickies!
SnapLogic customers who have previewed our May 2020 release have embraced our new Stickies feature with great enthusiasm. Stickies enables better collaboration and documentation of your pipeline building efforts. Stickies allow you to create and post notes on the Designer canvas to annotate different parts of the pipeline and document the workings of a pipeline in detail.
Stickies provide a great collaboration tool between IT teams, who might create pipelines, and business teams, who might want to customize and run pipelines based on their specific needs.

Stickies reside at the pipeline level, thus, they complement the Snap level ‘note’ feature already present in the platform. Additionally, Stickies are part of a pipeline’s metadata – export stickies along with your pipelines.

Deeper operational insights with Insights dashboard and task monitoring

In the May 2020 release, to provide you with trends data on operational parameters and task level insights into your SnapLogic deployment, there are significant updates to the Dashboard tab.

USe the enhanced Insights tab to improve operational efficiency with a view of historic usage and trends across key performance indicators (KPIs) such as :
- documents processed,
- pipeline executions,
-Snap executions, etc.

Filter these KPIs by specific criteria and personalize the view stohave the most relevant visualizations at the top.

The May 2020 release introduces a new tab, called ‘Task’, to provide a task level view of your SnapLogic deployment. Monitor the performance and health of your tasks and drill down into historical information to identify where certain tasks are failing or underperforming. Significantly improve your efficiency as you troubleshoot the root cause of a dip in performance or failure.

Automate your customer journey with new SAP S/4HANA Snap Pack

Another key update in the May 2020 release is the new SAP S/4HANA Snap Pack. SAP S/4HANA, is a modern enterprise resource planning (ERP) system that leverages SAP HANA, an in-memory database. Here are a few key use cases k:

- Order-to-Cash from Salesforce to SAP S/4HANA
- Real-time inventory management from databases to SAP S/4HANA
- Advanced financial planning with data from SAP S/4HANA to Anaplan
- Managing and engaging talent with automations across Workday and SAP S/4 HANA
- Managing organizational spend across Coupa or SAP Ariba and SAP S/4HANA

The SAP S/4HANA Snap Pack provides Create, Delete, Read, and Update Snaps and massively simplifies data modeling as you build automated business processes to connect SAP S/4HANA with other systems.

Build a single source of truth for your customer profile data inAdobe Experience Platform

We have updated the Adobe Experience Platform,( previously referred to as Adobe Cloud Platform Snap Pack). Use it as the single source of truth for your customer profile data. Update and maintain customer data in real-time to power accurate, up-to-the-moment, insights for your sales, marketing, and support teams. This Snap Pack update consists of a Write Snap, an S3 connector, and an AEP File Generator to leverage the capabilities of the Adobe Experience Platform and eliminate data silos for your customer profile data.

Connect with other Snap updates with confidence

Cassandra Snap Pack: now updated to support v3, with an updated JDBC driver
Snowflake Snap Pack: updated to JDBC driver version 3.12.3.
ServiceNow Snaps: now certified against Madrid, Orlando, and New York versions.
Oracle Snaps now supports version 19c.

SnapLogic eXtreme enhancements

Offering enhanced account encryption and cross-account IAM roles, SnapLogic eXtreme gets a big security boost with this release. These two new enhancements help your organization improve its security posture while delegating access to AWS EMR resources that SnapLogic eXtreme leverages to execute Spark-based pipelines.

Enhanced Account Encryption leverages Amazon KMS asymmetric keys– you no longer need to put in the secret key associated with your account in the SnapLogic UI.

Cross-Account IAM Role enables SnapLogic to assume an authorized role for the purpose of managing the lifecycle of Amazon EMR clusters that run Spark mode data transformations, so you don’t have to do it..

SnapLogic eXtreme is broadly applicable with support for any JDBC compliant data store.

Use a Spark mode pipeline to read from or to write to any JDBC compliant database.

Important for big data workloads – no longer need to use a data lake like S3 for staging.

Dynamics 365 – most popular erp system with users in 2020 survey – ask Synergy Software Systems, Dubai

May 12th, 2020

Which ERP Systems Are The Most Popular With Their Users In 2020? the title of a recent
Forbes reports which indicates that 84% of Microsoft Dynamics 365 for Finance and Operations users are the most likely to recommend their ERP system to industry colleagues evaluating ERP solutions.

Call us: on 0097143365589 to find out how we are helping organisationsto digitally transform, optimise business process workflows and seamlessly connect with their customers, stakeholders and teammates.

No change to end of life support for Ax 2012 – plan your migration with Dynamics Gold Partner Synergy Software Systems

May 11th, 2020

Coronavirus tis impacting many IT project for Dynamics AX customers migrating from legacy versions of Ax 4/2009/2012 to dynamics 365.

Be aware that extended support plans for Dynamics AX 2009 Service Pack 1, AX 2012, and AX 2012 R2 are due to end on October 12, 2021. AX 2012 R3 users have until January 10, 2023. And Microsoft is advising customers these dates will remains in place, at least for now.

A Microsoft spokesperson provided this statement:

There is currently no plan to extend support further; however, we continue to monitor market needs including impact of the current COVID-19 pandemic related to support for Dynamics AX 2009 and Dynamics AX 2012.

So while the legacy versions are robust they will increasingly be incompatible with the latest versions of operating systems and browsers, and SQQL database and be increasingly vulnerable to malware and cybercrime. The coronavirus pandemic is affecting projects in many ways especially for global projects, for example: travel/quarantine, lockdowns and curfews on working, the need for remote collaboration, and e learning, and for global rollout more use of local partners.

There is no immediate end in sight so projects and timelines will be impacted for at last another year in which case we strongly advise you start your preparations for migration as early as possible. there is mush to consider: the on premise vs on cloud decision is now of greater importance, environmental sizing for cloud or on premise needs is significantly different as is new licensing and features for D365, new security set ups, code and data migration, project methodology via LCS , budgetting and project planning all take a lot of time.

The new challenges are accelerating different ways of working and some Business Process re-engineering should also be considered- e-commerce, Robotic Process automation, Lean manufacture, cross platform and application processes, self service, vendor collaboration, Customer portals, increased use of smart phones and mobiles from bar cod e driven WMS operations to Advanced analytics on your phone anytime anywhere any devices. To compete needs omni channel tailored services – there has never been a greater need for increased cost control, efficiency, and customer service. Start the process now while you can – as deadlines get nearer there will be backlog of customers seeking to upgrade and shortage of available resources both internally and externally.

TEAMS -75 million users -ask Synergy Software Systems, Dubai

May 1st, 2020

The use of Microsoft Teams has surged more than 70 percent since March with the massive global shift to remote work requiring increased online collaboration and video conferencing. .

Microsoft CEO Satya Nadella the n updated figure for daily active users (DAU) on Wednesday of 75 million.
The 75 million DAU follows a 44 million figure for the same metric as of March 18.

“As work norms evolve, organizations are realizing they need a comprehensive solution that brings together communications, collaboration and business process — built on a foundation of security and privacy,” Nadella said.

Nadella said that Teams had more than 200 million meeting participants in a single day in April. He also said those same participants racked up more than 4.1 billion meeting minutes.

“Microsoft Teams supports multiple communications modalities in a shared workspace. It is the only solution with meetings, calls, chat, collaboration with the power of Office, and business process workflows — in a single, integrated user experience — with the highest security, as well as compliance. Teams keeps all your work and communication — conversations, documents, whiteboards, and meeting notes — in context. It helps people collaborate inside and outside meetings, making them more efficient and effective while reducing fatigue,” he said.

“Twenty organizations with more than 100,000 employees are now using Teams, including Continental AG, Ernst & Young, Pfizer and SAP. Just last week, Accenture became the first organization to surpass half a million users,” Nadella said.

We use it – how about you?

Callus to learn more: 0097143365589

Synergy Support during covid-19 lockdown

April 6th, 2020

As a precautionary measure instructed by our Government for COVID-19 to be Safe at Home to protect our staff and to protect the community Synergy, consultants are instructed to work from home for at east the next two weeks.

To help us to provide continuous support please follow these guidelines to ensure our queries are recorded and assigned to be addressed in addressed as soon as possible.:

1. Send an email with a clear description in the email Subject line”, which will be helpful to track the email chain.
2. Please mention any internal issue/ticket number assigned, the user, and as much detail as possible e.g. transaction detail such as: order number, vendor code, item code – take a screenshot – copy any error message and attach those details to the email. Better still record the steps e.g. with e.g. webex, or task recorder.
3. If you are not on your work telephone number, or email, e,g when working from home yourself, then ensure you provide contact information for us to reach you.
4. To understand the issue, we may need to connect to the user PC through a screen sharing app such as Microsoft TEAMS, or Go To Meeting. Please ask your admin take appropriate action to ensure we can dial in remotely to your systems if needed, Even when located elsewhere they will also able to join such sessions.
5. Every request is given a ticket number and is then assigned to a consultant. For follow up communication please mention the ticket number. That will make it easier for us to find and review the details and actions to date. It’s possible that more than one consultant may be involved and they will be working remote from each other. This will save time for everyone .
6. Once the support request/ issue is resolved, upon receipt of confirmation email, the request will be closed.
7. When needed to discuss pending issues we will also be available to have a conference call via Microsoft Teams. issues @ mutual agreed time.
6. All support request to be sent to Axapta.support@synergy-software.com and we suggest copy in the lead consultant and account manager with whom you normally deal’
7. Please circulate this information to respective users and department heads, so that everyone working from home is aware that we are still available to support you as best we can and that they know how to help us, to help them.

Dynamics 365 Wave 2 April 2020 start planning……..

January 28th, 2020

The first release wave of 2020 for Dynamics 365 in April will contains hundreds of new features across Dynamics 365 applications including: Sales, Marketing, Customer Service, Field Service, Finance, Supply Chain Management, Human Resources, Commerce and Business Central.

During April 2020, Microsoft will turn on all environments to receive the 2020 release wave 1 features.
The updates will be deployed on your environments automaticallyfollowing their Safe Deployment Process (SDP).

Dynamics 365 Finance, Dynamics 365 Supply Chain Management, or Dynamics 365 Commerce:
- You can configure the maintenance day and time windows in Lifecycle Services (LCS).
- You’ll receive an email if you opt in to receive LCS notifications.
- You’ll be able to select the designated tier 2 sandbox for the update.
– The sandbox environment will be updated followed by the production environment.

You’ll have five business days for testing and validation.

So its important to consider testing and training with previews beforehand.

If you need consulting resources to assist, with testing and training in new features during April there is only a 5 day window and all customers will be upgraded in April so plan ahead to schedule any consulting resources you may need,

The downloadable PDF will be available on January 31, 2020.
Highlights from Customer Engagement applications include:
Dynamics 365 Sales continues to focus on user experience and sellers productivity improvements.
Dynamics 365 Sales Insights expands focus to include inside sales scenarios and enhances conversation intelligence capabilities. New features include deeper conversation analysis with emotion detection to enable sellers with the information they need, when they need it.
Dynamics 365 Customer Service expands agent productivity tooling to help organizations evolve a proactive and predictive service model.
Dynamics 365 Customer Service Insights optimizes the customer service experience through AI with new capabilities including richer integration with Power Virtual Agents and access to the insights data for in-depth analytics.
Dynamics 365 Field Service improves effectiveness through a new resource scheduling dashboard, integration with Dynamics 365 Supply Chain Management, and technician time entries.
Dynamics 365 Marketing remains focused on enabling marketers by enhancing product usability, personalized marketing capabilities with dynamic content for contacts, and integration scenarios with third-party content management systems and Microsoft Forms Pro.
Dynamics 365 Customer Insights enhances data profiling enrichment and segmentation capabilities, helping organizations better understand their customer data and derive actionable insights to drive business processes.

Highlights from Dynamics 365 Operations, Finance, Commerce, and HR applications include:
Dynamics 365 Human Resources expands capabilities for human resources professionals, employees, and managers in leave and absence and benefits management programs.
Dynamics 365 Commerce strengthens the personalized, omni-channel experience for consumers by adding e-commerce, providing smart product recommendations, and enhancing clienteling.
Dynamics 365 Fraud Protection helps merchants increase revenue and reduce fraud losses and costs while improving the consumer’s online check-out experience by releasing two new services, account protection and loss prevention.
Dynamics 365 Finance releases enhancements to: country-specific tax, invoicing, payment formats, and regulatory reporting capabilities to help global organizations stay compliant with newly introduced local regulations.
Dynamics 365 Supply Chain Management helps organizations reduce operational costs by: introducing customer self-service experiences, enhancements to asset management, and the new on-hand inventory service for inventory visibility across Dynamics 365 and other legacy systems.

Power Platform
New Power Platform capabilities combine Power BI, Power Apps, Power Automate, Power Virtual Agents, and the Common Data Service into an unmatched palette of tools to analyze data, build solutions, and automate processes. This release includes robotic process automation (RPA) capabilities in Power Automate, to automate rule-based tasks with point-and-click simplicity supporting on-premises or cloud-based apps.

Power Apps gains significant improvements for developers of all skill levels, improving the sophistication and usability of apps that are created across the web and mobile devices.

Microsoft business intelligence simplifies how organizations derive insights from transactional and observational data. It helps organizations create a data culture where employees can make decisions based on facts, not opinions. In this release wave, Power BI invests in four key areas including: intuitive experiences, a unified BI platform, big data analytics, and pervasive artificial intelligence (AI).

Early access available Feb 3, 2020
Test and validate new features and capabilities that will be a part of the 2020 release wave 1, coming in April, before they get enabled automatically for your end-users

General availability April 1, 2020 Production deployment for the 2020 release wave 1 begins. Regional deployments will commence on April 3, 2020.

Model-driven apps in Dynamics 365: The 2020 wave 1 release does not apply to customers of Dynamics 365 Customer Engagement (on-premises). The 2020 release wave 1 release will be applicable for the customers of both commercial and the Government Cloud.
Dynamics 365 Finance, Dynamics 365 Supply Chain Management, Dynamics 365 Commerce, or Dynamics 365 Business Central: The 2020 wave 1 release is applicable for customers of Finance + Operations (on-premises) as well. You can opt in to preview the new functionalities similar to online.
industry accelerators are included in this wave:

Nonprofit accelerator enables you to develop nonprofit solutions based on entities and attributes that nonprofits commonly leverage for constituent management, fundraising, awards, program delivery, and impact tracking.
Financial services accelerator enables you to quickly develop solutions based on entities and attributes that banks commonly leverage for customer experience and other business processes. These entities include banks, branches, financial products, loans, referrals, limits, requested facilities, and more.
Health accelerator allows you to build solutions and create new use cases and workflows with entities focused on enhanced care coordination and the ability to segment patients and providers based on Electronic Medical Record (EMR) data.
Automotive accelerator enables you to quickly develop solutions based on entities and attributes that dealerships and OEMs commonly leverage for customer experience and other business processes. These entities include deals, sales contracts, specifications, fleet, warranties, inspection, test drives, branding, business, customer-vehicle relationship, vehicle and equipment, lead, service and after-sales management, and more.

SnapLogic iPaaS in the news

January 14th, 2020

Snaplogic is a low code integration platform that is particularly suited to hybrid integrations between cloud and on-premise software e.g. for BI, CPM or ecommerce or EDI . several interesting recent news posts:

• Information Age – Should you consider adopting a cloud data warehouse? Craig discusses data lake and data warehouse considerations with Information Age – https://www.information-age.com/should-you-consider-adopting-cloud-data-warehouse-123486561/ In the modern world of data lakes, CDOs and CIOs will face three major challenges: how to migrate their users, how to live with a hybrid infrastructure for a while and how to future-proof their data platform

• IT Brief Australia – How AI bias is holding back adoption – https://itbrief.com.au/story/snaplogic-how-ai-bias-is-holding-back-adoption Brad writes about combating AI bias to retain public trust and ensure AI initiatives advance responsibly.

• Digitalisation World – The Cost of Legacy Technology – https://digitalisationworld.com/blogs/55941/the-cost-of-legacy-technology Neerav explains the risks, and growing costs, of sticking with outdated legacy technologies. In recent times, lack of innovation and adoption of new technology has proven to be the downfall of some well-known high street names – for example, Thomas Cook has littered the headlines following its collapse. In an era when anyone can book their travel, accommodation and holiday entertainment from the comfort of their own home, travel companies can seriously damage themselves by ignoring this reality, failing to innovate and relying on legacy systems.

Businesses need to know the full extent to which using antiquated tech can cost them money and cause them damage. ………

Revenue recogntion Dynamics 365 – ask Synergy Software Systems, Dubai

November 26th, 2019

The new revenue recognition standard is for compliance with ASC 606 and D365FO. it became available last month in generally release 10.0.5
To use this feature enable the module through license configuration when in maintenance mode.
System administration> Setup> License configuration. ( or go to the home page and use Advanced Search. Type “license configuration” and click on the “License Configuration” option.) Find the revenue recognition module under the General ledger node and select the module so that it is available for use.

To use the functionality set up schedules under Revenue recognition / Setup / Revenue schedules.
Set up five new posting types have been added to the inventory posting set up.

This video explains the basics of revenue recognition in Dynamics 365 Finance and how it’s used on sales orders. Customers will learn how different revenue schedules can be defined per item and how revenue schedule details are created upon invoicing a sales order.

Windows Server 2008 and 2008 R2 support will end January 14, 2020- ask Synergy Software Systems about options.

November 16th, 2019

On January 14, 2020, support for Windows Server 2008 and 2008 R2 will end. Only 2 months away
That means the end of regular security updates.

Don’t let your infrastructure and applications go unprotected.

We’re here to help you migrate to current versions for greater security, performance and innovation.
009714 3365589

SnapLogic iPasS integration as a service – from Synergy Software Systems.

October 20th, 2019

Business Intelligence Managers/Analysts, Data/ETL Engineers, and Information/Data Architects are tasked with empowering business users to make use of
data to drive smart decisions and innovations. Data-driven initiatives can be challenging considering the explosion of data volumes due to the proliferation of sensors, IoT, and mobile computing.

Moreover, a growing number of groups within the business want access to fresh data.

To fully harness their data, organizations must also have a cloud strategy for their digital transformation efforts, namely to migrate data from
on-premises environments to the cloud. Considering the tremendous business value of unlocking that data, it’s imperative to prioritize and streamline these
data integration and migration projects.

Gone are the days when IT needed hundreds of coders to build extract, transform, load (ETL) solutions and then maintain those by writing more code. Modern integration platforms eliminate the need for custom coding. Now, data integration projects deploy and scale, often as much as ten times faster.

iPaaS platforms ease the pain because they’re designed for flexibility and ease of deployment for any integration project. A drag-and-drop UX coupled with a powerful platform and hundreds of pre-built connectors out of the box.

The connectors are always up-to-date, so the IT organization doesn’t spend an inordinate amount of time maintaining every integration by hand. This saves an incredible amount of time, money, and frustration across the team and projects and greatly reduces risk.

Not all integration platforms are created equal. Some do simple point-to-point cloud app integrations while others transform large and complex data into a data lake for advanced analytics. Some stgill require extensive developer resources to hand-code APIs while others provide self-service, drag-and-drop offerings that can be used by IT and business leaders alike. Some are best for specific tactical projects while others provide a strategic, enterprise-wide platform for multi-year digital transformation projects.

Organizations must address four key steps during the data migration and integration process:
1. Capture data that supports both the known use cases as well as future undefined use cases (think IoT data to support a future machine learning
enabled use case).
2. Conform inbound data to corporate standards to ensure governance, quality, consistency, regulatory compliance, and accuracy for downstream
consumers.
3. Refine data for its eventual downstream application and/or use cases (once its been captured and conformed to corporate standards).
4. Delivery of data needs to be broad and prepared to support future unknown destinations.

For decades, IT has been tasked to manage integration projects by writing tons of custom code. This onerous task is even more complex with the proliferation of SaaS applications, the surge in big data, the emergence of IoT, and the rise of mobile devices. IT’s integration backlog has exploded. Not only is the deployment too much work, but there is a growing cost to maintain all of the integrations.

Deploying a tactical or departmental data warehouse solution should take days, not months. Moreover, enterprise-wide data transformation projects should take months, not years.

The best data integration platforms:
- Support multiple app and data integration use cases across cloud, on-premises, and hybrid deployments
- Offer the flexibility to be used in cloud, hybrid, or on-premises environments, regardless of the execution location
- Provide a self-service user experience aided by AI, machine learning, hundreds of pre-built connectors, and integration pipeline
templates (patterns) resulting in greater user productivity, and faster time-to-integration
- Have an underlying, scalable architecture to grow with evolving data and integration requirements
- Support different data modes such as streaming, event-driven, real-time or batch

The SnapLogic iPaaS offering is functionally rich and well-proven for a variety of use cases. It supports hybrid deployments and provides rich and differentiating features for analytics and big data integration (Hadooplex). Clients score SnapLogic as above average for cloud characteristics, functional completeness, ease of use and ability to meet SLAs.” Gartner

SnapLogic is a U.S.-based integration platform company. In mid-2013, it transitioned from a traditional software business to an iPaaS model with the release of the SnapLogic Elastic Integration Platform which provides a large set of native iPaaS capabilities that target the cloud service integration, analytics and big data integration use cases.

The flagship Enterprise Edition features a set of base adapters (Snaps), an unlimited number of connections and unlimited data volume.

Synergy Software Systems has been an Enterprise Solutions Integrator in the GCC since 1991. We are pleased to announce our formal partnership to represent Snap Logic in the MEA region.

Do you need to integrate with Azure? with SAP Data Warehouse Cloud? with Workday? With Odette compliant auto mamufacturers………..?.

To learn more call us on 009714 3365589

SQL Server 2016 Service Pack 2 SP2 CU9 release

October 1st, 2019

Cumulative Update package 9 (CU9) (build number: 13.0.5470.0) for Microsoft SQL Server 2016 Service Pack 2 SP2 is now aavilablefor download. (It contains fixes that were released after the initial release of SQL Server 2016 SP2.)
SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence. Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.

The CU provides the following fixes and improvements (Referenced from https://support.microsoft.com/en-us/help/4100997/cumulative-update-9-for-sql-server-2016-sp1)

KB4099472 – PFS page round robin algorithm improvement in SQL Server 2016 SQL service
KB4133164 – FIX: Error when a SQL Server Agent job executes a PowerShell command to enumerate permissions of the database Management Tools
KB4086173 – FIX: Access violation occurs when executing a DAX query on a tabular model in SQL Server Analysis Services Analysis Services
KB4131193 – Performance issues occur in the form of PAGELATCH_EX and PAGELATCH_SH waits in TempDB when you use SQL Server 2016 SQL service
KB3028216 – FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS Analysis Services
KB4135113 – FIX: Change tracking record is inconsistent during an update on a table which has a cluster/unique index in SQL Server SQL service
KB4293839 – FIX: TDE database goes offline during log flush operations when connectivity issues cause the EKM provider to become inaccessible in SQL Server SQL security
KB4230730 – FIX: A dead latch condition occurs when you perform an online index rebuild or execute a merge command in SQL Server SQL service
KB4163478 – FIX: An access violation occurs when incremental statistics are automatically updated on a table in SQL Server SQL performance
KB4230306 – FIX: Restore of a TDE compressed backup is unsuccessful when using the VDI client SQL service
KB4163087 – FIX: Performance is slow for an Always On AG when you process a read query in SQL Server SQL service
KB4164562 – FIX: Wrong user name appears when two users log on to MDS at different times in SQL Server Data Quality Services (DQS)
KB4094893 – FIX: Database cannot be dropped after its storage is disconnected and reconnected in SQL Server SQL service
KB4162814 – FIX: An internal exception access violation occurs and the SSAS server stops responding Analysis Services
KB4134541 – FIX: Error in the MDS Add-in for Excel when you use the German version of Excel in SQL Server Data Quality Services (DQS)
KB4132267 – FIX: Deploying a SSAS project in SSDT is frequently unsuccessful in SQL Server Analysis Services in Tabular mode Analysis Services
KB4101554 – FIX: Parallel redo in a secondary replica of an availability group that contains heap tables generates a runtime assert dump or the SQL Server crashes with an access violation error High Availability
KB4098762 – FIX: Hidden parameters are included in reports when the Browser role is used in SSRS 2016 Reporting Services
KB4134175 – FIX: Processing a cube with many partitions generates lots of concurrent data source connections in SSAS Analysis Services
KB4091245 – FIX: Access violation occurs when you query a table with an integer column in SQL Server 2017 and SQL Server 2016 SQL performance
KB4094706 – FIX: One worker thread seems to hang after another worker thread is aborted when you run a parallel query in SQL Server SQL service
KB4058175 – FIX: TDE enabled database backup and restore operations are slow when the encryption key is stored in an EKM provider in SQL Server SQL service
KB4131960 – FIX: An access violation occurs when you execute a nested select query against a columnstore index in SQL Server SQL Engine
KB4094858 – FIX: “An unexpected error occurred” when you use DAX measures in Power BI table visualizations in SQL Server Analysis Services
KB4101502 – FIX: TDE enabled database backup with compression causes database corruption in SQL Server 2016 SQL service

CUs also often include supportability, manageability, and reliability updates.

Before udpate:

- Check compaitbiltiy with your application.
- Test CUs before you deploy to production environments.

Gartner recognized SnapLogic as a Visionary in its Data Integration Magic Quadrant

August 7th, 2019

Gartner recognized SnapLogic as a Visionary in its Data Integration Magic Quadrant! This comes on the heels of being recognized as a Leader in three top analyst reports for the best integration platform as a service (iPaaS) solutions – the Gartner Magic Quadrant, Forrester Wave, and G2 Crowd Grid.
We believe these collective recognitions testify to the fact that SnapLogic is unrivaled when it comes to integrating cloud applications and on-premises data in one unified platform.

Gartner commended SnapLogic for:
• Our powerful integration convergence and augmented data integration delivery
• Our easy accessibility to diverse user personas
• Our pricing model simplicity and trial version

Synergy Software Systems is a Middle East partner. . This solution speeds up deployment of complex solutions with multiple jntegrations and significantly improves and simplifies the management and maintenance of integrations.

Whether for EDi to Odette standards for the automotive sector, or for streaming high volumes of data, or for ETL processes to bring data from multiple, enterprise systems into a data lake or Enterprise BI or Corporate performance management system, Snap Logic provides a multitude of pre built “Snap integrations: for a low code, configuration approach to integration.

Synergy Software Systems has provided integrated solutions in the region. Digital revolution is proving new opportunities and challenges. Robotic Processes Automation, Predictive analytics, ML AI, IoT, RFID, cloud services, data lakes, and mobility are now standard components of any solution. However digital revolution also requires agility and rapid robust deployment and ease of update and maintenance. Integration ETL, and streaming data from multiple systems at enterprise scale needs a new ‘productized’ low code approach to integration.

Snaplogic is a key tool for successful agile deployment of Enterprise integration, Corporate Performance management, EDI, BI and RPA solutions.

There are already major clients deploying Snap Logic in the UAE.

To learn more . Call us on 00971 43365589