• 6 Apr 2017

    Exception handling by SharePlex when dealing with out of sync?

    The conventional methodology followed by SharePlex and most other replication solutions is to ignore out of sync DML within a transaction while applying rest of the successful DML to the target database. A transaction may span one or more objects, each having one or more rows, or DML. When posting that transaction, if any row runs into out of sync conditions, the default behavior is to simply discard that row, record...
    • 28 Mar 2017

    Getting Ready to Query the Foglight Performance Investigator Repository

    The backend repository for the Foglight Performance Investigator is based on Infobright , an analytics engine for machine generated data. However, you can connect natively via anything that can connect to PostgreSQL. The schema reference for Performance Investigator is available for Oracle and SQL Server from support. But how do we get setup to start building queries? We'll need some tools. Naturally, I prefer...
    • 14 Mar 2017

    Slay SQL Server Dragons In Your Sleep

    Once upon a time, there lived a great king, some would say the king of all DBAs. Every evening, he retired to his castle where he enjoyed long, blissful nights of uninterrupted slumber. He awoke at his leisure, well-rested and ready to rule his doma...
    • 9 Mar 2017

    Change Data Capture with SharePlex

    SharePlex replication can conveniently be used to maintain a change history target. Another industry jargon for change history is Change Data Capture or CDC. The CDC target maintains historical data on target as opposed to a copy of the source in case of a target in a regular replication. The CDC target is typically used for data mining. SharePlex gathers change data from source database to populate a change history...
    • 8 Mar 2017

    Quest 4 EDB Postgres Webinar

    Come one, Come all! #Quest4EDBPostgres Webinar Your Data is growing and growing and growing as is the cost of your databases and the thought of using an Open Source Database is really starting to look like a sweet way to go…..You’re not ...
    • 3 Mar 2017

    Forget Fake News, what about Fake Data?

    Over the past few months we’ve all seen how “fake news” and “alternative facts” can influence a presidential campaign, but it’s not just world leaders who can be affected. “Fake data” has the potential to cause chaos within organisations. People talk about being in the Information Age, but for organisations it’s more like the Data Age, epitomised by trends such as...
    • 21 Feb 2017

    The Future of Business Intelligence

    Business intelligence (BI) has long been associated with applications: dashboards and user tools for viewing and interacting with reports, and analyst tools for querying databases, analyzing, and modeling the results. Today a large number of these tools and software are designed to make it easier to visualize data and digest insights from it, both proprietary and open source. In many industries, the role and act of...
    • 14 Feb 2017

    Shared LOVE between Toad and Toad Intelligence Central – The Power Couple

    It’s Valentine’s Day, and power couples everywhere are celebrating. Have you noticed how the biggest power couples share the love by dedicating themselves to a worthy cause? Mark and Priscilla focus on human potential and equality . Beyonc...
    • 8 Feb 2017

    Secure Automation Using Toad for Oracle

    While Toad for Oracle has had Automation for a long time now it has been necessary to run it on your desktop. While this is an important feature this limitation made it not ideal for organizations where security is imperative, such as in t...
    • 7 Feb 2017

    Enhancement in SharePlex 8.6.6 for Replication from Oracle to Kafka

    If you are currently using ActiveMQ to consume data produced by SharePlex from Oracle, you may want to look into the performance gains with Kafka. The use cases for Kafka include website activity tracking, metrics, log aggregation, stream processing, event sourcing and commit log. There are several enhancements included in the new release of SharePlex 8.6.6 for replication from Oracle to Kafka. Support for multiple...
    • 6 Feb 2017

    SharePlex Can Help You Move Your Databases To The Cloud

    Almost every business is at least considering moving some of their IT workload to “the cloud” for any number of reasons. Databases are often a major component of this workload. SharePlex 8.6.6, certified for Cloud ...
    • 6 Feb 2017

    SharePlex Tuning 101 - A Journey, Not A Destination

    In recent SharePlex blogs , my colleagues and I have discussed using the Analyze Config command to help gather information to tune SharePlex , and the importance of tuning the target database. In this blog, I’ll attempt to put it all togeth...
    • 2 Feb 2017

    Build Queries Easily with Data Point's Query Builder - Overview

    Organizations today are bombarded with more and more data every single day. Data may come from traditional sources like an accounting system and B2C websites or from non-traditional sources like social media and smart devices. As a result, more and more people need access to that data to make decisions and grow their business. That's where Toad Data Point and it's visual Query Builder step in to the rescue. ...
    • 31 Jan 2017

    How to Resolve Backlogs in SharePlex Using Named Post Queues

    I’m sure we’ve all gone to an amusement park like Disneyland or Knots Berry Farm. We all love the thrill and excitement the rides give us. What we all hate though are the lines we have to wait in for each ride....
    • 27 Jan 2017

    Quest Customer Story: Tuning SharePlex with Analyze

    In an earlier blog, I showed how the SharePlex ANALYZE CONFIG command could be used to get a picture of how an application interacts with your database . It’s also a great tool to use to tune SharePlex, especially with very larg...
    • 26 Jan 2017

    Spotlighting the 3:00AM Call

    As a former database administrator , one of my biggest concerns was getting a call in the middle of the night. Sometimes the call would be a system alarm going off, but most of the time it was a member from an overseas we supported. There is nothing l...
    • 24 Jan 2017

    Tune Applications with Data Replication like a NASCAR Pit Crew

    At one time or another we have all watched some form of racing. Whether its Formula 1, Sprint Cars or NASCAR, we have sat in rapture as the cars go around the track until one crosses the finish line first…. Wh...
    • 20 Jan 2017

    "Sorry, you're just not my type." - Change Data Types Between Databases

    “Sorry, you're just not my type.” The one sentence, no one ever wants to hear, after the first date with someone you thought you had a made a great connection with. The sudden empty feeling in your stomach and the emotional letdown fr...
    • 19 Jan 2017

    Database Developers: Start 2017 by Developing at the Speed of Agile

    What’s the only thing harder than running hurdles? Running them while trying to catch up to someone going faster. And making sure that you don’t lose your 3-step stride. Or knock over a hurdle. Or completely lose your footing. What&rsquo...
    • 18 Jan 2017

    Quest Customer Story: Keeping Trucks on the Road

    One of the lesser known features of Foglight the ability to monitor log files. One of our customers has a process that collects and prints documentation required for truck movement. Before a truck can leave the loading d...
    • 17 Jan 2017

    Important Considerations for SharePlex Open Target Replication

    Frequently customers inquire why they experience slow post when replicating to non-oracle target. It turns out that they have only one post queue configured with hundreds of tables being replicated. The solution is simple, set up m...
    • 17 Jan 2017

    SharePlex, The MVP of replication football

    OK, so remember as a kid coming back to school after winter vacation and the first assignment that always seemed to be given was a 2-page essay on “What did you do for winter vacation." Yuck, how I hated those since most of the time all I ...
    • 6 Jan 2017

    Use SharePlex Analyze to Find Out How Your Application REALLY Works

    As a DBA, how many times have you asked yourself, your application team or your vendor, “What tables does this application update?” or, “How many changes does the application make to this table?” or, “What’s the no...
    • 6 Jan 2017

    Data, Information and Knowledge

    Nowadays with such a growing interest in data analysis / data science, there are abundant articles and material covering the skillset necessary to master those disciplines. Virtually, any blog, magazine, book, or specialized web site or portal descri...
    • 4 Jan 2017

    May the Shard be with You!

    Oh how I remember when the first Star Wars movie came out, all the action, adventure and of course the lightsaber. Who didn’t want a lightsaber? You could slice your way through anything with it. Well I never did get one, but what I did get was SharePlex and that’s just as good. Using SharePlex’s ability to slice data at the row level or the column level is just as exciting to me. This ability is called...