Replicating Synergy Data to Relational Databases | Tech Days 2019
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.
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.