Quickly Integrate your SQL Database with Podio using Data Synchroinsation Studio

DOWNLOAD NOW
[Windows 64-bit Installer]

Learn How to Use Data Sync to Integrate Podio with SQL

See how you can use Data Synchronisation Studio to synchronise data between SQL Tables and Podio Apps with no-code
Using Data Sync you can quickly and easily sync data into your Podio Apps from sources such as SQL tables and views, and CSV files. This demo covers how to quickly connect to SQL and Podio with the connection library, map your source columns to the target via the schema map, add a lookup, and then compare and Sync your data with Podio.

Benefits

Ease of Use

The performance of Data Sync at design time as well as at runtime make it incredibly easy to build out your integrated processes. Projects can be setup and configured in minutes rather than days or weeks. So anyone in your team can make and edit projects.

Reliability

Data Sync & Ouvvi make for an incredibly reliable Data Integration Platform. Data Sync’s Data Reconciliation Engine married with Ouvvi’s reliable Queue based scheduler ensure a robust and reliable data integration.

Customer Service

Our customer support is here to ensure that you have success with your Data Integration. We can help you get answers to your questions very quickly not days later.

The Integration Process

You can apply this process to any type of data integration task to do with Podio.

Connect to your Source & Target

If we take an example where our data is listed in a SQL table and we need to get these records into Podio to link customers and projects inside our Podio workspace.

We start by connecting to the source data to the SQL table and the target to the Podio App. Saving each of these connections means that we can use them again in the future and lookups are a simple drag and drop.

When creating projects you need to consider the order data needs to be added: The customer records need to be added before the projects, the projects before the tasks and so on.

Podio - Map Columns and Lookups

Map & Lookup data in other apps

The next step is to map the columns from the source to the target in the schema map.

Using Data Sync and the built in connection library you can quickly create lookups into other Podio Apps to expand your current data.

So if your project app looks up the customer details in the customer app then you can add a lookup on either a customer id or customer name to ensure that you have the data you need, where you need it.

If the data isn't contained in your Podio Workspace then you can create a lookup to any source to get the data you need.

Compare & Sync

To finish you just run a comparison between the source and target, where you can preview the changes about to be made.

You can see the changes broken down into additions, updates and deletes. By default any deletions are disable to make sure your data is safe from accidental deletes.

When you are happy with the data, simply click Synchronise to apply the changes. Your data is then added to Podio.

Saving this project then means you can re-use it whenever you need to and make changes to the schema if your data fields change.

Podio - Compare and Sync Results

The Data Sync Run Tool

As most integration tasks require more than one project, you will need somewhere to collect them. Use the Run Tool to collect and order your Podio projects and Simego Online to automate and schedule them.
Data Synchronisation Studio Run Tool Screenshot

Build out your Project

Build out your integration project with multiple step types and source control

The Run Tool enables you to run multiple tasks in a sequence to form a full integration solution which you can then schedule using Simego Online, Ouvvi or Windows Task scheduler.

Simply add your projects to the Run Tool either creating them from scratch or by drag and dropping from your file explorer, and then order these in the order they need to run. You can add a project status report step so that you are notified whether the project runs, succeeds or fails. If you want it to only send a message if it fails, just change the run condition. Download, copy and delete files, execute SQL statements, execute your existing scripts, it is all possible with the Run Tool designer.

As the Run Tool is based off the file system it makes it easy to add your integration project to source control. This means you can follow a full DevOps path with your development and testing systems ensuring that everything is fully functional before deploying to production.

View Errors and Logs

Quickly diagnose errors, keeping any downtime to a minimum
Run Tool Logging

The Run Tool makes it quick and easy to see how your steps are running and if your project completed successfully.

The built in logging is accessible from the logs tab and will show you the full error exception so that you can understand what has gone wrong.

When designing and testing your steps you can quickly view the error in the Run Tool either by right clicking on the failed step or by going to the logs tab.

When you have built the project and it is running automatically on a schedule, you can view the log file for that run from the local log folder inside your project directory. However the sooner you can find the error the sooner you can fix the issue. Adding the Project Status Report step to your project enables you to be notified as soon as an error occurs.

Schedule and Manage your Integration Projects

Use Simego Online to schedule and organise all of your Run Tool Projects
Simego Online

Once you have the Run Tool configured you can schedule it to run when you need by using Simego Online. As Simego Online is a cloud system you can access it wherever and whenever you need.

Just install an agent onto your machine, enter the path to your project, add a trigger and your jobs will run as and when you need them.

All of the data processing is handled on your machines, so you can be confident that no information is leaving your network. There is no requirement to expose any of your data outside of your own system.

Don't forget you can also add additional projects outside of Podio. There are many options available, so go ahead and give the Simego products a go today!

DOWNLOAD NOW
[Windows 64-bit Installer]

Data Synchronisation Studio Features

Connect to Files, SQL, SharePoint, Dynamics, Office 365 and many other data sources

  • Import + Export

    Import your data from various Data Sources quickly and easily. Apply Schema Mapping and Data Type conversion on the fly and Export your data to various formats.

  • Data Reconciliation

    Compare your Data with the target Dataset and create a difference Change set of ADD, UPDATE and DELETE actions to apply rather than drop all data and re-import.

  • Data Preview

    Preview all your data before any changes are applied and select which data you wish to change. Prevent those Oops moments!

  • Transformation

    Simple and Complex transformations via Calculated Columns, Dynamic Columns and Lookup features.

  • Lookups

    Use powerful Lookups to lookup data in other Data Sources, Create Mapping Transformation tables and more.

  • Connection Library

    Manage your connection configuration via the Connection Library and quickly and easily connect to data sources from the library.

  • Schedule

    Automate the execution of your Data Synchronisation Studio packages with Ouvvi, Task Scheduler, SQL Agent, Command Line or API.

  • C# Code

    Use the .NET Framework to create your own powerful Data Transformation Expressions. Execute your own code before and after the project runs and more.

  • API

    Use Project Automation to hook into the process and run custom code.

Valued and Trusted Worldwide

Customer Logos