Oracle 19C Available on Linux!

By |
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…)
Database Migration

How to Approach a Custom Software Development Project

By |
If you have never participated in a custom software development project you may be wondering what to expect during the process. New experiences can bring uncertainty and concern, but custom software development projects don’t have to be intimidating. If you are not sure about where to start, then this brief assessment of how to approach the project and what to expect during the process will help you get your feet wet. At Dobler Consulting, we wanted to take the mystery out of the process with this simple guide to approaching a custom software development project, including some tips to bring to the table to expedite the process. Custom Projects are Customized – Remember, a custom software development project is a unique experience. Each project will be tailored to the needs of the client and the software. One of the benefits of working with a professional development team is the expertise and flexibility they bring to the project. Be sure to openly discuss any concerns about timeline and any business practices (end of year, quarterly reports, etc.)  that will be impacted by the project completion.  The Basic Steps – In any custom software project there are some basic project components that (more…)

Why OCI is the Perfect Platform for Oracle EBS

By |
Oracle E-Business Suite (EBS) is a fantastic compilation of tools for consolidating your enterprise functionality, management, and analytics. But what platform should you use to make the most out of your Oracle EBS? On-prem or third-party cloud infrastructure may not be making the most out of your Oracle applications. With Oracle Cloud Infrastructure (OCI) you will enjoy the fastest, most efficient, most optimized platform to get the maximum benefit from Oracle EBS. What is Oracle EBS? This suite of applications handles everything you need to run your enterprise level business functionality, including customer relationship management (CRM), human resources management (HRM), enterprise resource planning (ERP), and supply-chain management (SCM). The EBS collection is one of Oracle’s major product offerings with robust capabilities to consolidate your business management under one roof. With tools covering logistics, financials, order management, marketing, HR, and many more, Oracle EBS is an industry leading, comprehensive solution. Is On-Prem a Problem? If you are a current or future owner of Oracle EBS you may be wondering what infrastructure will best compliment this powerhouse of tools. More and more companies are moving away from in-house data centers because of the high cost of implementation and maintenance. These data centers (more…)

How Much Does Custom Software Cost?

By |
Whether discussing software or shelving, the word ‘custom’ is generally associated with high price tags, but that it a common misconception in our industry. When asked “how much does a custom software project cost?” our first, and shortest answer is, not as much as you think. Technology has evolved rapidly over the years, and these projects don’t have the same sticker shock that they used to. You may be surprised to hear that custom software can often be the more economical option. Our second answer is a bit longer, and understandably so. Each project is unique and comes with its own set of requirements. But rather than focusing on cost, it may be more beneficial to focus instead on the software’s ROI. That will give you the most comprehensive picture of any software’s feasibility and profitability. It’s About Finding the Right Solution When an organization is interested in custom software, it is because they have a need to fill, and custom solutions are like a square peg in a square hole, they are designed to be perfectly integrated into the workflow. The resulting efficiency means that a well-designed solution should save you money long-term. They also typically increase process automation, (more…)

Why Choose a Custom Software Solution?

By |
If you are familiar with the concept of custom software but still convinced it is not right for you, think again. Custom software isn’t just for the top tier businesses, projects are created on a case by case basis according to each client’s specific needs and budgetary constraints. These solutions have the potential to take your business to the next level by improving your operational efficiency, promoting and enabling growth opportunities with scalability, and improving data security. Here are 3 reasons to consider a custom software solution for your business. Improve Efficiency with Automation – Process automation creates a major opportunity for more valuable resource allocation. If your organization currently wastes time on repetitive tasks like data entry, inventory management, purchase order validation, etc., then you are losing valuable time and money. Your full-time employees are a valuable and costly resource. Why waste their time and effort performing routine tasks? Increasing automation will improve your organization’s efficiency. With custom software solutions your tools will be designed to most effectively optimize your process needs for the best possible fit into your organizational process, freeing up your manpower for more strategic operations. Increase Your Scalability – Ill-fitting software or manual data management (more…)

What’s New in Management Studio Version 17.6

By |
Microsoft continues to make great strides in improving SQL Server Management Studio (SSMS). Version 17.6 comes with some impressive new features and bug fixes that enhance your user experience. Azure SQL Database Managed Instance Users If you’re using the newly developed Azure SQL Database Managed Instance, a new model of Azure SQL Database, you should definitely consider upgrading to SSMS v 17.6. One of the most notable changes is the added support for some of its most common management scenarios. After you complete the upgrade, you can expect a much more efficient support process if you encounter issues with the following: Databases - Creating, altering, backing up, and restoring databases are all fairly common tasks in database management, which makes their processes easy to support. Object Explorer - All technical issues that arise while using Object Explorer to manage objects in each SQL Server instance are eligible for support. SQL Linked Servers - You can relax when using Linked Servers to connect to other database instances on a remote server, same server, or an entirely different machine. The SQL Tools Team has you covered. SQL Agent Jobs - Your automated execution jobs/tasks usually consist of several steps. Any disruption can (more…)

What You Need to Know to Migrate Your Oracle Database to the Cloud

By |
Many organizations are making the switch from on-prem to cloud databases. These cloud native warehouses can provide more reliable and timely access, cost-efficiency, and automated backup and recovery. If you are using any on-premises version of Oracle Database, you might want to consider whether moving to the Oracle Database Cloud is right for your company. There are numerous migration methods, and the process can be very simple when you work with an expert. Try reviewing these key factors prior to selecting a migration method and save yourself some additional time. Know Your On-Premises Operating System/Platform and Version - Ensure you have a full understanding of the platform your company is currently working on along with the version. Are you using Windows, Mac OS, or Linux? There are some operating requirements that will be applicable depending on the migration method you are interested in adopting. Know Your On-Premises Database Version & Cloud Database Version - Are you currently using Oracle Database 11g, 12c CDB, or 12c Non-CDB? Depending on your response and the cloud version you are transferring to, Oracle has multiple migration options for you to choose from. For example, a move from on-premises Oracle Database 11g to Oracle Database (more…)

3 Top Analytics Tools To Boost Your Productivity

By |
Data analytics have become a major focus for companies determined to be competitive in the market. Leaders need to be able to access and analyze timely data quickly to help drive business decisions that will sustain their companies’ competitive advantage. Thankfully, the growing technology market continues to make this possible. Companies already have numerous analytics tools to choose from, and the options will continue to grow. We will now discuss three of the top analytics tools you should consider before making your next strategic move. 1. Microsoft SQL Server Analysis Services (SSAS) – SSAS is an innovative processing and data mining tool within the Microsoft SQL Server. It analyzes large amounts of data, provides business intelligence reports, and can be used to create business models to support business decisions. All data is stored within a data warehouse, and users can access to create cubes that allow faster analysis. These cubes are multi-dimensional and can be viewed in various ways. Imagine the data as a pivot table that can be modified using certain dimensions and attributes. Multi-dimensional expression (MDX) is the language used to query a cube. Compared to other leading analytics tools, Microsoft SSAS is less complex and much easier (more…)
Server Data Migration

A Look at Azure Security Center

By |
You can’t be too careful with the cloud. More enterprises are using cloud and hybrid environments for their organizational workloads. Microsoft Azure is a major player in this trend. In an assessment of cloud platforms and services provided by iDataLabs, Azure holds over 19% of the market share, the second biggest slice of the pie. This industry trend means more companies need to be prepared for cloud level security. Microsoft offers an in-house security solution in the form of Azure’s Security Center that is convenient and powerful. We want to talk briefly about what it does, and some new and exciting enhancements that have increased its scope as an organizational security tool. What is Security Center? This is Microsoft’s unified security solution that provides a platform for protocol deployment, monitoring and prevention. The service is available to Azure subscription users as a free extension or as an additional fee (Standard subscription). The free version covers your Azure cloud. But if you use hybrid environments and additional platforms, the Standard subscription allows you to deploy Security Center across your whole system. Intelligent and Adaptive – Azure Security Center sets itself apart from other security protocols with its adaptive analytics. Using machine (more…)

Data Science: Making the Most of your Big Data

By |
As today’s trends bring more and more data to our fingertips, the next challenge is figuring out what to do with it all. The insights gained from proper data analysis have major implications for business. Proper data analysis takes careful consideration, appropriate infrastructure, and understanding of data science. What is Data Science? This is the process of using data to draw conclusions or predict outcomes. You probably use data science already. For example, a restaurant owner may keep records of which dishes are ordered. Over time, he may notice that chili is ordered more frequently on rainy days than on sunny days. This may encourage him to prepare larger batches of chili when the weather calls for rain. This is a very simple example of data science. You can see how understanding patterns and trends in data can help prepare your business. Data science can contribute to the following business improvements: Streamline Processes – You can use data science to analyze your business processes and identify areas to streamline. Looking at your website usage statistics may show areas where your potential clients are losing focus, or identify slow and frustrating pages in your online ordering forms. Identifying these patterns can (more…)