Contents x
Cloud Concepts
11 Articles in this category
  • Dark
    Light
Contents

Cloud Concepts

11 Articles in this category
  • Dark
    Light

Cloud data warehouses

Overview A cloud data warehouse (CDW) stores data in the cloud . The “cloud” are servers that can be accessed over the Internet, and your data is stored on machines that are spread across the world. It allows organisations to provide applic...
Updated on : 05 May 2022

Cloud computing

What is cloud storage? You will have heard the term "the cloud" before, usually in reference to data storage. Cloud storage is where data is stored on the internet, across multiple servers, often across multiple locations. A cloud computing ...
Updated on : 05 May 2022

Data loading

Overview One of the most ubiquitous tasks that Matillion ETL is used for is the loading of data into a data warehouse. Matillion ETL makes this process simple by connecting to the data source via "Connector" components that take the hard w...
Updated on : 05 May 2022

Data objects and schemas

Database Objects Database objects are objects in a database used to store or reference data. Matillion ETL interacts with database objects as part of the ETL process. Database objects include: Tables - The most common object in relation...
Updated on : 05 May 2022

JDBC and data models

JDBC JDBC stands for Java Database Connectivity and is a Java API that manages connections to a database, issuing queries and commands to that database, and handling result sets obtained from the database. It also lets multiple instances run...
Updated on : 05 May 2022

Messaging

Amazon SQS Amazon Simple Queue Service (SQS) is a messaging service that stores messages between computers. SQS is used in serverless, distributed, and micro services in cloud computing. These different services need to communicate with each...
Updated on : 05 May 2022

Security

API Key and Key Secret An API Key authenticates a user to an API. In Matillion ETL an API Key is used for some data stagers during configuration, such as Mandrill Extract . The API typically authenticates a project with the API, rather th...
Updated on : 05 May 2022

SQL

What is SQL? SQL is a computer language developed in the early 1970s, used to communicate with databases from a client (e.g. a computer). SQL stands for Structured Query Language , and is best used for structured data—data found in a fixed ...
Updated on : 05 May 2022

Structured data

What is JSON and XML? When a browser and a server exchanges data, this data can only be text. When you make an API request, you will receive a response, usually in JSON and XML. Your web browser or device will convert this into a readable fo...
Updated on : 05 May 2022

Types of databases

Overview A database is an organised group of related data, stored and accessed in a computer system. A database management system (DBMS) is a type of software used to access and manipulate the data (update, retrieve, delete, modify, etc.). Mat...
Updated on : 05 May 2022

User configuration protocols

User configuration refers to the unique settings applied to an application for an individual user. This article talks about protocols and how they are used, and authentication via LDAP, single sign-on, and OpenID. What is an application protoc...
Updated on : 05 May 2022

Cookie consent

We use our own and third-party cookies to understand how you interact with our knowledge base. This helps us show you more relevant content based on your browsing and navigation history.