Ensuring Trust with Blockchain

An Alternative to Using an Oracle BI Publisher Data Table for a One Line Table

Blockchain is a transformative technology that will revolutionize the way information is exchanged across the globe. It stands on the four pillars of Consensus, Provenance, Immutability, and Finality which ensures TRUST in all forms of economic exchanges of value and information. The existence of uncertainty and distrust in all forms of economic exchanges has resulted in tremendous inefficiencies and disruptions between all participants of an economic system, e.g. insufficient trust and information sharing can lead to inefficiency and infectiveness in a bank’s operation as the same information is duplicated across all participants like bank, auditors, regulators, and insurers in the network … Read More

How to Bypass Validation from Apex Across Objects [Salesforce]

If your Salesforce org has Triggers and Apex, you’ve probably run into the issue of hitting Validation Rules (VRs) when your Apex code tries to insert or update a record. The example below is across two objects and how you can solve for it. Let’s say you have an object called Positions and another object called Applicants. There is a lookup field on Applicants to the Position object. On the Positions object, you have a date field called Last Interview Date to identify the latest date an applicant was interviewed. Due to the relationship between Applicants and Positions only being … Read More

A Work-Around for Salesforce Bulk API v2.0 (in Dell Boomi)

Summary: Salesforce Bulk API Usage, though it offers performance benefits over regular APIs is a scarce resource for organizations. It is important to conserve and optimally use the Bulk API. ——- The Dell Boomi Salesforce connector does not support the Bulk API v2.0 (which essentially makes a determination automatically whether to use the regular or bulk API) at the time of writing. This feature is sought-after in the forums since organizations hit their Bulk API usage limits frequently. Processing much lower volumes of documents through the Bulk API (Bulk API accepts 10,000 documents in a single go) may be a wasted … Read More

A Guide to the Changes at the Analytics and Data Summit 2018 (Formerly BIWA Summit)

Changes at Analytics and Data Summit 2018 (Formerly BIWA Summit)

What a year for the BIWA User Community and Oracle Spatial & Graph Special Interest Group (SIG)! Both groups have expanded their leadership teams, as well as rebranding and moving the date of their flagship event, the Analytics and Data Summit (formerly known as the Oracle Business Intelligence, Warehousing, and Analytics (BIWA) Summit.  As a new member of the board of both BIWA and the Summit, we wanted to let you in on the exciting changes, and what they mean to you. The BIWA User Community was founded in 2006 as a special interest group (SIG) of the Independent Oracle User Group (IOUG) … Read More

Lambda Functions with Newer Version of boto3 than Available by Default

During development of an AWS Lambda function utilizing the recently released AWS Cost Explorer API, the latest version of boto3 and botocore was discovered to be unavailable in the Lambda execution environment. The Lambda execution environment supported version of an AWS SDK can lag behind the latest release found on GitHub, which can cause supportability issues when writing Lambda code attempting to use the most recently added features of AWS SDKs. This blog post will explore using boto3 1.4.8 and botocore 1.8.0 despite (at the time of this writing) the Lambda execution environment defaulting to boto3 1.4.7 and botocore 1.7.37. This … Read More

Oracle E-Business Suite (EBS) Analyzers

It’s month end close and something is preventing close. You open a service request (SR) with Oracle and begin narrowing down what the problem is. If this is not an issue you’ve seen before, you and the analyst might have to narrow down where the issue even is. If this is something you’ve seen before, you might be wishing you’d had an easy way to identify this before close rolled around again. Oracle’s E-Business Suite Support Analyzers offer a way to get ahead of potential problems before the day of month end close. Oracle provides analyzers for different areas–payables, receivables, … Read More

Federated SSO, A Primer (SAML, OAuth 2.0, OpenID Connect)

Federated single sign-on (or SSO) is a modern way to solve the problem of having multiple logins between different services and applications. Let’s take a look at three of today’s common federated identity protocols: SAML, OAuth 2.0, and OpenID Connect. SAML The first of the authentication methods that I’d like to talk about today is SAML, which stands for Security Assertion Markup Language. SAML is the oldest of the free main federated identity protocols, with its last major revision in 2005. There are three major players in SAML – the user, the Identity Provider (or IdP) that authenticates the user, … Read More

VMware hosted on AWS?

Some exciting news came out of Amazon Web Services (AWS) and VMware last year with the announcement of VMware Cloud on AWS. VMware has been the bedrock of enterprise virtualization and the leading software-as-a-datacenter for years. AWS presented the world with a new way to think about datacenters and quickly became a leader in cloud computing. A limiting factor in using AWS was the vast differences in how AWS and VMware worked to accomplish similar tasks. You will find the same buzz words, such as snapshots, but not the same actions from them. This has presented the industry with a … Read More