The Federal Tax Authority (FTA) has stressed the need for taxpayers to abide by accurate, emirate-specific Value Added Tax (VAT) reporting requirements in relation to e-Commerce.
The Authority noted that recent updates to the VAT legislation in the UAE, specifically around the reporting of e-Commerce supplies result in additional obligations for a number of persons when preparing their VAT returns.
The FTA emphasized that businesses must carefully assess whether they fall under the new reporting obligations, noting that failure to comply or compliance with the updated reporting when not required may result in mistakes and expose companies to potential penalties.
Starting from 1 July 2023 and in the VAT return for the first tax period starting on or after that date, “qualifying registrants” are required to:
report supplies made through e-commerce in box 1 of their VAT Return, based on the Emirate in which the supply of goods or services is received by the customer.
They are also required to retain the relevant supporting evidence.
If a taxpayer is not a qualifying registrant or if a supply is not an e-commerce supply, then the taxable business must report its supplies in the Emirate where its fixed establishment related to the supplies made is located.
The FTA of UAE has recently issued certain user manuals on
The FTA explained that starting from 1 July 2023, and in the VAT return for the first tax period starting on or after that date, “qualifying registrants” are required to report supplies made through e-commerce in box 1 of their VAT Return, based on the Emirate in which the supply of goods or services is received by the customer. They are also required to retain the relevant supporting evidence. If a taxpayer is not a qualifying registrant or if a supply is not an e-commerce supply, then, generally, the taxable business must report its supplies in the Emirate where its fixed establishment related to the supplies made is located.
The Authority called upon the taxpayers to review the relevant legislation and the clarifications provided by the FTA prior to their next VAT return submission process, to determine if:
They have made e-commerce supplies in the calendar year ending on 31 December 2022
The value of these e-commerce supplies made in the previous calendar year exceeded AED100 million.
The Federal Tax Authority noted that in order to assist taxpayers in preparing a correct VAT return, the FTA’s Tax administrations system (“EmaraTax”) will request taxpayers to respond to a set of 2 questions to confirm if they are indeed qualifying registrants with respect to the new e-commerce supplies reporting requirement. This double-check will aid taxpayers to submit a correct VAT reporting, avoiding any later corrections or penalties.
Comments Off on UAE e-commerce Emirate specific VAT reporting »
Microsoft on Tuesday announced that it will no longer be supporting SQL Server 2012
The product, on July 12, 2022, reached the end of its 10-year support model. It means that SQL Server 2012 will no longer get future security patches from Microsoft. The server continues to run under such circumstances, but organizations may be potentially exposed to future security troubles and they could get encumbered by the compliance implications of running unsupported software.
Organizations who need to stick with SQL Server products, have four options:
Organizations can upgrade to SQL Server 2019.
Organizations can continue to use SQL Server 2012 and get “Critical” security patches only via Microsoft’s Extended Security Updates (ESU) program for up to three years.
Organizations can move their SQL Server 2012 workloads into Microsoft Azure virtual machines, where Microsoft provides the ESU patches at no cost.
Lastly, Microsoft advocates using Azure SQL Managed Instance, which is an Azure platform-as-a-service offering that promises high compatibility with on-premises SQL Server.
The Azure SQL Managed Instance option is similar to the Azure Arc-enabled SQL Managed Instance service, but the latter lets organizations continue to use their own infrastructure. The nuances between those two options are described in this Sept. 30, 2020 Microsoft Tech Community post.
While the ESU program offers a grace period of sorts for SQL Server 2012 users, its use with on-premises servers comes with licensing requirements. Organizations will need to have Software Assurance coverage, which is an annuity cost. However, they can only buy ESUs when they have an “Enterprise Agreement (EA), Enterprise Subscription Agreement (EAS), a Server & Cloud Enrollment (SCE) and Enrollment for Education Solutions (EES)” licensing, according to Microsoft’s end-of-support FAQ document.
The ESU program lets organization buy Critical security patches in one-year increments, for up to three years maximum. Microsoft hikes the ESU price each year by 25 percent of the base price of SQL Server 2012 license, according to the following formula:
Year 1: Approximately 75% of full license price
Year 2: Approximately 100% of full license price
Year 3: Approximately 125% of full license price
Those incremental fees no doubt are designed to prod organizations into moving their SQL Server 2012 workloads into Azure virtual machines, where Microsoft provides ESU patching for free.
For organizations making the move to cloud services, Microsoft’s Azure Migration and Modernization Program offers either Microsoft ,or partner support for moves to Azure services. This program is billed as being available to organizations of all sizes, and bearing “no additional cost” for Azure customers, per its landing page.
Microsoft has recently beefed up the funding for the Azure Migration and Modernization Program.
“We’re now investing significantly more to support your largest Windows Server and SQL Server migration and modernization projects, up to 2.5 times more than previous investments, based on project eligibility,” the announcement indicated. “This investment will help with your migration in two ways: partner assistance with planning and moving your workloads, and Azure credits that offset transition costs during your move to Azure Virtual Machines, Azure SQL Managed Instance, and Azure SQL Database.”
The announcement also warned that Windows Server 2012 and Windows Server 2012 R2 will be reaching their end-of-support phases “next year on October 10, 2023.”
Microsoft plans to offer its ESU patch program and its Modernization migration support program for those servers as well.
Next year, in April, many of Microsoft’s 2013-branded application servers will also fal out of support
Note: Before you upgrade SQL, check the compatibility of the software that runs on it with the new version of SQL – you may be faced with the need to also update those systems to later versions for example older versions of Dynamics Ax,
Comments Off on End of support for Microsoft SQL 2012 »
The UAE has long positions itself as a place where foreign investors are welcome and where incomes are tax free. Low taxes and a friendly business environment helped to transform the 50-year-old nation.
The UAE faces steep competition from neighboring Saudi Arabia, which is working overtime to attract businesses and families to relocate to the kingdom
The UAE’s Finance Ministry said that it will aunch corporate tax in line with worldwide efforts to combat tax evasion and to meet issues posed by the global economy’s digitization,
The ministry also stated that the measure will prepare for the implementation of a worldwide minimum tax rate, which will apply a different corporate tax rate to large multinationals that meet certain conditions.
It was announced on Jan 31 that for the first time, the United Arab Emirates (UAE) will establish a federal corporate tax of 9% on profits on business profits on June 1, 2023,
Businesses engaged in the extraction of natural resources will be exempt from the UAE CT as such businesses shall continue to be subject to Emirate level taxation
The UAE CT shall be a Federal level corporate taxation. Thus, all UAE businesses, corporations and entities engaged in and licensed to undertaken commercial activities shall be subject to the UAE CT.
Corporate tax will be payable on the profits of UAE businesses as reported in their financial statements prepared in accordance with internationally acceptable accounting standards “with minimal exceptions and adjustments”,
The corporate tax will not apply to personal income from employment, real estate and other investments, nor to income earned from a business licensed outside the UAE.
Introduction of Transfer Pricing
Under the CT regime, UAE businesses will be required to comply with transfer pricing rules and documentation requirements as set out in the OECD Transfer Pricing Guidelines
Free Zone Businesses
Free zone businesses will be within the scope of UAE CT and required both to register and to file a CT return.
Those businesses will however continue to benefit from CT holidays/ 0% taxation while they comply with all regulatory requirements and do not conduct business in mainland UAE.
Multinationals
The press release and FAQs indicate that there will be a different tax rate for large multinationals that meet the criteria under ‘Pillar Two’ of the OECD Base Erosion and Profit Shifting project (i.e. those that have consolidated global revenues above EUR 750m).
Tax basis
The Federal Tax Authority will be responsible for the administration, collection, and enforcement of CT.
Where a business is resident for CT purposes will be determined either based on the place of incorporation / registration (legal seat), or the place of effective management and control of the business.
To help small firms and entrepreneurs, the ministry further stated that the new system entails:
a basic statutory tax rate of 9%,
a 0% rate for taxable profits up to 375,000 dirhams, ( about $102,107.50 . )
CT will be payable on the accounting net profit reported in the financial statements of the business, with minimal exceptions and adjustments.
Tax losses incurred from the CT effective date can be carried forward to offset taxable income in future financial periods.
No UAE CT will apply to:
Employment income, income from real estate, income from savings, investment returns and other income earned by individuals in their personal capacity that is not attributable to a UAE trade or business;
Dividends, capital gains and other investment returns earned by foreign investors.
Exemption from UAE CT will be available for:
Capital gains and dividends earned from qualifying shareholdings;
Qualifying intra-group transactions and restructurings.
Domestic and cross border payments of interest, dividends, royalties and other payments will not attract a withholding tax in the UAE.
UAE CT will have to be filed electronically once for each financial period but without a requirement for advance UAE CT payments on the basis of provisional tax returns.
The tax scheme will allow UAE business groups to be taxed as a single entity or to apply for relief amid losses or restructuring. UAE group companies can form a tax group and file a single tax return for the entire group, and transfer tax losses to other members of the group.
Foreign tax credits will be available for taxation incurred by UAE businesses on income earned outside the UAE’s corporate tax to avoid double taxation.
The UAE CT regime should remain one of the most competitive in the world. The UAE will offer the most competitive CT regime in the region, with Egypt, Jordan, Kuwait, Lebanon, Oman, Saudi Arabia and Qatar imposing CT at rates between 10% to 35% (Bahrain currently does not have a broad based CT regime).
The introduction of a UAE CT regime would enable the UAE to adopt and implement the OECD BEPS 2.0 measures to address the tax challenges arising from the digitalisation of the global economy, and the introduction of a global minimum tax rate for large multinationals.
What next?
The relevant legislation for the CT regime is currently being finalised and will be subsequently promulgated. Once promulgated, the UAE CT Law will provide more details and guidance on several critical aspects.
Further information is expected to be made available by mid-2022, to give UAE businesses at least 12 months to get ready.
Key considerations for UAE businesses
To prepare for the new corporate tax (CT) profile of the UAE consider an internal working team and whether auditor discussions are needed
Consider the application and impact of the new UAE CT Law on :
UAE entity(ies) and/or operations
Revenue booked under Mainland UAE versus Free Trade Zone setups
Economic substance profile and/or CbCR filings
Group structure
Inter-company transactions
Investment/Holding structures
Be prepared to adopt new tax and transfer pricing compliances (where applicable).
Consider impact on share price and ability to raise finance
Review IT systems and their configuration to support taxation, and budget for any external consulting resource to e.g. create filing returns reports, or to amend existing reports e.g. TB, cash flow.
Consider whether there needs to be any changes to policies and training for the finance team.
Consider a dry run pilot in a test system to ensure that you can produce timely accurate reports in the correct format.
(Most Dubai stocks fell in the Middle East on February 1 after the United Arab Emirates unveiled that it will be taxing corporate earnings from next year.
Moody’s said: “the introduction of the 9% federal corporate tax is broadly credit negative for domestic UAE corporates because it will reduce their operating cash flows.”)
Comments Off on U.A.E. to introduce Corporate Tax – 2023 -ask Synergy Software Systems »
This update https://support.microsoft.com/en-us/topic/kb5006943-on-demand-hotfix-update-package-for-sql-server-2016-sp3-94de2975-cd7d-47ed-b003-5d7daf4e2caf contains hotfixes for issues that were fixed after the release of SQL Server 2016 SP3 (https://support.microsoft.com/en-us/topic/kb5003279-sql-server-2016-service-pack-3-release-information-46ab9543-5cf9-464d-bd63-796279591c31 ). To apply this hotfix package, you must have SQL Server 2016 installed on your computer.
Note The build number of the hotfix update package is 13.0.6404.1.
Comments Off on KB5006943 – On-demand hotfix update package for SQL Server 2016 SP3 »
A bungled data migration of a network drive caused the deletion of 22 terabytes of information from Dallas Police Department police force’s systems – included case files in a murder trial,during a data migration exercise carried out at the end of the 2020-21 financial year
“On August 6, 2021, the Dallas Police Department (DPD) and City of Dallas Information and Technology Services Department (ITS) informed the administration of this Office that in April 2021, the City discovered that multiple terabytes of DPD data had been deleted during a data migration of a DPD network drive,” said a statement [PDF] from the Dallas County prosecutor’s office.
14TB were recovered, presumably from backups, but “approximately 8 Terabytes remain missing and are believed to be unrecoverable.”
The Home Office initially issued a statement saying the data loss was down to a “technical issue”, which had been resolved, There must have been some technical resolution because the Home Office later said it was not a technical issue after all, and in fact a “housekeeping error” with Home Secretary Priti Patel saying: “Home Office engineers continue to work to restore data lost as a result of human error during a routine housekeeping process earlier this week.”
In a letter published by The Guardian, National Police Chiefs’ Council (NPCC) deputy chief constable Naveed Malik, lead for the organisation on the Police National Computer (PNC), said approximately 213,000 offence records, 175,000 arrest records and 15,000 person records had potentially been deleted in error. The DNA database connected to the PNC saw 26,000 records corresponding to 21,710 subjects potentially deleted in error, “including records previously marked for indefinite retention following conviction of serious offences”. The letter also said 30,000 fingerprint records and 600 subject records may have been deleted in error.
The PNC dates back to the 1970s. The current iteration is a Fujitsu BS2000/OSD SE700-30 mainframe based in a Hendon data centre, running Software AG’s natural programming language-using ADABAS database. The UK’s territorial and regional police forces, Serious Fraud Office, Security and Secret Intelligence Services (MI5, MI6), HM Revenue & Customs, and the National Crime Agency all make use of it. They have controlled and 24-hour access from remote terminals and through local police force systems.
These incidents highlight the importance of backups and backup and recovery processes. How often do you test whether you can restore your back ups? Does this still work for restoring older back ups when you upgrade? Has a move to the cloud changed the retention of your back ups, the frequency of upgrades, or the ease or time for restore?
The Kingdom of Saudi Arabia (KSA). The Kingdom announced e-invoicing for resident companies, which was published on December 4, 2020. e-invoicing will become mandatory for tax payers from December 4, 2021.
The aims of the e-invoicing mandate are to provide more transparency, and enhance consumer protection and anothee benefit of e-invoicing implementation is the readability of the invoice formats
. Companies registered in Saudi Arabia should immediately start updating or changing their systems and processes to support issuance of e-invoices. This may be a little challenging. However, the key to successful implementation is to start early.
Note that Dubai has also announced similar legislation.
If you need to upgrade or change your system or to .add additional functionality to your systems to comply with the invoicing mandate then please contact us 009714336589
On this blessed occasion of Eid, we wish you and your family good health, wealth and prosperity. And don’t forget to take a reflection on you and your business this Summer.
Comments Off on e-invoicing in KSA and Dubai – does your system meet the requirements? Ask Synergy Software Systems. »
IFRS 17 is the newest IFRS standard for insurance contracts and replaces IFRS 4 on January 1st 2022. Mainly to make the financial statement easier to compare across insurance companies and among industries
It states which insurance contracts items should by on the balance and the profit and loss account of an insurance company, how to measure these items and how to present and disclose this information.
This is a big change for insurance companies because data administration, financial presentation and actuarial calculations will need to change!
IFRS 9 explains the classification and the measurement of financial instruments. Hence IFRS 9 helps to improve the information disclosure around financial instrument. Many perceive the information disclosure around financial instruments during the financial crisis as inaccurate for example impairments on financial instruments were taken too late and the amounts were too little. IFRS 9 makes the classification of each financial instrument more logical and principle based. There are two questions which need to be answered for the classification: • Why is the company holding the asset; just for collecting the cash flows from the underlying asset, or is the asset also held for trading? • What kind of asset is the financial asset? Is it a derivative, an equity or a debt instrument? With the SPPI (solely payment of principal and interest) model it can be tested whether an instrument is really a debt instrument. The classification determines: • which accounting principle is used; • should the instrument be measured at fair value or at amortized cost • and whether earnings and losses should go through the profit and loss account or through the OCI (other comprehensive income) account. IFRS 9 also includes a more dynamic credit loss model instructing when an insurer should take an impairment on financial assets. The model is forward looking thereby also expected future losses should be taken into account with the impairment. IFRS 9 also makes hedge accounting possibilities more rule based, thereby being in line with how risks are managed within insurers.
Why are IFRS 9 and IFRS 17 implemented together? • The insurance liability (IFRS 17) is always closely connected to the financial instruments (IFRS 9) within insurers. • When a client buys an insurance, the insurance liability is created and with the paid premiums are financial instruments bought. • Insurers want to reduce the volatility in their earnings and there are some choices within IFRS 9 and IFRS 17 which they can make which can impact the volatility. • Under IFRS 17 insurers can decide whether results of changing financial risk assumption go through OCI or through the profit and loss account. • Under IFRS 9 insurers can decide whether changes in equity will go through profit and loss or through OCI. Both standards will impact earning volatility and hence balance sheet management choices are connected. Consequently, the IFRS board decided it is better that insurers are granted the option to implement both standards together.
Likely impacts • New concepts and terms are introduced. for example components like unbiased Cash Flows, Risk Adjustment, Discount Rate and CSM • The standards will have an impact on the presented numbers. Under IFRS 17 the insurance liability needs to be based on updated assumptions which is currently not the case with IFRS 4. • Faster disclosure is needed, which needs faster processes within the organization • Insurance liability needs to be specified in a different way, the importance of gross written premiums disappears, while equity will be impacted. • Risk engines are needed to calculate the CSM and cope with all the different groups • The general ledger system will change as new measurements are introduced • Big impact on presentation of the balance and P&L • More data is needed. with finer granularity and with more history, which challenges internal data quality and consistency and IT performance. • Reporting timelines are also shortened. both challenging the systems but also the cooperation between different departments. • Staff training will be needed.
To find out more about the requirements contact us or your auditors. To update your financial software or to acquire software to support IFRS 17 please call Synergy Software Systems on 009714 3365589
Comments Off on IFRS 17 and IFRS9 – Insurance contracts – are you ready? Ask Synergy Software Systems »
Are you responsible for a busy SQL server, for example, the Finance Department’s systems, documentation management, CRM, BI, or a Web Server; perhaps a busy file and print server, or something else entirely.
Were you responsible for installing the application running the workload for your company? Is the workload business critical, i.e. TOO BIG TO FAIL?
Do users, or even worse, customers, complain about performance?
If you are responsible to keep the workloads running in your organization that would benefit from additional performance, please read on – even if you don’t consider yourself a “Techie”.
Windows and VMs are both factors of high latency that impacts performance.
Variables Affecting the Performance of the Applications
There are many variables that affect the performance of those applications. The slowest, i.e. the most restrictive of these is the “Bottleneck”. Think of water being poured from a bottle. The water can only flow as fast as the neck of the bottle, the ‘slowest’ part of the bottle.
In a computer hardware the bottleneck will almost always fit into one of the following categories:
CPU
DISK
MEMORY
NETWORK
With Windows, it is usually very easy to find out which one the bottleneck is in, and here is how to do it (like an IT Engineer):
To open Resource Monitor – click the Start menu, and type “resource monitor”, and press Enter. Microsoft includes this as part of the Windows operating system and it is already installed.
Notice the graphs in the right-hand pane. When your computer is running at peak load, or users are complaining about performance, which of the graphs are ‘maxing out’? This is a great indicator of where your workload’s bottleneck is to be found.
What You Can Do to Improve Application Performance
Once you have identified your bottleneck – the slowest part of your ‘compute environment’ then, what can you do to improve it?
The traditional approach to solving computer performance issues is to throw bigger and more powerful hardware at the solution like an extra disk or a new laptop, or putting more RAM into your workstation, or on the more extreme end, buying new servers or expensive storage solutions.
How do you decide when it is appropriate to spend money on new or additional hardware, and when it isn’t. Well the obvious answer is; ‘when you can get the performance that you need’, with the existing hardware infrastructure that you have already bought.
You don’t replace your car, just because it needs a service or tuning?
Let’s take disk speed as an example. Look at the response time column in Resource Monitor. Open the monitor to full screen or large enough to see the data. On the Overview tab, open the Disk Activity section so that you can see the Response Time column.
Do it now on the computer you’re using to read this. (You didn’t close Resource Monitor yet, did you?) This shows the Disk Response Time, or , how long is the storage taking to read and write data? Of course, a slower disk speed = a slower performance, but what is considered a good disk speed or a bad speed?
“Response Time (ms). Disk response time in milliseconds. For this metric, a lower number is definitely better; in general, anything less than 10 ms is considered good performance. If you occasionally go beyond 10 ms, you should be okay, but if the system is consistently waiting more than 20 ms for response from the storage, then you may have a problem that needs attention, and it’s likely that users will notice performance degradation. At 50 ms and greater, the problem is serious.”
I hope when you check on your computer, the Disk Response Time is below 20 milliseconds. What about those other workloads that you were thinking about earlier. What’s the Disk Response Times on that busy SQL server, the CRM or BI platform, or those Windows servers that the users complain about?
Your Two Options
When the Disk Response Times are often higher than 20 milliseconds, and you need to improve the application performance, then it’s choice time and there are two main options:
Storage workload reduction software like DymaxIO™ fast data (Diskeeper®, SSDkeeper®, and V-locity® are now new DymaxIO fast data software). This tool will reduce Disk Storage Times by allowing much e of the data that your applications need to read, to come from a RAM cache, rather than be read slower disk storage. RAM is much faster than the media in your disk storage.
Contact us to trial this. You don’t even need to reboot.
If you have tried the DymaxIO software, and you still need faster disk access, then, it’s time to start getting quotations for new hardware. It does make sense though, to take a couple of minutes to install DymaxIO first, to see if that can be avoided. The software solution to remove storage inefficiencies is typically a much more cost-effective solution than having to buy hardware! A software solution to a software problem.
Improve Your Application Performance by Decreasing Disk Latency like an IT Engineer – call us to learn more 0097143365589
Comments Off on Quickly identify and fix your performance bottleneck »
We’re excited to announce the ‘February 2021’ release of the SnapLogic Intelligent Integration Platform. In this release, there are a number of new Snap Packs: for Marketo and Hubspot. for Marketing Automation, for Microsoft Teams and Power BI for team communication and analytics rly, and OpenAPI to connect to any OpenAPI compliant endpoints.
There is also support for Azure Synapse analytics to our ELT capability. Platform enhancements include :
higher productivity through expanded Universal search,
platform notifications to Slack,
better reliability through Snaplex level scheduling, and more.
Hassle-free connectivity with NEW Snap Packs
New Snap Packs provide out-of-the-box connectivity to key enterprise endpoints. For example the new Marketo and Hubspot Snap Packs allow you to connect seamlessly to these marketing automation systems. Easily manage marketing assets/campaigns or leads that enter your marketing funnel. While HubSpot Snap Pack supports CRUD (create, read, update, delete) operations, the Marketo Snap Pack allows you to do bulk operations on leads.
With these Snap Packs, quickly sync your assets and leads data across Marketing, Sales, and other functional areas and easily connect to event/survey applications such as Eventbrite, SurveyMonkey, or to Demand Generation tools such as Google Ads, Linkedin, and Analytics endpoints such as Microsoft Power BI and Tableau.
The Microsoft Power BI Snap Pack is also new and allows you to connect your Power BI instance to hundreds of data sources to bring your data to life with live dashboards and reports. Visualize your data and share insights across teams or embed these in your app or website. The Snap Pack helps you to post, push datasets, read, and edit so that you can easily query data, create/bind entities, import files, and update entities.
For an organization that has a heavy investment in the Microsoft ecosystem, the next Snap Pack the new Microsoft Teams Snap Pack allows you to easily integrate your Microsoft Teams into your enterprise workflows for customers, employees, and teams. This Snap Pack supports accounts such as OAuth2 User, Application, and Dynamic accounts to adhere to your enterprise security standards. Use it to send messages, perform channel operations, and perform team operations. .
Another key new Snap Pack with this release is the OpenAPI Snap Pack. Most API endpoints today adhere to the OpenAPI specification version 2 or 3. Leverage this Snap Pack to connect to any API endpoint with the published OpenAPI specification so that users can get all the needed documentation while they build their automated workflows. More efficiently connect to any generic endpoint without the need for specific Snaps.
Improved connectivity with other Snap Pack enhancements
Google Sheets Snap Pack now supports JSON based version 4 of the API rather than XML based version 3
Kafka Snap Pack updates now support reading/writing record headers and timestamps, provide option to choose one output document per batch. The later feature allows systems that don’t natively support streaming data to effectively work with Kafka messages by batching them together.
Amazon Redshift and Amazon SQS Snap Packs provide cross-account IAM support that allows organizations to trust and allocate roles with specific access privileges to specific groups or users.
Pushdown to any cloud data warehouse including Azure Synapse
Over previous releases, Snaplogic has introduced ELT support for Snowflake, Redshift cloud data warehouses so that you can do both ETL and ELT on a single platform. The ELT support is extended to Azure Synapse with this release. With ELT for Azure Synapse, you can accelerate data loading into Azure Synapse to provide ultimate flexibility to transform data by use of all computing resources across SnapLogic and Azure Synpase, thus reducing TCO and enabling a faster time-to-value.
With the SnapLogic platform yextract data from SaaS applications and databases with a vast number of Snaps. Once the data is in the staging area in Azure Cloud Storage, visually define data transformations, no need to write SQL. These visual transformations are converted into SQL statements and pushed to Azure Synapse for execution.
New features added to SnapLogic ELT make it easy to discover schema and SQL functions in the target cloud data warehouse. The platform provides suggestions for column names during LOAD, INSERT SELECT or MERGE INTO operations. The platform also provides SQL function suggestions when working with your target cloud data warehouse. To deal with large number of SQL functions various cloud data warehouses support, are grouped into different categories to simplify discovery.
Better Ease of Use and improved resiliency with the Platform Updates
The SnapLogic Intelligent Integration platform continues to evolve to make it easy for integration developers, whether they are technical or non-technical, to build and monitor integrations.
Universal Search, as the name suggests helps you search everything related to SnapLogic, all from a single search box. With the February release, it now performs pipeline searches in addition to the searches in Community, Configured Snaps and Documentation. This is not just a simple text based search. The Iris AI integration assistant provides more relevant search results across generic content (in community and documentation) and specific content from your org (such as pipelines or configured Snaps that you have access to). T
Figure 1: Universal search now supports pipeline searches
To efficiently monitor your integrations use the platform notifications to Slack. Users then get notified via Slack for any notifications from SnapLogic platform such as Daily API Usage, Snaplex Congestion, CPU usage, user activity, in addition to email notifications. Send notifications either on Slack Channels or directly to users.
Figure 2: Configuring Notifications to Slack
Enable Snaplex levels scheduling for all the scheduled tasks. This update reduces the time difference between the scheduled time of task execution and the actual time of task execution. With this update, your scheduled tasks won’t be affected by network disruption of the control plane helping your reliably deliver data that advances business processes and delivers insights.
Comments Off on Snaplogic iPaaS now even better – ask Synergy Software Systems »
The performance degradation of applications running on Windows, and VMs is getting inherently worse. This includes latency issues, queries or reports timing out, crashes, missed SLAs, back office batch jobs bleeding over into production hours, and the litany of “shadow IT” problems that wreak havoc.
Even after migrating to a brand-new flash array, performance problems return because the root source of the problem still exists. The fact is, 30-40% of performance is being robbed by small, fractured, random I/O being generated due to operating system I/O inefficiencies. This is a software problem that is solved by our software.
DymaxIO™ fast data software will quickly:
Increase performance automatically – no tuning required. Simply install and watch performance problems disappear.
Optimizes writes so maximum payload is carried with every I/O operation.
Speed up I/O intensive applications like MS-SQL/Oracle, CRM, ERP, File Servers, Imaging, Web Servers, Backups, VDI.
Install our software on your most troublesome servers and see 30-50% or more of the noisy, garbage I/O offloaded and performance dramatically improved.
Comments Off on 10 X Faster Reports on SQL! Run Time from 30 Mins to 3 Mins! Ask Synergy Software Systems »
