Database Migration

How to Approach a Custom Software Development Project

By | Custom Software
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…)
Oracle Gold Partner

What’s New in Oracle’s Database 19c

By | Oracle
Oracle is one of the leading providers of database services with decades of experience at the top of the pack. Their new product releases are always exciting to watch, improving upon their legacy of client-focused products and services. Last year they released database 18c, the first of a new annual release schedule, that featured the revolutionary Autonomous Cloud database along with Multitenant Architecture, In-Memory Columnar Architecture, and Native Database Sharding. This year’s database 19c continues to build on the foundations set in previous years with a focus on stability and efficiency. If you are thinking about upgrading or migrating to Oracle’s database 19c, here are a few special features to expect in this newest version. New Features in 19c This database version comes with some exciting enhancements to make your job faster and easier. While the main focus of this development cycle has been on stability, there are a few new features focused on automating and optimizing for the client. Let’s look at a few of these enhancements. Automatic Indexing – Indexing items takes time and can mean a lot of busywork for your IT team. With Automatic Indexing, Oracle’s 19c uses machine learning algorithms to identify items, map and (more…)

We’re Excited About SQL Server 2019, Here’s Why

By | Azure
Microsoft SQL Server 2019 is out in preview and it’s got some exciting new features. When Microsoft announced the release at their Ignite 2018 conference on Sept 24th, we couldn’t wait to see what was in store. This newest offering will continue to build on the solid foundation of SQL servers while expanding offerings of flexibility and further embracing big data by adding support for Kubernetes, Apache Spark, and Hadoop clusters. Embraces Big Data – Probably the biggest change to SQL 2019 is the ability to manage big data clusters. Big data has always been a bit of a gap in the arsenal of Microsoft’s SQL servers, but not anymore. With SQL 2019, Microsoft is fully embracing big data with Kubernetes. Kubernetes is an open-source container-based platform that represents exciting new possibilities for this SQL engine. With SQL on Kubernetes you will be able to can create high availability solutions with Linux containers and manage multiple data sources all in one place. Manage Relational and Non-Relational Data – The new engine can query data from a number of different sources, including relational and non-relational data storage. Microsoft has built in native support of Apache Spark and Hadoop Distributed File System (more…)

3 Top Analytics Tools To Boost Your Productivity

By | Azure, Database Technology Trends, Oracle, SQL Server
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 | Azure
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…)
Database Support

What’s the Deal with Oracle 18c? (part 2)

By | Oracle
Last week we introduced Oracle’s database 18c, and focused on the new release structure and its increased accessibility on cloud environments.  If you missed this article, here’s a link to go check it out now before heading back over for part 2.  – What’s the Deal with Oracle 18c (part 1) This week we are focusing on more specific feature enhancements to those areas you have come to expect in an Oracle product.  Starting with security and moving on to platform architecture we are looking at how this newest release helps simplify your data management.  We will discuss key features from Database 12c that get exciting upgrades in this new release. Stability – Several new features increase the platform stability, including Real Application Clusters, Recovery Manager and Flashback.  Oracle takes advantage of the multi-server architecture to deliver enhanced backup and recovery features, and reduced downtime for scheduled activities. Security Enhancements – Oracle has always prioritized security and this newest version builds upon that foundation.  With simplified and optimized security protocols, this database will help you prepare for more stringent security requirements coming up in the General Data Protection Regulation (GDPR).  Here are just a few ways Oracle emphasizes security in (more…)
Security

What’s the Deal with Oracle 18c? (part 1)

By | Oracle
Oracle’s newest release, 18c, is out, and I know what you’re thinking: what happened to 12.2.0.2?  Is it really time for a whole new version?  Well rest assured, this is not really a whole new version. It’s an entirely new method of naming that more accurately reflects what has been going on for years.  The old model of multiple release versions and patch sets wasn’t doing justice to the database.  The multiple release model led many to shy away from adopting any first release database for go-live workloads.  But honestly, for years the patch sets have been full releases in all but name. So now Oracle has decided to change its release schedule, and each annual release will be named after the last two digits of the year.  The plan is to speed the release of smaller changes while avoiding the massive overhauls that used to come with first releases.  What would have been database 12.2.0.2 is now 18c, and 12.2.0.3 will instead be 19. They have also gotten rid of the Patch Set Updates and Proactive Bundle Patches.  Instead we will now get Release Updates (RU) and Release Update Revisions (RUR).  So now that we understand the new release (more…)

Usability Comparison White Paper: Informatica vs. Ab initio

By | White Papers | No Comments

This report is an evaluation of two leading Extract, Transform and Load (ETL) tools, Informatica and Ab initio. In spite of long history of data ware housing, business intelligence and data integration industry, it is not an easy to decide which ETL tool is best suited for the organization needs as both Ab initio and Informatica offers a complete ETL solution and both are leaders in the Market.
The purpose of this usability study is to evaluate usability of each solution with respect to various criteria like cost, modularity to support seamless integration with other applications/tools, analytical reporting performance needs, volume and variety of data, loading performance, scalability, ease of use, self-sufficiency, simplicity, compatibility etc. If cost is not a concern Ab initio can be preferred for performance, processing of high volume of data and easy to develop perspective. Informatica provides a broad range of Data Integration products like Informatica PowerCenter, Informatica Data Integrator Hub, Informatica Cloud etc. and hence it boasts of a broader data integration capability. Specific offerings, future scope, ongoing enhancements, data integration capabilities, hardware and operating system requirements, architectural differences, maturity in various market segments etc. are detailed for both solutions.

Download the White Paper for FREE!!

Read More

Licenses and Maintenance

By | Blog, Preserved Content Pages | No Comments
Over the course of a year, your business goes through many changes, ups, and downs. Data changes and employees come and go, making it difficult to keep track of technology licenses. Maintaining the proper licenses is of the upmost importance in keeping your database running smoothly. With the right technology partner, maintaining updated and affordable software licenses and license maintenance becomes a hassle-free process – and one that you and your business no longer have to worry about. Hard To Find Licenses Jaguar CTS Power Builder Power Designer SAP Sybase SQL Anywhere Microsoft SQL Oracle Choose Dobler Consulting for your database license maintenance needs! As a trusted partner in the providing of software and database licenses, Dobler Consulting helps businesses in the designing, security, and management of their product licenses to fit their current needs and to create solutions for the needs of the future. Our dedicated team ensures that your licenses are kept on schedule, organized, and that the data may be collected into reports for easy sharing. We offer value pricing, as well as personalized service, scalable solutions, and assistance with long-term planning. As the experts in license maintenance, we are an SAP Value Added Reseller Partner and Microsoft Silver (more…)

ISUG User Group Meeting August 11th

By | Company News, Sybase | No Comments

Please join us on August 11th for our next meeting “The Future of PowerBuilder” which will include a PowerBuilder roadmap update, technical presentations from versions 12.5 and beyond, and a round-table focus group session on PowerBuilder strategy.

Our meeting will begin with an opportunity to network with your peers, followed by some brief introductions and any business the group needs to conduct. Then we’ll move swiftly to the first of our technical presentations delivered by Sybase Rockstar, Dave Fish who will be LIVE in person!

Read More