Get Started

Data Integration

Discover our data integration solutions. Learn how we seamlessly connect diverse data sources to ensure unified, accurate, and actionable insights.

How to Connect to Oracle Database from an AWS Lambda using Thin mode

By Deiby Gómez After exploring How to Connect to Oracle Database using AWS Lambda in Thick Mode, we now move on to Thin Mode. With so many companies using AWS as their Cloud Provider, AWS Lambda is a popular solution to process Serverless Code. This guide was written to help people that need to work […]

How to Connect to Oracle Database from an AWS Lambda using Thin mode Read More »

AWS, Cloud Computing, Data Integration, Databases, Oracle, Technical Tutorials
Abstract image of floating numbers symbolizing data connectivity between AWS Lambda and Oracle Database

How to Connect to Oracle Database from an AWS Lambda Using Thick Mode

By Deiby Gómez Many companies use AWS as their Cloud Provider to implement solutions, and AWS Lambda is a popular choice for processing Serverless Code. In a world where data is king, it’s common to need to pull or push from Oracle Databases. For that reason, I wrote this guide to help anyone that needs

How to Connect to Oracle Database from an AWS Lambda Using Thick Mode Read More »

Cloud Solutions, Data Integration, Databases, Oracle, Oracle Technology Network, Technical Tutorials

Snowflake Data Warehouse and AWS Lambda

Serverless computing is here to stay, and while the term “serverless” is a bit of a misnomer, the concept offers many benefits. Most notably, serverless computing allows developers to focus on writing code and not concern themselves with provisioning, configuring, or maintaining servers. One such example of serverless computing is AWS Lambda. Although there are

Snowflake Data Warehouse and AWS Lambda Read More »

AWS, Cloud Computing, Data Integration, Serverless Architecture, Snowflake, Snowflake Computing
Abstract image of lasers criss-crossing above internal computer hardware.

Securing Network Access for Snowflake Data Warehouse and Amazon S3

As technology moves further into a service-oriented (read: Cloud) world, people and enterprises alike need to ensure that securing their assets is taken seriously. Security has always been one of the first of topics covered before purchasing a cloud service which is why good cloud vendors typically spend more time securing their products than any

Securing Network Access for Snowflake Data Warehouse and Amazon S3 Read More »

AWS, Code, Data Integration, Data Warehousing, Security, Snowflake

Using Oracle’s Baseline Validation Tool with OBIEE — Part 3

This post is part 3 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Post 1 with an intro to BVT, can be found here. Post 2 about setting up BVT to run, can be found here. Running the Test Against Both Environments We need to execute BVT twice with the same

Using Oracle’s Baseline Validation Tool with OBIEE — Part 3 Read More »

Business Intelligence, Code, Coding, Data Analytics, Data Integration, Java, JavaScript, OBIEE, Technical Tutorials

Got Technology, Need Data? Here’s Where to Get It…For Free

The Data Challenge Have you ever wanted to assess or explore a new BI, analytics, data visualization, data science, etc. technology, but struggled to find a data set to use for your assessment and exploration activities? Have you grown tired of analyzing the “typical” datasets–think census, stock market, and employment and inflation rate data–known to be publicly available?

Got Technology, Need Data? Here’s Where to Get It…For Free Read More »

Big Data, Business Intelligence, Data Integration, Data Visualization, General, Tips

OTN Appreciation Day: Oracle Data Integrator 12c Flexibility

Well… it looks like Oracle ACE Director and former colleague Michael Rainey beat me to the topic. But as I read his story… I realized I could approach this in a slightly different way, so I decided to press on with my own take on ODI 12c Flexibility for Oracle Technology Network (OTN) Appreciation Day.

OTN Appreciation Day: Oracle Data Integrator 12c Flexibility Read More »

Big Data, Data Integration, Oracle 12c, Oracle Technology Network

Derived Effective Dating

In my previous post, I discussed the transition from a Type 1 to a Type 2 Dimension structure after initial implementation. Today we’ll maintain our focus on Type 2 Dimensions and highlight derived effective dating and its timestamping implications. Why Effective Date? Within Type 2 Dimensions, it is essential that each record be effective dated

Derived Effective Dating Read More »

Data Integration, Tips
Scroll to Top