How do we start Ellucian Banner 9 Upgrade?

Migrating Ellucian Banner 8 to Banner 9 is now the biggest project in Higher Education area. Many of universities and colleges are now working hard for this: recruiting the team, organizing the resources, building up new hardware and software platform, and so on.

Yes, upgrading to Ellucian Banner 9 is a very challenging job as it introduces much hardware and software prerequisites before performing function level upgrade.  Those are now widely known: Ellucian Ethos Identity, Application Navigator, Ellucian BEIS SSO Manager, and Ellucian Solution Manager. All of them are required for Banner 9 upgrade. But, where may we get started? The quick answer is Ellucian Solution Manager.

From project management perspective, at the very beginning, we need to create plan, schedule, and upgrade path ...

Read More

Utilizing Information Schema for Database Migration

SQL-92 is a milestone in setting up the standards of SQL query language for relational database. In SQL-92, an important feature is to define Information_Schema – a series of read-only views for retrieving database metadata.

Information_Schema is quite useful when porting one SQL-92 compatible database to another, especially when you have large number of backend scripts which involve metadata operations.

Information_Schema may bring lots of convenience when we build up database-driven solutions since usually these solutions use database metadata quite often.

Let’s see which major databases support SQL-92 Information_Schema :

RDBMSRankSQL-92 CompatibleInformation_schema
Oracle1stOracle data dictionary: desc dict;
Open source project: ora-info-schema
MySQL 5+2ndMySQL Info Schem...
Read More

What Confluent can do for data synchronization?

Confluent is a streaming platform based on Apache Kafka. Apache Kafka is a distributed streaming platform which offers three key capabilities:

  1. It lets you publish and subscribe to streams of records. In this respect it is similar to a message queue or enterprise messaging system.
  2. It lets you store streams of records in a fault-tolerant way.
  3. It lets you process streams of records as they occur.

So Kafka is good for:

  1. Building real-time streaming data pipelines that reliably get data between systems or applications
  2. Building real-time streaming applications that transform or react to the streams of data

Now let’s get back to Confluent. Confluent offers Confluent Open Source and Enterprise editions. We may see Confluent a wrapper of Apache Kafka...

Read More