Wiresk

A

API key: An API key is a unique identifier used to connect to. API: An API is a software interface that allows one software or service to be “connected” to another to exchange data and functionality. Automation: automation consists of replacing tasks performed by humans with computer software.

B

Back-end: The back-end is the part in the background of a website, computer system, or software where data is stored and processed. It is in opposition to the front end.

C

CRM: CRM (Customer Relationship Management) is a strategy for managing a company’s relationships and interactions with its customers or potential customers. The objective of a CRM system is to improve business relationships.

D

Database: A database is a set of stored, organized and structured information. Data warehouse: The data warehouse is a database where information is organized in two-dimensional tables, and where the relationships between the data play a determining role in their exploitation. Data Dynamic : Data that is dependent on each other. It can therefore change according to the other data. Data Static: These are data independent of others, they are generally written and are therefore immobile, they do not change depending on other data. Data Source: A collection of entities from which data can be drawn. Sources include manual systems such as databases, spreadsheets, text files, and applications as well as online sources such as web pages and RSS feeds. Data Warehouse: A centralized store of structured data that can be used to facilitate business analysis and decision-making. Data Modeling: The practice of developing an abstract representation of how data should be organized before being loaded into an ETL pipeline or another type of analytics platform. Data modeling helps identify potential flaws in the structure of the underlying database structures before they become issues further downstream in the ETL process.

E

ETL (Extract, Transform, Load): The process of extracting data from its source, transforming it into a target format, and loading it into a data warehouse or other target system. Extraction: The process of retrieving data from one or more sources for use in subsequent operations. ETL Tool/Software: Software specifically designed to automate the ETL process. These tools are typically GUI-based graphical tools with an associated scripting language for customizing extraction, transformation, and loading instructions.

F

Front end: This term corresponds to the elements of a site that we see on the screen and with which we can interact from a browser. The elements visible on a website are a combination of HTML, CSS, and JavaScript. FTP: FTP is a protocol for transferring files from a computer to a server or vice versa. FTP is used to send large files that cannot be compressed and cannot be sent in any other way. Flow: A flow is a succession of actions, also called steps, necessary to transfer data from one platform to another, to make a sequence of actions automatic or both.

I

Integration listener: It is a software/application/CRM integrated in such a way that there is only a need to connect its interface to have access to it. You only have to record your information, no need for a code! Input: Here, the input is only a marker to know what kind of information is requested, but this field is not mandatory, it is a help. The input is in JSON format.

L

Loading: The process of taking extracted and transformed data and transferring it into a target system, such as a data warehouse or other repository.

O

ODBC (Open Database Connectivity): A standard established by Microsoft to provide a consistent means of moving data between different database formats. ODBC enables software applications to talk directly to databases without intermediary action by people or complex code being written. OLAP (Online Analytical Processing): A technology for analyzing multidimensional information stored in a database using advanced mathematical techniques like aggregation and drill down etc. OLAP is intended for fairly sophisticated users who need quick access to large amounts of historical data stored in a cube-like structure.

R

Routing key: the routing key is a secured link giving access to your flow, so you can share it with your collaborators.

S

Step: the steps are the different stages of the chain that define the different actions in a logical order. SQL (Structured Query Language): A language commonly used in relational databases for defining relationships, creating tables, inserting records, manipulating tables, and retrieving data stored on them.

T

Template: The template is a model from which you can draw inspiration. Here, the template gives an example of flow, and thus of possible connection between the different integrations. Trigger: Triggering element, the first step of a chain that stipulates in which case the flow must take the information. For example, if you take as integration Dynamics, and take as trigger “create a record”. Each time you create a record in Dynamics, the flow will take the information. But it won’t do anything with it, you’ll need to add an action. Transformation: The process of modifying the structure or contents of data to suit the requirements of downstream processes or systems.