CIC Cockpit - Integrations Page

Summary

The video script provides an in-depth guide to the Integrations page of CIC Cockpit, highlighting its features like downloading CIC Studio for data transformation in the cloud, managing reference tables for value conversion during processing, and configuring data flows for efficient data transfer between endpoints. It also demonstrates how to create, schedule, and delete data flows, emphasizing the ease of use and the comprehensive capabilities of the platform.

Takeaways

• 🛠️ The Integrations page in CIC Cockpit allows users to create data flows, work with reference tables, and download CIC Studio.
• 🔧 CIC Studio is a data transformation tool for cloud-based data manipulation and is available for download from the Integrations page.
• 📈 New versions of CIC Studio are automatically updated in the tenant, ensuring users always have access to the latest features.
• 🔑 Reference tables are crucial for transformation processing, converting incoming values into system-usable formats by defining specific lookup tables.
• 🔍 Reference tables can be viewed and modified directly within the CIC Cockpit, providing visibility and control over data mappings.
• 📝 The script demonstrates how to view and interact with reference tables, including adding new entries or modifying existing ones.
• 🔀 Data flows are connections between endpoints that facilitate one-directional data transfer, as illustrated by the script.
• 📊 The Integrations page displays information about each data flow, including endpoints and any associated schedules.
• ⏰ Data flows can be set on a schedule, allowing for automated data transfers at specified intervals, such as every minute, hourly, daily, or on custom schedules.
• 🚀 The process of creating a new data flow is outlined, including naming, selecting endpoints, and choosing whether to add it to a schedule.
• 🗑️ Data flows can be deleted if they are no longer needed, with a simple checkbox and trash icon mechanism provided for user convenience.
• 📚 For further information on the topics covered in the script, users are directed to the Solution Center.

Q & A

What is the purpose of the Integrations page in CIC Cockpit?

The Integrations page in CIC Cockpit allows users to create data flows, work with reference tables, and download CIC Studio.

What is CIC Studio and what is its primary function?

CIC Studio is a data transformation tool used for transforming data in the cloud. It is necessary when working with data in the cloud and is used to perform lookups and transformations.

How can new versions of CIC Studio be accessed by users?

New versions of CIC Studio will automatically be available in the user's tenant as they are released. Users can download the latest version by clicking the download button.

What are reference tables and how are they used in CIC Cockpit?

Reference tables are used during transformation processing to convert incoming values into values that the system can use. They can be defined in a specific way, viewed, and modified in the CIC Cockpit and are referenced from CIC Studio for lookups.

Can users create new entries in reference tables through CIC Cockpit?

Yes, users can create new entries in reference tables directly through the CIC Cockpit interface by clicking the 'add row' button.

What is a data flow and what does it consist of?

A data flow connects two endpoints, enabling data transfer between them in a single direction. It consists of a 'from' endpoint and a 'to' endpoint.

How can users view information about each data flow in the CIC system?

Users can view information about each data flow on the data flow page in the CIC system, where details about the 'from' and 'to' endpoints are displayed.

Can data flows be scheduled to run at specific intervals?

Yes, data flows can be scheduled to run at intervals such as every minute, hourly, daily, weekly, monthly, or according to a custom advanced schedule.

What actions can be performed on a data flow from the data flow menu?

From the data flow menu, users can view the schedule of a data flow, change the schedule, and delete the data flow if it is no longer needed.

How can users create a new data flow?

Users can create a new data flow by clicking the 'add data flow' button, naming the data flow, selecting the 'from' and 'to' endpoints, choosing a folder, and optionally adding it to a schedule before saving.

Where can users find more information about the topics discussed in the script?

For more information about the topics discussed in the script, users can visit the Solution Center.

Outlines

00:00

🔧 CIC Cockpit Integrations Overview

The script introduces the Integrations page of CIC Cockpit, a platform for managing data flows, reference tables, and downloading CIC Studio. CIC Studio is a data transformation tool for cloud-based data processing, with new versions automatically available to tenants. Reference tables are essential for transformation processing, allowing for the conversion of incoming values into system-compatible ones. These tables can be viewed and modified in the CIC Cockpit and are referenced in CIC Studio for lookups. The speaker demonstrates how to view and interact with reference tables, including adding new entries. Data flows are explained as connections between endpoints for unidirectional data transfer, with the script detailing how to view and manage these flows, including setting up schedules and creating new data flows.

05:02

📅 Creating and Managing Data Flows

This paragraph delves into the process of creating a new data flow in the Integrations page. The user is guided through naming the data flow, selecting endpoints, and choosing a schedule for data transfer. The example given involves setting up a data flow from an 'agent inbox' to the 'Cleo portal'. The script explains how to add the data flow to a schedule, with options ranging from minutely to monthly, and the importance of selecting the correct time zone. It also covers how to save the new data flow and provides an overview of deleting data flows when they are no longer needed. The paragraph concludes with a summary of the Integrations page's functionalities and a prompt to visit the Solution Center for more information.

Keywords

💡Integrations

Integrations refer to the process of combining different systems or applications to work together seamlessly. In the context of the video, the Integrations page is a key feature of the cic cockpit, allowing users to manage various aspects of data integration, such as creating data flows and working with reference tables. It is central to the video's theme of data management and transformation.

💡CIC Cockpit

The CIC Cockpit is the central interface or control panel for managing integrations and data flows within the cic system. It is the main setting where users can access tools like CIC Studio, reference tables, and data flows. The term is used to describe the platform where all the actions related to data integration are executed, as seen in the video.

💡CIC Studio

CIC Studio is a data transformation tool used for modifying data in the cloud. It is mentioned in the script as a downloadable application that users need for transforming data. The video demonstrates how to download CIC Studio, emphasizing its importance in the data integration process.

💡Data Flows

Data flows represent the movement of data between two endpoints in a single direction. The script explains how to view, create, and manage data flows on the Integrations page. Data flows are a fundamental concept in the video, illustrating the process of transferring data from one system to another.

💡Endpoints

Endpoints are the starting and ending points in a data flow, defining where the data originates from (from endpoint) and where it is sent to (to endpoint). The video script uses the term to describe the configuration of data flows, such as sending data from the Cleo portal to a transformation process.

💡Reference Tables

Reference tables are used during data transformation to convert incoming values into usable formats for the system. They are defined in a specific way and can be viewed and modified in the CIC cockpit. The script demonstrates how to interact with reference tables, such as viewing and adding entries, which is crucial for understanding data transformation.

💡Transformation Processing

Transformation processing is the act of converting data from one format to another to make it compatible with the receiving system. The script mentions reference tables being used in this process, highlighting the importance of transformation in data integration.

💡Schedule

A schedule in the context of the video refers to the timing and frequency at which data flows are executed. The script explains how users can set up schedules for data flows, such as every minute, hourly, daily, or using custom advanced schedules, which is essential for automating data transfer processes.

💡Add Data Flow

Adding a data flow is the action of creating a new data transfer process between endpoints. The script provides a step-by-step guide on how to add a data flow, including naming it, selecting endpoints, and choosing a schedule, which is a key operation demonstrated in the video.

💡Delete Data Flow

Deleting a data flow is the process of removing a data transfer process that is no longer needed. The script shows how to delete a data flow by selecting it and using the trash icon, illustrating the management aspect of data flows.

💡Solution Center

The Solution Center is a resource mentioned in the script for users to find more information about the topics discussed in the video. It serves as a knowledge base or help center for users to explore further details about CIC Cockpit, data flows, and other related concepts.

Highlights

The Integrations page of CIC Cockpit allows creating data flows, working with reference tables, and downloading CIC Studio.

CIC Studio is a data transformation tool needed for transforming data in the cloud.

New versions of CIC Studio are automatically available in your tenant as they are released.

Reference tables are used during transformation processing to convert incoming values into system-usable values.

Reference tables can be defined in a specific way and made available for viewing and modification in CIC Cockpit.

Reference tables created in CIC Studio are referenced to perform lookups.

The transcript provides an example of a reference table for viewing customer information.

Users can see columns, rows, and make new entries in reference tables directly from CIC Cockpit.

An example reference table for error codes in transformation is provided, explaining the meaning of different codes.

Data flows connect two endpoints, enabling data transfer between them in a single direction.

The data flow page displays information about each data flow in the CIC system.

Data flows consist of a 'from' endpoint and a 'to' endpoint, showing the direction of data transfer.

Advanced commands and schedules can be managed directly from the data flow menu.

The process of creating a new data flow is demonstrated, including naming, selecting endpoints, and choosing a folder.

Data flows can be scheduled by minute, hourly, daily, weekly, monthly, or with an advanced custom schedule.

Users can delete data flows that are no longer needed by selecting and clicking the trash icon.

The Integrations page is summarized as the place to download Studio, view and maintain reference tables, and configure and maintain data flows.

Additional information on the discussed topics can be found in the Solution Center.

Transcripts

[Music]

let's take a look at the Integrations

page of cic

cockpit the Integrations page allows you

to create data

flows work with reference

tables and download cic

Studio let's start with Studio

download the cic studio is a data

transformation tool you'll need for

transforming data in the

cloud when you click the studio

download you'll see the latest version

available for

download new versions will automatically

be available in your tenant as they are

released to download the studio you

would simply click the download

button let's move on to reference tables

reference tables are are used during

transformation processing to convert

incoming values into values your system

can use by defining your table in a

specific way you can also make it

available for viewing and modification

in the cic

cockpit these tables are referenced from

cic Studio to perform lookups so these

tables have been created all the

configuration has been done in C cic

studio and the projects that they're in

in cic studio have been deployed out to

the server so I can see my reference

tables here I can actually click on a

reference

table I can click on the reference table

here to see information about this

particular reference table so this one

if I click the question mark next to the

name it tells me that this table is to

view customer information

I can see the columns and rows in this

reference

table and if I wanted to I can make a

new entry in this reference table as

well I'm going to click back on the

reference tables sub page to see the

other reference tables that are out here

I can see one called error

codes this is pretty valuable again if I

look at the information about this

reference table it's telling me that

this is to view error codes of

transformation so if I would happen to

get this code I would know that the

error is a wrong ship date whereas this

code is an incorrect

discount the

p004 error means that it's a duplicate

PO number and again I can delete rows or

edit rows right out here in cic cockpit

I can add a new entry if I wanted to

just by clicking that add row

button let's move on to data flows a

data flow connects two endpoints

enabling data transfer between them in a

single

Direction the data flow page displays

information about each data flow in your

cic

system a data flow consists of a from

endpoint and a two endpoint so if I

click on a

particular data flow let's just click on

this one I can see my from endpoint is

the Cleo

portal and my two endpoint is

transformation so I'm sending something

from Cleo portal to be transformed

whereas let's take a look at another

endpoint let's take a look at this state

of

flow the from is a sample

endpoint the two is cleop Portal so I'm

sending something from a sample endpoint

to cleop portal and anything that's

already out here I'll be able to see so

any kind of advanced commands I would

need to do I can can do right from here

if I wanted

to if a particular data flow needed to

be on a schedule this one looks like

it's on a schedule of every minute I can

take a look at that schedule I can

change it if I want it to right from

within this data flow

menu so let's go ahead and create a new

data flow I'm simply going to click the

add data flow button to open a new data

flow

page I want to name my data flow for

identification throughout the system I

know I'm going to be deleting this so

I'm just going to call

this heli

demo data

flow I can select a from

endpoint so maybe I'm getting something

from our agent inbox so I'm going to

select that by clicking it and then

clicking the select button

and then my

two end point I'm going to click Cleo

portal I'm going to send that to Cleo

portal and I'll need to select a folder

uploads not available it would be

download on the two

side if I wanted to I can add this to a

schedule again I can do it by minute

hourly daily

um you can do it every day or every

working day at a specific time

weekly monthly or you can create your

own Advanced

schedule again your time zone is up here

and it can be selected we

are currently in this time zone so I'm

going to let that

selected but I'm not going to add it to

a schedule just yet so I'm going to

unclick that to turn that schedule

off then I would save this data

flow and I should see it out here if I'm

finished with the data flow and I no

longer need it maybe I just set it up to

do some data movement testing I can

click on the checkbox next to my data

flow and then click the trash icon in

the upper right hand corner and that's

going to delete my data

flow in summary the Integrations page is

where you download

Studio View and maintain reference

tables and configure and maintain your

data

flows for more in information about any

of the topics we discussed please visit

our Solution Center

[Music]