Data Management

One of the most common things that the developers of Synergy applications have been focusing on in recent years is opening up their Synergy databases for use by other applications, typically for reporting, dashboards and other BI-related objectives. To assist developers Synergex have created a sample environment that replicates Synergy data to a SQL Server database in near-to-real-time, and all of that code is available via an open source license. This session will walk you through the capabilities of that environment and show you how to get started with data replication.

Synergy DevPartner Conference 2018: Every software developer is responsible for ensuring that the data our applications collect, transport, and store is managed in appropriately secure ways. Learn how Synergy developers can ensure their application data is encrypted and secured when necessary. Steve Ives will discuss the capabilities for over-the-wire encryption with various Synergy client/server products, and we’ll explain how to get started with data-at-rest encryption for data in Synergy data files.

Synergy DevPartner Conference 2017: We all know and love ISAM, but are we using it to its full potential? From designing keys, optimizing files for better access, and understanding the powerful Select class, Richard Morris will enhance your understanding of just how powerful ISAM is and show you how to optimize your use of it. 10:42 IO Hooks 17:41 Utilities 29:35 Demonstration

Synregy DevPartner Conference 2018: Replicating Synergy ISAM and relative data to a SQL database in near-to-real-time has become quite popular in recent years, and we continue to maintain and improve an open source reference implementation that demonstrates exactly how to do it. Used by many Synergy developers, this solution just gets better and better, with new mechanisms being added as the need arises. If you’re new to data replication, this presentation by Steve Ives will give you an overview of the reference solution and show you how to get started. And if you’re already familiar with how the environment works, you’ll learn what’s been added since last year.

Synergy DevPartner Conference 2017: The ability to replicate Synergy application data to Microsoft SQL Server (or another relational database) isn’t new, and neither is the approach that is typically taken. But we’ve been enhancing this process, and now implementing data replication is much easier than it used to be. Steve Ives shows you the technologies used, the approach to take, and how to get started. 1:59 Use Cases 8:48 Workflow 17:10 Syntax 25:30 Replicating Synergy Data to SQL Server 32:26 Demonstration 41:50 Questions

Synergy DevPartner Conference 2017: Are you finding that even though you’ve replicated your data into SQL, it’s still difficult to pull all the right information into the reports you need to guide your business decisions? Maybe your next step is creating a data warehouse. A data warehouse can contain data from multiple systems, organized specifically to meet your reporting needs. Darcy Bellusci shows you the difference between transactional databases and data warehouses and what you need to do to take that next step. 7:15 Data Warehouse Terminology 9:25 Bus Matrix 13:10 Incremental Development 15:40 Example 27:03 Questions

Synergy DevPartner Conference 2017: Many of us are constantly searching for new ways to leverage the power of the data behind our applications. In recent years, it has become common practice to replicate our ISAM data into relational databases to make it available to a wide range of reporting and data analysis tools, but what tools are available? And how do you get started? Gateway DMS recently faced this dilemma. Jeff Gill demonstrates the answers and solutions they came up with. You’ll see their replacement for ReportWriter-based standard and ad-hoc reporting, as well as their excellent new graphical dashboard solutions. 19:23 Ad-Hoc Reporting Demonstration 29:26 Dashboard Designer Demo 33:22 Dashboard Client View Demo

Synergex DevPartner Conference 2016: The Select class, released in version 9, gave developers the ability to build elegant single file queries to retrieve and update Synergy DBMS data. In this presentation, Richard Morris explains how Synergy 10.3.3 takes data access to a whole new level with new capabilities that allow you to perform joins between Synergy DBMS files. This session provides a detailed look at this powerful new capability and explores the possibilities for your applications.

Synergex DevPartner Conference 2016: A Synergex customer, BusinessCraft, demonstrates how they are using the latest features in Synergy/DE to make their application more powerful.

A demonstration of the Synergy/DE xfServerPlus functionality and how it works.

A brief overview of the new Synergy/DE Data Provider for .NET. Learn about how it can significantly speed up the process of modular deployment to a new UI.

This video is a tutorial on KitaroDB from Synergex. It uses a key/value store with a small application written in C#. All of the application is already written except for the database interaction layer which is what this tutorial encompasses.