Data Management

Remote data access, Synergy DBMS, and database connectivity are all covered here. Check out these videos to learn more about methods for accessing and storing data with your Synergy application. A few of our favorites delve into data replication and accessing ISAM data.

Data Security Basics | Tips

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.

ISAM Refresher and Accessing ISAM Data | Synergy/DE

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

SQL Replication: Here’s What You Should Know | Synergy/DE

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.

Replicating Synergy Data to Microsoft SQL Server | Synergy/DE

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

Building a Data Warehouse from Replicated Data | Synergy/DE

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

Ad-Hoc Reporting and Dashboards Based on Replicated Data | Customer Demo

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

Select Enhancements. Exploring the powerful new JOIN capabilities | Synergy/DE

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.

BusinessCraft's Evolution to version 5 | Customer Demo

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.

xfServerPlus Demonstration | Synergy/DE

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

Data Provider for .NET | Synergy/DE

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.

KitaroDB | Open Source Products

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.