Sybase

Sybase Roadmap 2019

By | Sybase
It’s been a while since SAP released a roadmap for its Sybase portfolio. The wait is over; SAP published roadmaps for all its Sybase products. Sybase ASE, Sybase IQ, Sybase Replication Server, and SQL Anywhere. These roadmaps are available on SAP’s roadmap website https://www.sap.com/products/roadmaps.html Unfortunately, the publications are sorted by popularity, and the Sybase documents quickly dropped off the main page and into the large pool of thousands of roadmaps for all of SAP’s products. We made it easy for you to get to the documents through this blog post. Please share it with your friends and colleagues.   Sybase ASE   Highlights QP enhancements including diagnostics Enablement of secure key storage Data migration tool On-premise capture and cloud playback with workload analyzer Always-On Enhancements XOLTP Enhancements Download the Sybase ASE Roadmap 2019     Sybase IQ   Highlights Extreme-Scale Support for GPFS Export data in zipped format Improved query performance Increase the file-size limit from 4TB to 100TB SAP Software ecosystem integration SAP HANA Dynamic Tiering Heterogenues multistore tables 7-digit TIMESTAMP asynchronous table replicas SAP HANA Data Lake Download the Sybase IQ Roadmap 2019     Sybase Replication Server   Highlights Sybase ASE New Feature Support Sybase ASE 16 (more…)
BI Services and Strategy

Getting Lost in Big Data?

By | Database Technology Trends, Oracle, SAP HANA, SQL Server, Sybase
Let’s talk a little bit about big data. This is such an important buzz word in technology and data management circles these days. I think, however, that sometimes the nuances get lost. Big data is great, and has amazing potential applications for improving business processes, marketing opportunities, and customer identification, among others. Big data facilitates AI and machine learning, giving us unprecedented insights into patterns of behavior and process improvement opportunities. But the flip side of this is that big data also gives us massive amounts of ‘stuff’ to store and sift. I don’t mean to say that this data isn’t valuable. But without a solid strategy for utilizing and extracting meaning from this data, it can become costly clutter. Big Data has A Big History – Big data is a concept that has been around for a while. Data storage and processing machines were created throughout the 20th century to handle increases in record-keeping needs corresponding to cryptography and security efforts, as well as governmental programs like Social Security and tax management. The British developed Colossus in 1943 to filter through Nazi transmissions and identify patterns for code-breaking. This is essentially the first data processor of the modern era. (more…)

Oracle EBS – Improving Performance with Analyzers

By | Oracle
Oracle E-Business Suite is a fantastic suite of applications designed for the enterprise client to facilitate data management and analytics. The group of tools brings exciting possibilities to the Oracle client. But there’s more. The introduction of Analyzers as proactive tools improves performance and reduces troubleshooting headaches for the EBS client. If you’re using Oracle EBS, it’s time to check out the available Analyzers. What are Analyzers? These tools are essentially diagnostic support tools that can help not only identify issues but also suggest corrective action. They are designed to work alongside your current maintenance program to boost its effectiveness and your productivity. If your current diagnostics tools aren’t offering you suggested solutions, then you’re not using analyzers. The analyzers can also help if you need to open a service request with Oracle. They will gather important data to speed the diagnostic process and get a quick resolution. How do They Work? These tools can be scheduled ahead or run on demand by authorized users. They analyze your environment for known issues and create assessment reports with findings and recommended actions. The analyzers improve the health of your environments and significantly speed time to resolution for service requests. If you (more…)

DataOps – Developing Processes for Analytics and Data Management

By | Custom Software, Database Technology Trends
Big data and analytics mean big things for industries across all sectors. As data continues to grow, so do the applications. The newest challenge is streamlining the analytics process to improve efficiency and create actionable insights in a timely manner. That is where DataOps comes in. This newest development utilizes concepts learned from DevOps practices to simplify and streamline the data pipeline and analytics process. Let’s take a look at how this works. The Science of Analytics The analysis of big data is a complicated process of pattern recognition using statistical tools and algorithms. Your data scientists, engineers, and analysts may all play some part in this role. Managing the analytics process from an operational standpoint, as well as a statistical standpoint, can be time-consuming. If you want to have real, useable insights from your data it is imperative to validate both input and output data. It’s taxing to your analysts and means longer lead times on identifying key insights. But these steps are there for a reason, right? You can’t skip vital processes just because they’re lengthy. But you can innovate those processes and improve their efficiency. The development world has been working on this for a while with (more…)
Data Migration Support

Containers are In – Azure Can Help

By | Azure
Application development and deployment has come a long way in recent years. The introduction of containers opens the door for more lightweight, portable, scalable development. Add to that the capabilities of Kubernetes clusters and you get a new level of efficiency when managing application development, testing, and deployment. If your team is actively using Linux containers and Kubernetes clusters, it’s important to make sure your database products are supporting your efforts. Microsoft Azure has been helping its clients utilize and manage containers with Azure Container Service (ACS), now taking it a step further with the development of Azure Kubernetes Service (AKS). Why Containers? Containers have tons of benefits for API development. They are basically self-contained instances that run natively on your OS, maintaining configuration settings across multiple platforms. Imagine your developers working on an API on their laptop, which has one set of configurations, and then sending to another developer for review. Will the other environment behave exactly the same way? Impossible to know. With virtualization, you can eliminate these issues, but this is taxing on your system. Containers are lightweight so that you can run multiple containers on your machine without experiencing performance issues. Remember, these are running natively, (more…)

Simplify Data Management with Azure Data Studio

By | Azure
Azure is well known as one of the industry’s leading cloud providers, offering exceptional security, business management, and analysis tools in affordable packages. In this article we take a look at one of the best tools for editors and DBAs, the Azure Data Studio. This resource, formerly known as SQL Operations Studio, is a platform for building and editing your SQL queries with useful tools and an intuitive UI. If you are looking for a tool to seamlessly integrate your query editing with your database management, look no further than Azure Data Studio. This cross-platform tool makes managing your database, objects, and queries easier than ever. Initial Release and Rebrand – This product was released for public preview nearly 2 years under the name of SQL Operations Studio, and last fall was released for general availability (GA) under the new name, Azure Data Studio. Some customers questioned whether the Azure heading would pose problems for on-prem SQL infrastructures. The answer is no. Microsoft is dedicated to supporting all instances of SQL Server and related database products, including on-premises and hybrid infrastructures. This means that whether you are hosting on site SQL Servers or utilizing the Azure Cloud infrastructure, you can (more…)

Migrating from SQL Server to Azure

By | Azure, Database Technology Trends, SQL Server
Extended support for SQL Server 2008 has ended, and there is no better time to consider a migration to Azure. Continuing to run business applications and workloads on an unsupported platform will open you up to unnecessary vulnerabilities and potential legal issues. The risk is just not worth it. If you have been holding out for fear of complicated processes, there’s good news, Microsoft is making it easier than ever to migrate to Azure and take advantage of the benefits of cloud computing, including scalable resources and always up-to-date security features. With a trusted database solutions partner, your migration can be quick and painless. Check out this guide for more information about migrating from SQL to Azure. Why Migrate – If you are on SQL Server 2008, the answer is clear. Migrating is a must to stay on top of your database health and security. Now you may be asking, why can’t I just upgrade to Server 2019? You absolutely can. But this time is a perfect opportunity to minimize the impact of a cloud migration to reap the benefits of hosting your workloads in a cloud or hybrid environment. Utilizing the Azure cloud allows for scalable database solutions and (more…)

Connecting Devices Securely With the Azure Sphere

By | Azure
Customer experience is rising in importance for businesses these days, and one of the primary factors that customers value is efficiency. As more and more devices become connected, creating the Internet of Things (IOT), companies and products are able to provide enhanced services that can significantly improve the customer experience. The benefits of connectivity are clear, as are the roadblocks. Until recently, security was one of the biggest obstacles to overcome. That’s all changing with Microsoft’s new end-to-end solution, the Azure Sphere. It’s about Connecting those MCUs Microcontrollers are all around us, in toasters, ovens, microwaves, cars, thermostats, remotes, etc. These consumer products use what are essentially dedicated mini-computers, CPUs designed with specific tasks to achieve. These MCUs can be connected to the internet to improve performance, adapt to our interactions, and enhance customer experience, but very few of these MCUs are currently connected. This is because connectivity creates vulnerability for the device. Security breaches by bad actors can have disastrous results, and many companies have been staying away from the risk. But Microsoft was determined to create an environment that would allow companies to securely reap the benefits of connectivity with peace of mind. The development of the Azure (more…)

Oracle 19C Available on Linux!

By | Oracle
If you are a fan of open source operating systems, you’re not alone. These robust systems are gaining popularity as the era of proprietary restriction putters to a close. These resources have a lot going for them, from high compatibility to high security and flexibility. Industry leading database providers are taking notice and incorporating Linux compatibility into their products. Now Oracle has announced the exciting news that their Oracle 19c database is available on Linux, one of the most well-known open source operating systems. This opens up an exciting host of possibilities and brings the Oracle database to a whole new client base. 19c Focus on The Client, Adds Linux to Boost Compatibility Oracle 19C is the newest release of the 12c database line, continuing to contribute to the continuous release schedule established in 2018. This release schedule means more flexibility and stability of the database created by eliminating the major and minor release pattern. This newest release features fewer new additions than last year’s 18c, but has many enhancements designed to continue improving the user’s experience and ease of use (for more on new features, check out our blog post What’s New in Oracle’s Database 19c)To that end, offering (more…)

Oracle EBS Gets a Boost with New Features from Enterprise Command Center

By | Oracle
Oracle E-Business Suite (EBS) is a fantastic suite of applications to enable management of enterprise level operations. This comprehensive application suite does just that, providing clients with an end-to-end solution to accounting, HR, inventory and process management, and much more. With such a robust suite of tools, concerns about navigation and data visibility are always at the forefront. That is not an issue for Oracle EBS. With the addition of the Enterprise Command Center, this suite is more accessible than ever. Introduction of the Enterprise Command Center – In October last year, Oracle announced the release of the Enterprise Command Center (ECC) to improve reporting and navigation for their E-Business Suite. The ECC improves visibility and data navigation through tools and drill down dashboards that go to the transactional level. This represents the most comprehensive reporting tool to date, and significantly improves utilization of the application suite. Some of the best news about this release is that it comes without additional licensing fees. Anyone with an EBS license can begin using ECC free of charge. It is compatible with versions 12.2.4 and above. Additional Enhancements to ECC – As part of the ECC rollout plan, Oracle announced several enhancements due to (more…)