Learn commonly used data terms & phrases
Application Programming Interface. In software, this term refers to a way of programmatically interacting with a the software, without the use of a user-interface built for humans.
API (Application Programming Interface)
The app is what we call the main Interloop web application, this is the part you log in to, and where you can view and configure your organization's Connections, Jobs, Datasets, Monitors, & more.
Computer systems able to perform tasks that normally require human intelligence, such as visual perception, speech recognition, decision-making, and translation between languages.
Business intelligence (BI) leverages software and services to transform data into actionable insights that inform an organization’s business decisions.
Business Intelligence (BI)
Content Delivery Network. CDN's are a network of servers which make downloading files faster for end users by placing them all around the world to reduce latency and transfer time over the internet.
A connection refers to the link between Interloop and an Operational System or Database. Interloop can either pull data from a Connection into the data engine or can sync data back out into a connection.
A data lakehouse is a new, open data management architecture that combines the flexibility, cost-efficiency, and scale of data lakes with the data management and ACID transactions of data warehouses, enabling business intelligence (BI) and machine learning (ML) on all data.
A data pipeline is a series of data processing steps that moves data from one place to another. In Interloop an Ingestion or Sync Job would be synonymous with a Data Pipeline in other tools.
Extract Load Transform. This is a similar but slightly different approach from ETL in which data is extracted from a source system, loaded into a central repository, and then later transformed on demand as needed.
ELT (Extract Load Transform)
The act of retrieving or fetching data from a Connection.
A SQL-based API created by Sun Microsystems to enable Java applications to use SQL for database access. A JDBC Source is one that supports JDBC connectivity. The JDBC driver for that data source and the URL format is required to set up the connection.
Java Database Connectivity (JDBC)
An open standard for authorization that allows applications or websites limited access to resources hosted by other apps and websites on behalf of the user without sharing the user’s password.
The limits imposed by an API vendor, such as Intercom, HubSpot, on the number of API requests sent to their public APIs.
Reverse ETL is the process of sending data residing in your data lakehouse to various downstream operational tools. This includes various SaaS marketing, analytics, sales, and customer support tools.
A software distribution model where the application is hosted by a company on its servers and is accessed by clients via the internet by paying a subscription fee. For example, Salesforce.
SaaS (Software as a Service)
A schema refers to the design of a database, including which fields are currently configured, what data types of stored in these fields. If you were to think of a database as a spreadsheet with columns and rows, the schedule would be the first row that defines the field names, plus the data types and formatting rules for each column.
Software Development Kit. This is combination of libraries and tooling that can make it easier for developers to interact with the Interloop API.
SDK (Software Development Kit)
A service account is a login that is used with a team or a system rather than an actual individual. Often when connecting to operational systems, it can be helpful to setup a service account rather than using the login credentials of an existing user.
Structured Query Language. The standard language for querying and retrieving information for analysis. SQL can be used to query raw data, group data, aggregate data and much more. For instance to query all leads that with the persona of "Rational Ray" would translate to the following in SQL: select * from leads where persona equals 'Relational Ray'
The process of changing the format and structure of data.
A UUID is a unique string that can be used to identify a particular record.
Universally Unique Identifier (UUID)
A place to store the data accumulated from a wide range of heterogeneous Sources, generally used for data analysis and reporting. For example, Microsoft Azure, Amazon Redshift, Google BigQuery or Snowflake. Interloop has both Data Lake & Data Warehouse capabilities baked in.