oci

Setup OCI DBTools Connections with an ADB Access Control List

TL/DR: To use OCI Database Tools (DBTools) Connections to connect to ADB with a public IP and access control list (ACL), DBTools requires the use of a DBTools Private Endpoint (PE). DBTools connections setup with a PE can route traffic to the ADB

oci

Database Tools Connections

TL/DR: if you are an Oracle Cloud Infrastructure (OCI) customer running Oracle Database or MySQL in OCI, use Database Tools (DBTools) private endpoints and connections to simplify database access in the cloud. DBTools connections support a number of use cases, for example: * They

Java

Modern Switch in Java

Whether we are learning to program in an object-oriented language (such as Java) or one where code executes logically from top to bottom, decisions need to be made about what happens next. We can call this branching.

Go

Hello World Server in Go

Howdy! I'm diving back into Go (golang) for selfish reasons and, in my own time, learning about how Go modules help deal with Hypertext Transfer Protocol (HTTP). Before getting into HTTP in Go, I started with plain old Transmission Control Protocol (TCP) sockets.

SVG

Exporting Basic SVGs From Photoshop

For simple tasks, like mocking up SVG icons to embed inline on a web page, I don't always want to break out Illustrator, setup a canvas and fiddle with curves. If I am already in Photoshop switching applications takes time and mental energy.

Life

Technical Debt or Contextually Correct Examples

The past few years have been a period of significant recovery. One in which I have invested in my family and myself. When I started writing "way back when," I figured, "Just write about the stuff you find interesting and see what sticks."

Nashorn

Update Knockout.js View Models in JavaFX WebViews from Nashorn

Learn about updating Knockout.js models from Nashorn / JavaFX which is a challenge because the Model and Controller code are not running within the browser.

Oracle SQLcl

Preview of Charting in SQLcl via Oracle JET, Nashorn and JavaFX

This is an example of connecting SQLcl and Oracle JET using the Nashorn scripting engine. Oracle JET application templates are deployed behind the scenes and data is loaded interactively from SQLcl sessions.

Oracle SQLcl

Bridge the SQL-Java-JavaScript Divide with Nashorn and Oracle SQLcl

Learn about writing Java classes and JavaScript programs for use with Oracle SQLcl and other Nashorn-based applications that run on the JVM.

Oracle JET

Integrating Vue.js with Oracle JET

Before we get started, and for those of you who don't know what Vue.js is, here is a short description from the project website [https://vuejs.org/]. > Vue (pronounced /vjuː/, like view) is a progressive framework for building user interfaces.

Oracle JET

Using the New Oracle JET CLI

This is a quick post about using the new Oracle JET CLI (JavaScript Extension Toolkit Command Line Interface), hereafter just ojet. This CLI is new as of May-2017. Prior to using ojet, the approach to deploying Oracle JET scaffolding was to leverage a series

Careers

Infrastructure is Dead, Long Live Infrastructure!

If you have worked in the infrastructure and software installation business for Oracle EPM and BI over the last ten years, it may look like tough times ahead. With Oracle driving business to flood the market with Cloud solutions, the number of clients signing

Node.js

Oracle JET Native Apps with Electron and Node.js

Oracle JET (JavaScript Extension Toolkit) - hereafter JET - is a collection of open source JavaScript technologies for building client facing web applications. Oracle had this to say about it:

Node.js

JSON to SQLite on the Raspberry Pi with Node.js

Whatever label you put on it - Cloud Computing, Something as a Service, Web Application, Etc... - there is no shortage of hosted software running on other people's

Swift

Sending HTTP POST Requests to ORDS from Swift

In this example I am referring to a RESTful web services framework created by Oracle however, you could substitute your own web server / web application framework / RESTful service as well. Oracle REST Data Services (ORDS) sits on top of the Oracle database and allows

Essbase

Calculate Sum-Product in Essbase Using MDX

In Microsoft Excel you can calculate the sum of products (A x B) for multiple lists of numbers (arrays) using a formula such as =SUMPRODUCT(D3:F3, D4:F4). Some common examples of when you may need this include weighted averages or an accumulated

Node.js

Get Multiple Redis Hashes in Node.js

Redis [http://redis.io] is an open source, scalable, in-memory, key/value store. It can store various types of values (Strings, Lists, Sorted Lists, Hashes, Etc...) with built-in commands [http://redis.io/commands] for each data type. This post is not about setting up

Hyperion

Business Rules To Launch Them All

So you have yourself one of those fancy on-premise Oracle EPM systems built with Hyperion Planning and Oracle Essbase. If you didn't do that or don't plan to do so, then you might want to skip the rest of this

Node.js

Convert Data to Base64 in Node.js

I was recently working on an internal project and needed to convert some Scalable Vector Graphics (SVG) images to Base64 encoded strings. The files were very small (< 500 bytes). This particular application required all HTML content to be "inlined". Whatever your

MS-DOS

Batch Scripts Can Not Suck

Note, I am assuming you are familiar with Microsoft Windows, possibly batch scripting, or at least have some interest in the topic. If you didn't know, the world is rife with batch scripts that suck. Common side-effects of batch scripts that suck

Oracle SQL Developer

SQL Developer 4.1 and SSH Tunnels

In a presentation by krisrice [https://twitter.com/krisrice] and thatjeffsmith [https://twitter.com/thatjeffsmith] at KScope15, Jeff pointed out some new features including one for creating SSH tunnels using SQL Developer. SQL Developer is an all purpose (and free) development environment for the

Hyperion

Intro to Version Control for Oracle EPM

Find out how to go from "zero to version control" in less than 12 minutes. In a previous post [https://icodealot.com/pragmatic-version-control-for-oracle-epm/] I wrote about using version control tools with Oracle EPM. Based on all the feedback I received from that

Hyperion

Pragmatic Version Control for Oracle EPM

This story does not have to end on such a sad note. Stories like this one can happen any time we open up a system for change. The rest of this post shows examples of how to use version control software with Oracle EPM.

Node.js

Node.js Syntax Highlighter

Update: In general my preferences (and requirements) have evolved slightly and I have switched from using pre-generated HTML in practice to using Prism.js [http://prismjs.com/download.html]... for now. That said, I still use highlight.js as noted below but wanted to

VBscript

Dynamic Methods in VBScript

Drawing Hands by M.C. Escher, 1948 Lithograph. [http://www.mcescher.com/gallery/most-popular/drawing-hands/] One challenge that comes up with VBScript is "how to make your scripts modular&