You can use a Database Tools identity in Oracle Cloud Infrastructure (OCI) to give Oracle Databases access to OCI resources through something called a "resource principal". There are a few configuration requirements and the use case is interesting in general, so let's check it out!
You take an instance of some type and decorate it with additional responsibilities at runtime. The decorator acts like a proxy for the instance, forwarding or augmenting requests sent to methods along the way.
With Oracle's Java Database Connectivity (JDBC) driver starting with 23ai it is now possible to provide the configuration of a connection to Oracle Database using the opaque identifier of a Database Tools connection.
tl/dr: Model Context Protocol (MCP) is a light-weight protocol that attempts to address a specific problem of how to allow 3rd parties (you, me, or anyone) to provide relevant prompts or context to a large language model (LLM) and to allow AI clients to complete well-defined tasks.
In the past few posts I looked at using the Oracle Cloud Infrastructure (OCI) services related to creating database connections in the cloud. Here I want to show how you can build on that by creating secrets in a vault using the OCI provider.
In this post we will look at setting up a Database Tools connection resource in Oracle Cloud Infrastructure (OCI) using the OCI Terraform provider. Database Tools connections in OCI are first-class resources just like other cloud primitives such as virtual cloud networks (VCN), compute instances, or databases.
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).
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.
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.
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.
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.
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."
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.
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.
Learn about writing Java classes and JavaScript programs for use with Oracle SQLcl and other Nashorn-based applications that run on the JVM.
Learn how to integrate the Vue.js library into your Oracle JET applications for an alternative approach to front end HTML to JavaScript data model binding.
Follow along with an example using the new Oracle JET CLI including screenshots of the process and the resulting Oracle JET navdrawer web application.
Some opinions on where an EPM infrastructure consultant might find hope in a dwindling on-prem market. You have some options to consider.
Oracle JET can be combined with Electron to build native desktop applications using HTML, CSS and JavaScript. Follow along with this post to learn how.
Learn how to use Node.js on the Raspberry Pi 3 B to retrieve JSON data from RESTful web services and then insert that data into a SQLite relational database
Learn how to send HTTP POST requests to a web application server from iOS applications written in the Swift programming language.
In this quick tip we take a look at how to calculate SUMPRODUCT (similar to Excel) but using the MDX scripting language in Essbase for ASO cubes.
Redis currently does not have a built-in MHGETALL command but you can implement one. Learn how to get multiple hashes using pipelining or multi in Node.js.
Learn how to launch batch jobs from Business Rules with Hyperion Planning. VB, C, Java, Perl, MaxL Esscmd, ODI, and even .NET have paved the road to now.
Using the Buffer class built-in to Node.js we look at how to convert data in a file to and from Base64.
In this post I look at a few ways to improve your batch scripts so they are easier to maintain and hopefully suck less.
Follow the steps in this post to learn how to create SSH tunnels using the latest version of Oracle's SQL Developer.
Learn how to use Mercurial version control tools to track changes to source code. This is a beginners tutorial for version control with Oracle EPM.
You can use time-tested software development tools and processes with Oracle EPM to keep track of source code changes and revisions.
Use highlight.js with Node.js to pre-generate syntax-highlighted HTML for code snippets. Note: my preferences have evolved since and I now lean on Prism.js in practice, but the highlight.js workflow below is still useful.
One challenge that comes up with VBScript is how to make your scripts modular so that you don't have to repeat code in multiple VBScript files. This post looks at dynamically dispatching methods in VBScript to help solve that problem.
The FDMEE Open Interface Adapter can be customized and Oracle has provided updated guidance on the process that you should follow.
You can debug HTTP drill-through requests from Oracle EPM products using Node.js. Follow this tutorial to setup an HTTP server in Node.js and debug away.
IE 11 is not supported with versions of Oracle EPM prior to 11.1.2.4. Check out this post for tips on getting IE11 to work with Oracle EPM.
There may be an unconfirmed bug in CREATEBLOCKONEQ in Essbase where it creates blocks even when set to OFF. A possible workaround can be found here.
Use Essbase calculation script functions and 86,400 seconds per day to convert Planning Dates to Unix dates. This is useful for various Essbase date calcs.
Essbase calculation scripts that don't produce any values are often the result of missing blocks. Take a look at this post to see how to create blocks.