Synchronize Sybase SQL Anywhere to AWS¶

Sybase SQL Anywhere to AWS

Continually export Sybase SQL Anywhere data to AWS Aurora MySQL.

Great to consolidate/merge information on the cloud from multiple locations that use SQL Anywhere databases, then build your own Data Warehouse and deliver Business Intelligence.
On top of AWS build web applications using data pulled from on-prem SQL Anywhere.

Before You Begin¶

Have your AWS account linked it to our API. Not sure? follow here.
Complete registration on Factor BI console
Create Service and Activation keys and configure service, --> details here.
Download Bipost Sync program for Windows.

Bipost Sync¶

SQL iAnywhere to MySQL Aurora

Service No.: 36 digit number, it may look like this: a1bcd23e-4fa5-67b8-cd9e-f0123abc4567
Activation No.: 24 digit number, it may look like this: 5990ab12c3de45f6a78bc90d
Engine: SQL Anywhere
System: Custom...

SQL Anywhere
DSN	System DSN name, 32 bits
User
Password

General Settings¶

Bipost General Settings

Specific Bucket:¶

Enter your Bucket Name. It may look like this: bipostdata-acb123456789012
It is available on your AWS Account \ CloudFormation Stack.

Download Data¶

Leave unchecked.

Recursive Sync¶

Use only to upload historic data. It optimizes upload by extracting and uploading one day at a time for a given date range.
Always use along with customData.json so you can configure the date field to use for each table.
NOTE: For daily sync, instead of using Recursive Sync, dynamically parse a date range into customData.json ==> Examples here.
More info about this feature see Recursive Synchronization

Tenant¶

This allows to sync several on-premise databases to a single Aurora-MySQL database and differentiate them with tenant_id. Great for consolidation!
Activate and type a string to add a fixed column to every table that is synced.
This fixed column will be included in the PRIMARY KEY on Aurora-MySQL.

Tables to Sync¶

IMPORTANT: Tables and subsets of data to synchronize are specified in customData.json file ==> follow here.

Schedule¶

Bipost Schedule

If you want automated execution of Bipost Sync, then set the Hour desired and click Schedule.

This will create a Windows Task that will run daily. If you want a different schedule, then open Windows Task Scheduler as follows.

Control Panel \ Administrative Tools:

Windows Administrative Tools

Windows Task Scheduler

If you manually create a task to run biPost then use argument: post

Windows Add Argument Task

Check for Updates¶

New versions of Bipost Sync can be checked using Help \ Check for Updates.

Bipost Check for Updates Menu

Bipost new version available

Sync multiple databases¶

If you are going to synchronize two or more databases from the same Windows host, create separate Bipost Sync folders for each database. Then customize each folder with the desired data set as explained here.

Oracle Micros RES 3700 POS Business Intelligence Use Case¶

Oracle Hospitality Point of Sale system works with SQL Anywhere database. You can daily export data from several restaurants and consolidate them on AWS at scale.

Make Micros POS reporting affordable at scale. Create KPI's, Dashboards and Business Intelligence analytics using Google Data Studio or AWS QuickSight.

Micros RES Cloud Consolidation

Oracle Micros RES database tables & documentation download.

Oracle Hospitality RES 3700 Installation Guide.

Keywords: Micros 3700 RES | Micros database files | Micros cloud reporting | merge multiple locations | Micros AWS | iAnywhere.Data.SQLAnywhere.v4.0.dll

Contact Us¶

Questions? Send us an email: info@factorbi.com