ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server

Harry Dragstra

While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the 2 other ETL processes (transformation and load) can be configured and administered with more flexibility, providing an almost acceptable level of […]

Oracle 12c STIG Password Generator in PL/SQL

Harry Dragstra 1

Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find on the WEB. But I wanted a password to comply to “ora12c_strong_verify_function”, and this isn’t as easy to generate as you might expect. Though most generators provide options to include […]

How-to set the current database schema of an application using a global context

Harry Dragstra

Question: We have customers who want to work with different database schemas and we want to determine dynamically – depending on a choice during or after login – which database schema the application in a given session should use. Is it possible to set this up in the database? Answer: […]

FTPS with PL/SQL

Anton Scheffer 15

Doing a FTP-job with PL/SQL is not difficult. A basic implementation of RFC 959 can be written in a few hundred lines. See for instance ORACLE-BASE, How to FTP with Oracle PL/SQL or Oracle FAQ’s But what if you want to secure your FTP transmission. Google doesn’t find any pure […]

Typical

Patrick Barel 2

After a presentation by Lucas Jellema I decided to try something with types in Oracle. One of the issues posed in this presentation was that the type cannot self-reference. Neither direct nor indirect.   A table like the emp table cannot be expressed as an object type. The table has […]

ADF Performance Tuning: Improve Your Oracle ADF App Response Time by as Much as 70 Percent

Frank Houweling

Performance needs to be ingrained in your application – it cannot be added in during the last stages of development. In this video I discuss how you can optimize the performance of your Oracle ADF Fusion application, diagnose and solve typical performance problems, and build an efficient, responsive, scalable ADF […]