Appliedalgo

Address: 3/F, Citicorp Centre, 18 Whitfield Road, Tin Hau, Hong Kong. Please contact our sales for installment options.
.

Applied Algo ETL Suite
  = Quant Platform (From Financial Derivatives pricing, Program Trading to Supply Chain Demand/Sales forecast)
    = Scheduler ("Batch Processing", "Workload Automation")
      + Load Balancer ("Grid Computing")
        + Built-in ETL (SQL, FTP|NTFS - csv|xls|xlsx, OS commands ...)
          + Built-in Audit (Change Management & Security)

If you do a lot of number crunching, We're in the business to Make Life a Lot Simpler for you!
.
So what sets us part?
Tracking of Execution Parameters & Results: Every noteworthy provider support Job Scheduling, Job Chaining and Grid Computing. Among others, one feature that set us apart is that JobController automatically persist Execution Parameters & Result (For bat or SQL script jobs, even content of bat/SQL script be audited), whether it's a port scan, or result from a Time Series Analysis on a Portfolio Rebalancing platform. Data table is Automatically Created and Versioned, with column types either inferred from actual data or from schedule configuration.
Integrated ETL, Full Auditing any data files sent & received: We've bundled multitude of ETL services (SQL, S/FTP, NTFS/Shared Folder) with Applied Algo ETL Suite. For instance, user may schedule inbound/outbound FTP file transfer with JobControlller. JobController automatically audit file md5 signature, timestamps, and in addition, content of any csv|xls|xlsx file sent or received (Optional). Regular Expressions filtering with Recursive directory searches, optional purging after transfers, optional directory flattenning are among the many options we have provided for to help developers not having to re-write, or hardcode, common transfer and persistence|auditing logic.
No Integration Headache: Plugin model & computation coded in almost any language (Samples bundled in unmanaged C++/Java/.NET/Excel-VBA/SQL). Jobs can run on any platform (Windows, Linux, x64/x86 ...etc). We have made it very easy, in particular for developers who are less familiar with Linux platform, to run their analytics on Linux!
Simplicity, Stability and Scalability: Applied Algo ETL Suite is a platform that actually works for you, not vice versa. Let your developers focus on Core Analysis and Deliveries. Leave Platform and Infrastructure Plumbing to us.

Open Source and Commercial Alternatives?
DIY or Open Source? You can start building the platform with Quartz, ncron. But how much development lead time and budget will you need for Schedules & Executions persistence, updates and tracking? Automatic persistence of parameters, and computation results with validation & versioning support? Interfacing with jobs built in different languages (unmanaged C++, Java, dotnet, Excel/VBA...). Grid Computing support? ETL Services? Reconciliation? User Interface? And how much lead time will this add to your development life cycle? When was the last time you tracked down a memory leak or deadlock? We've solved all these problems for you, and put everything in one simple package.
Other commercial options? Most vendors don't have transparent pricing (BMC, Autosys, Stonebranch) and list their price tag on their web site. Industry leaders BMC Control-M starts around USD20k base, plus USD200 per job. You probably need an initial cash outlay of USD500,000 to start for an enterprise class implementation. And, nobody gives you automatic persistence and tracking of execution parameters, results with reconciliation support.
Your Alternatives.

Contact sales@appliedalgo.com, we'll get the package setup on your desk in minutes over Skype+Remote Desktop. We'll gladly provide the assistance to get you started quickly, No consultation fee. You may then make your evaluation.
Job Controller
Simplicity - Have a look at our demo video. You can compare setup with, for example, Hadoop installation process. With Applied Algo, everything is Embedded: GUI, Database and web servers. No separate install. It's completely Standalone application you can even run from your desktop (Or Windows Servers). JobController can schedule and dispatch jobs on any platform (Windows, Linux, x64/x86 ...etc).
.
Automatic Persistence - persistence/data table created and versioned automatically. No hard coded logic to save parameters/results.
.
Data Dictionary - Import data columns/types are persisted for later reviews/comparisons. For imported files, column types are automatically inferred.
.
No Integration Headache - Extension API is designed with Simplicity & Adapability as primary design objective, exposed via WCF (Web Service) and RabbitMQ. User may plugin computation of their own coded in practically any programming language. Worked samples bundled coded in unmanaged C++/Java/.NET/Excel-VBA. We've worked it all out for you.
.
Grid Computing: Multi-metric Load Balancing with Throttling and User Overrides: CPU/Memory/Disk Queue/Round-robin. Supports Node Affinity/Group to route similar jobs to appropriate node groups.
.
Per-cell/row Validation - user may configure desired data type, numeric range, even Regular Expression for each column.
.
Built-in ETL - Integrate data from: local folder/shares, FTP/SFTP, HTTP, SQL (Microsoft SQL server, Firebird, ODBC - MySQL). File types: csv/xlsx/xls
.
Audit any File Sent/Received - With built-in FTP/NTFS commands, any you sent/received are automatically audited: timestamp, size, md5 signature, and optionally file content (xls/xlsx/csv only)
.
Audit any SQL or bat script executed - Actual content of SQL and batch scripts are logged every executions.
.
Parameter Rendering - Example 1. "$T-1$" is rendered to 'yesterday'. Example 2. "$SWEEP|0.1-0.3|0.05$" will spawn 5 executions from 0.1 to 0.3 on 0.05 increments. Pre-rendered/Rendered parameters can be persisted on per Execution basis for tracking purposes
.
Enterprise Job Scheduling (Workflow Automation) - Recurring every sec/minute/hour/day/week/month/quarter...etc. Optional Skip Weekend and/or holiday. Parent-Child schedule relationship (Job Chaining), with conditional execution criteria.
.
Web Interface - Review execution status while you're away from your desk (Read-only/Supports Https/Embedded Web Server). Responsive Layout, fit nicely on Desktop + Mobile Devices
.
HttpCmd - Fetches data from Internet. Ability to replay Fiddler session (saz).
.
PlatformAuditProbe - Windows (64bit Windows 7 or above) Forensic Toolkit: Running Processes w/port#, arp, route print, open files handles, logon sessions, scan registry/drivers/scheduled tasks, Event Log, Recycle Bin, Browser History (Chrome/Firefox/IE), user/group list, folders/files scan (Please refer to "AppliedAlgo PlatformAuditProbe Guide" under "Documentation" tab)
.

Data Explorer
Per Cell Comparison - Unlike Winmerge, Data Explorer compare data on left grid against data on right grid Cell-by-Cell
.
Composite PrimaryKey - User may specify single/composite Primary Key(s) which is used in matching corresponding rows from left/right data tables.
.
Single/Multiple Comparison Target Column - User may specify single/multiple data column(s) as Comparison Target
.
Multiple Data Sources - (a) JobController Cache Database, (b) other database (Firebird, Microsoft SQL, ODBC - My SQL), (c) flat file (csv, xlsx, xls)
.
Execution Parameters, Data Dictionary, and Actual Processed Result - All accessible from Data Explorer
.
Feature Comparison with Commercial & Open Source Alternatives
Limitation: JobController and DataExplorer runs only on x64 Windows 7 or later. This said, jobs can be scheduled and dispatched to any platform (Windows, Linux, x86/x64 ...etc).

 

Quant Platform

Information System Change Management and Security Auditors

Harvesting Free Data from Internet

Getting Started is a Breeze: Installation and Rundown - Contact sales@appliedalgo.com, we'll get the package setup/demo from your desk in minutes over Skype+Remote Desktop. We'll gladly provide assistance to get you started quickly, No consultation fee. You may then make your evaluation.

Illustration of JobController Load Balancing capability, and how it's different from "Windows Tasks Scheduler"

Automatic Persistence w/Versionning (Data Table automatically created for you) with Versioning (In event of schema change)

CellValidation using SQLCmd: 1. ColValidator (Regular Expression + Predefined Validation Expressions), 2. ColTypeValidator/ColRangeValidator (Numeric Range Validation)

Please also set before execution: 1. PercentWarningBeforeFlaggingException to a loser threshold, 2. ApplyTransformation = true (Validation is part of "Transformation")

JobController Scheduling Parent-Child & Auto-Retry

Change Management - SQLCmd to detect database changes

Reconciliation using Data Explorer - csv file on left grid, xlsx on right grid

Embedded Web Interface (Read only) - No separate installation/embedded in JobController. Content wraps around nicely when user adjust browser/screen width. Fits nicely on Mobile Devices!

FTPCmd - RecursiveGet with Regular Expression Filtering. User may preview files to be downloaded from NTFS/FTP Previewer. The video further illustrates auditing capabilities offerred - from file content to file md5 signatures/timestamps/owner... etc

HttpCmd basic - download HSI constituents and last trade prices from Yahoo Finance

SplitColumnCmd - Split "Change" column into "Change" and "Percent Change"

TransformColumnCmd - convert Yahoo Ticker "0001.HK" to Bloomberg Ticker "1:HK"

HttpMasterListCrawlerCmd - Demonstrates how to download from http://finance.yahoo.com/q?s=$SYMBOL$ for each HSI constituents their cross sectional data (EPS/PE/DPS...etc)
.
Applied Algo ETL Suite (Enterprise Edition)
License Fee: USD 2250 (Per Instance)
.
Expiry: N/A, perpetual
.
Applied Algo ETL Suite include: JobController (Single Instance, Includes Builtin-ETL & Change/Security Scanning Utilities), DataExplorer (Single Instance), NodeController, PlatformAuditProbe - Everything you need to setup your Workflow Automation and Computing Grid all bundled in one package.
MaxNodes = 10 (Max # nodes connected to JobController), MaxSchedules = 500 (Max # Schedules loaded in Single JobController instance) - Additional package of (10 nodes+500 schedules): USD2250
.
Volume discount available. Special discount will also be available to ISV (Independent Software Vendors) who are bundling our products with their own.
.
Migration-integration-customization/Onsite support arrangements welcomed, but fees is to be discussed on case-by-case basis.
.
Contact sales@appliedalgo.com, we'll get the package setup/demo from your desk in minutes over Skype+Remote Desktop. We'll gladly provide assistance to get you started quickly, No consultation fee. You may then make your evaluation.

Following topology shows one instance of JobController running, and five instances of Data Explorer referencing the one JobController instance.
In this case, you will need 1 license of Applied Algo ETL Suite (Include one Data Explorer license), and four licenses of Data Explorer.
Maximum # NodeControllers which can connect to a JobController instance depends on MaxNodes.
Maximum # Schedules a JobController instance will host depends on MaxSchedules.
.
Applied Algo ETL Suite (Professional Edition)
License Fee: USD 325 (Per Instance)
.
Expiry: N/A, perpetual
.
Applied Algo ETL Suite include: JobController (Single Instance, Includes Builtin-ETL & Change/Security Scanning Utilities), DataExplorer (Single Instance), NodeController, PlatformAuditProbe - Everything you need to setup your Workflow Automation and Computing Grid all bundled in one package.
MaxNodes = 2 (Max # nodes connected to JobController), MaxSchedules = 50 (Max # Schedules loaded in Single JobController instance) - Additional package of (1 node + 10 schedules): USD325
.
Applied Algo ETL Suite (Academic Edition)
License Fee: USD 175 (Per Instance)
.
Expiry: N/A, perpetual
.
Applied Algo ETL Suite included: JobController (Single Instance), DataExplorer (Single Instance), NodeController, PlatformAuditProbe - Everything you need to setup your Workflow Automation and Computing Grid all bundled in one package.
MaxNodes = 5, MaxSchedules = 250 - Additional package of 5 nodes+250 schedules: USD175
Scan of valid student/Staff ID required (Up to one year after graduation).
.
Additional Data Explorer instances (For All Editions)
License Fee: USD 250 (Per Instance)
.
Expiry: N/A, perpetual
.
Single license for Data Explorer on any one machine is bundled with Applied Algo ETL Suite. Purchase additional license if you need to install Data Explorer on multiple machines.
.
Charity
License Fee: Free
.
Expiry: Perpetual
.
Whether your charge is to help educate unprivileged kids or under-funded medical research, we'd be happy to help.
Convince us, that what you're doing is non-profit, and is for betterment of all of us.
.
Evaluation
License Fee: Free
.
Expiry: 30 Days
.
Bundled MaxNodes = 4, MaxSchedules = 100
.
Upon expiry, you'd still be able to launch the application, but many functions will be disabled behind the scene
JobController and DataExplorer only runs on 64bit Windows 7 or above only. This said, jobs can run on any platform (Windows, Linux, x86, x64... etc). Free 30 days Evaluation License for Applied Algo ETL Suite will be sent to your mailbox upon registration. You may also download from here Documentation package, PlatformAuditProbe (Free commandline Windows Forensic Utility, 64bit Windows 7 or above) and RecursiveCopyFilesAndFolder (Free). To purchase Applied Algo ETL Suite, please click "Buy Now" button. Do include "HardwareId" (From application's "Licensing" tab) in your order submission. Detail installation instructions in "AppliedAlgo ETL Setup and Installation Guide".
.
First Name *
.
Last Name *
.
Email Address *
.
 

Installation/Setup

JobController

Extension API

DataExplorer

PlatformAuditProbe (Free)

ODBC Configuration