Saitology natively supports a number of databases.
This use case explores Snowflake.
In this introductory post, we navigate to
the sample Snowflake database,
select customers whose country name starts with "United"
and then generate Excel spreadsheets
with customer detail data
for each country.
Auto-generate Pre-Formatted Excel Files
Do you use Excel or work with data? Here is a challenging
real-life use case:
You need to collect data from multiple excel spreadsheets and
populate a premade, nicely formatted Excel template,
with specific sheets and locations.
Each excel file has 5 sheets or tabs, and they may appear
in random order in the data files. And repeat it for all of
your clients. Repeat monthly. Quite interesting, right?
Truly this is quite a challenge even for professionals with
various tools and programming technologies.
Saitology makes this whole process a pleasantly easy exercise
with its data flow environment.
No scripting. No macros. No coding.
Chrono-Timer: A Free Utility App
As a software company, our developers create a number of
utilities that make their own work easier. It is one of
those tacit benefits of being a software engineer.
One such utility that nearly everyone has fallen in love with
is our ChronoTimer. As expected, it shows the time,
but it also shows the elapsed time
since the start or the last reset.
Hope you find it useful. Click the image to download it,
unzip to a location of your choice, and run it.
Currently only for MS Windows.
Calculating End of Year Employee Bonuses
Here is an easy way to calculate employee bonuses,
with a special twist: some employees will receive a
special amount provided in a separate file.
Note that all data employee data is, and remains,
in the database, safe and secure.
Decimal Data Errors on IBM i
One way or another, everyone faces data quality issues.
For IBM i users, decimal data errors seem to be a
regular concern as there are always people in search of
solutions to this challenge on the web.
Luckily Saitology Campaign makes finding and fixing such
data errors incredibly simple.
Enjoy the video and please get in touch to explore
what it can do for you.
Pocessing JSON on IBM i
This may quite possibly be the easiest way to process
JSON data and load it into IBM i.
You simply choose your file, click on attributes you want
from the JSON document, and then you are done :-)
Although the video focuses on JSON, you can do the exact
same thing with most other document types, including XML,
YAML, CSV, Excel, Google Sheets, and so on.
All with the same ease and flexibility of Saitology's
click-and-go interface.
While we use IBM i as the back-end database here,
there would be absolutely no difference if it were
another database including
Snowflake, Oracle, SQL Server, MariaDB, etc.
Modernize RPG code on IBM i
News reports suggest a consensus around RPG, Cobol, CL on IBM i:
- It is hard to find RPG programmers
- Young people are reluctant to learn these "old"
technologies and find it hard
- Current programmers are approaching the retirement age
Fortunately, Saitology solves all of these problems.
One will be more productive with Saitology than if using
the legacy languages listed above.
Saitology is a skills multiplier.
Modernize RPG code on IBM i - Advanced Version
The original RPG payroll application was too simplistic.
Improving that in RPG would be quite a challenging task.
With Saitology, it is quite easy to make changes to your logic
and accomodate fast changing business rules in your graphs.
Schedule Jobs Report on IBM i
Easily calculate all Key Performance Indicators
your company relies on.
Here is an example that shows all the jobs scheduled
on your IBM i.
It is just as easy to share them as raw data or
as beautiful interactive reports and dashboards.
Search Through Spooled Files a la Google
Now that spooled files are easy to manage,
it opens up so many new opportunities to improve
your business requirements and daily tasks.
In response to an interesting piece of feedback,
here is a video showing how you can build a custom
search engine from scratch for your spooled files.
Spooled Files Have Never Been This Easy
Here is a quick review of how easy it is to access
spooled files on IBM i and process them.
The video lists all of the spooled files.
Then it saves them as files on your local drive.
Given the extensive capabilities of Saitology Campaign,
we could do so much more though given your business
requirements.
Python task flow, orchestration & visualization
Here is a state-of-the-art solution to a common challenge
facing most everyone with organizing their Python scripts,
with a few extra steps to perform on each one.
This is one way to do it in Saitology.
Please note that all of the requirements
(e.g., saving to database) are all handled.
Find files modified within last n hours
If you work with data, you will frequently face the need
to selectively process some files.
Whether by modification date, location, naming pattern,
size, or what have you, you will need the flexibility
to select just the files you need, when you need them,
and process them then and there.
Fortunately Saitology makes the process easy and intuitive.
It gives you all the power to do that and more.
An Interesting Report
Imagine you have data from the results of a survey.
How do you aggregate all the questions and answers
from all the responders and provide a tally? report
It is easy in Saitology
as long as you can phrase it in English :-)
SQL Challenges Become No-Brainers
Tricky SQL questions are easily solved in Saitology!
Here is one requiring finding countries
at least thrice the size of their neighbors.
It is easy in Saitology
as long as you can phrase it in English :-)
Extracting Data From a Highly Structured Web Site
Continuing with webscraping theme, here is another one
that illustrates just how powerful Saitology is when it
comes to extracting highly structured data sources.
With a visual click and select interface, with just
a few mouse clicks, you get all the data you want in
a nice structured way while preserving all the relationships
among the different pieces of data.
Word Frequency Analysis of "War And Peace"
Saitology can grab data from almost anywhere and
get it ready for your use easily and automatically.
As a testament to its flexibility and power in this aspect,
here is a user case that does web scraping from a website
with no set up.
Web scraping is one of the components of the tool; and
there are many others. The focus here is the ease of use:
no coding is required. Users click and select items of
interest and the system does the rest on a schedule.
Everything is under database transaction control so there
is some added steps that are invisible to the user.
More Coming Soon...
New informational videos are uploaded frequently.
Please come back later to see more content.
As a software company, our developers create a number of
utilities that make their own work easier. It is one of
those tacit benefits of being a software engineer.
