Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Comments are used in Cinchy to provide context to your data along with providing a means of collaborating directly with and on the data. This section covers the following:
Anyone who can view or edit a cell can comment on it.
To add a comment, complete the following:
Locate the desired cell
Right-click and select comment
In the comment window, enter the comment
Click the Comment button
Comments can be modified only by only the individual(s) that have created the comment(s).
To edit a comment, complete the following:
Hover over the comment
Click the pencil icon
Make the appropriate edit
Click the Submit button to save the change
Comments can be deleted only by the individual(s) who has created the comment(s).
To delete a comment, complete the following:
Hover over the comment
Click the garbage bin icon
A User with the Approve Select Cell permission has the ability to archive comments on that specific cell
A User with the Approve All permission has the ability to archive any cell comments.
A User can archive his own comment regardless of approve permissions
To achieve all comments in a cell, complete the following:
Hover over the comment
Click the Archive All button
You can also archive just one comment in a comment string, click the archive icon for the specific comment you wish to archive in the thread.
Comments are stored in the [Cinchy].[Comments] table. You can see the structure below.
My Network in Cinchy is your home page. This is where you will access and organize all of your tables, queries and applets in Cinchy. This section will cover the following features:
Once you log in to Cinchy, you'll be on the My Network screen. From here, you can navigate to a variety of tables, queries, and applets you have access to.
You can return to the My Network page at any time by clicking the Cinchy logo in the top left corner.
All objects you have access to within Cinchy will show up in my marketplace. You can find the objects that you are interested in through searching and filtering.
All objects you have access to in your Marketplace (including bookmarks) are searchable and can be filtered by typing the partial or full name of the object you are searching for in the search bar.
The ‘Reset’ button on the right side of the search bar can be used to clear the search.
You can also search by removing or adding object types from your My Network simply by selecting and deselecting an object type like Queries from the toolbar.
You can bookmark your most often used objects and rearrange them to your liking within your bookmarks.
To bookmark an object, complete the following:
Locate the object
Click the yellow star in the top right corner
The object will pop into your “My Bookmark” section.
To rearrange your bookmarks simply drag and drop the object into the desired order.
Your “My Data Network” shows a visualization of all tables in Cinchy you have access to and how they are all connected.
Each of the coloured circles represents an object in Cinchy. The lines between them demonstrate the links between them.
You are able to search and open tables from this view using the search bar on the left.
You can see what the network looked like in the past by clicking and dragging the pink circle along the timeline at the bottom.
There are several ways to work with (enter, update, remove, load and extract) data from Cinchy tables. This section will go over the following:
Users are only able to enter data into Cinchy based on their access. Users can also copy and paste data from external sources.
Users are only able to insert or delete rows based on their access. If you have the ability to insert and/or delete a row of data it will be visible when right-clicking on a row of data.
Importing data allows you to add new rows of data into a table. If you wish to perform a sync instead please refer to the CLI. Importing data acts as a smart copy-and-paste of new data into an existing table.
Importing the first row of your CSV as a header row will match the headers to the column names within your table. Any columns that cannot be matched will be ignored as well as any columns you do not have edit permissions for.
Users can import data from a CSV file to an existing table in Cinchy. Importing data into a Cinchy table only adds records to the table. This type of importing of data does not update or append existing records
To import data into a table, complete the following:
From within the table, click the Import button on the top toolbar of the table (Image 1).
2. Click Choose File to locate and import you file.
3. Validate the imported columns and click next (Image 2).
4. Click the Import button
5. Click the OK button on the Import confirmation window
This will return the same errors as you would get in the UI if you were doing a copy and paste.
If there are import errors click the download button next to Rejected Rows on the Import Succeeded with Errors window.
You will get a file back with all the rejected rows, as well as the 2 columns added called ‘Cinchy Import Errors' and 'Cinchy Import Original Row Number’.
This provides a reference to the row number in the original file you imported in case you need to check it. You can simply fix any errors in your error log followed by importing the error log since successful rows are omitted.
Users are only able to export data in CSV or TSV format. Please note that when data is exported out of the Fabric the data is just a copy and no longer connected to Cinchy.
To export data from a table, complete the following:
From within the table, click the Export button in the table toolbar
Select the Export file type (CSV or TSV)
Open Excel file to view
Cinchy has the ability to have data change approvals turned on (configured by builders) when data is added or removed from a table view. A change approval process can be put into place for the addition or removal of specific data. If you have been identified as an "Approval" of data you will have the ability to
approve a cell of data
approve a row of data
reject a row of data
To approve or reject a cell/row of data, complete the following:
Right-click on the desired row/cell
Select Approve row/cell or Reject row/cell
The Collaboration log is accessible from each and every table within Cinchy (including metadata). It allows you to see the version history of ALL changes that have been made to an individual row of data.
To access Cinchy’s Collaboration Log complete the following:
Open table
Locate the desired row > Right Click > View Collaboration Log (Image 1)
Once the Collaboration Log is open you have the ability to view ALL changes with a version history for the row selected within the table.
Users have the ability to revert to a prior version of the record. To do so, click the Revert button for the desired version.
Please note, there is a potential for a record to have a white coloured Revert button. This indicates that version record(s) are identical to the current version of the record in the table. Hovering over the Revert button will provide a tool-tip.
By default, Cinchy does not delete any data or metadata from within the Data Fabric.
Click here for more information on Data Erasure & Compression Policies in Cinchy
Audit Logging of data loaded into Cinchy via Data Synchronization such as batch or real-time using the Cinchy CLI, or through data changes by any Saved Queries exposed as APIs to external clients, is recorded the same way as if data is inputted into Cinchy by a User. All data synced into Cinchy will have corresponding line items in the Collaboration Log similarly to how it is handled when data is entered / modified in Cinchy by a User.
The Collaboration Log data is also stored within Cinchy as data, allowing the logs to be available for use through a query or for any downstream consumers. There are no separate performance considerations needed for the logs as it will rely on the Cinchy platform’s performance measures.
All data records that have been deleted are put into Cinchy’s Recycle Bin. Data that resides in the Recycle Bin can be restored if required.
To restore data from the recycle bin, complete the following:
From the left-hand navigation, click Recycle Bin
Locate the row for restoring
Right-click and select Restore Row.
The restored row will now be visible in your table.
Note, if Change Approvals are turned on, that row will need to be approved.
Queries are requests for information within Cinchy which users can create. This section covers the following:
For more information on how to create queries, see .
Users can execute pre-built queries based on their access. The result can be exported into a CSV or TSV format.
Once you have executed the query, click the Grid drop down list and select Pivot. Here is where you can take your standard table view and slice and dice your data.
From within your pivot view, open the drop down list with the value “table” and select the type of chart you want to use to display the data.
Once you have a desired visualization, that visualization can be made available for others as an applet in Cinchy. Grab the Pivot URL and send it to your Cinchy builder to create your mini applet that can be shared and leveraged!
To copy the Pivot URL to build have a visualization created, complete the following:
From within the Pivot, locate the blue Pivot URL
Click Pivot URL button
Click the Copy button
Send the copied URL to your Cinchy builder to create your applet that can be shared and leveraged!
You can also open that visualization by clicking Open in new tab if need be.
Cinchy’s Autonomous Data Fabric technology introduces an entirely new way for an increasingly diverse set of end-users (employees, customers, and partners) to manage their data. The technology was created on the belief that there should be an easier way for people, systems, and AI/ML to collaborate in a secure manner across the enterprise. In the traditional technology paradigm, the only way for users to interact with data is through the ‘application experience’ which is rigid, limiting, and limits our interactions to the data that 'lives' within the app. There are two types of individuals that use the platform. The first is ‘Builders’ who are really the creators of the Data Fabric. Builders are responsible for building out the organization's Fabric including table schemas, establishing access controls, and building application experiences for end-users. The second are end-users who are able to view and manage all data that they have been granted access through Cinchy’s Universal Data Browser.
Cinchy’s Autonomous Data Fabric platform features a Universal Data Browser that allows users to view, change, analyze, and otherwise interact with all data on the Fabric. The Data Browser even enables non-technical business users to manage and update data, build models, and set controls, all through an easy and intuitive UI.
Data on the Fabric is protected by cellular-level access controls, data-driven entitlements, and superior data governance. This means that users can only view, edit, or operationalize data that has been granted access to from the data owner.
All data is automatically version-controlled and can easily be reverted to previous states with the proper permissions. On all data tables, you can see changes made by users, systems, or external applications through Data Synchronization or by using a Collaboration Log.
Users can easily access and run saved queries that are available to them through the Data Marketplace. All queries respect Universal Access Controls meaning you will only see the data that you have access to.
Users can also access all accessible tables, queries, and applets through the Cinchy Marketplace. Here you can also order tiles and bookmark favourites.
Users can also experience data on the Fabric through custom application experiences that are created by Builders on the platform. All application experiences also respect Universal Access Controls meaning you will only be able to see the data you have been granted access.
Your Cinchy Profile has three (3) components that can be changed from user preferences:
To add a photo to your profile, complete the following:
From My Network, click the Avator icon
Select My Profile
From the settings page click on the my photo image
Locate and upload your photo
From the settings page in the My Profile section you are able to update the language, region, and time zone.
If you do not see the password option in my profile, you must be logging on to Cinchy using Single Sign-On and will not need to update your password within Cinchy.
To change your password, complete the following:
In the Old Password field, enter in your existing password
In the New Password field, enter a new password
In the Confirm New Password field, re-enter in your new password
Cinchy password must be a minimum of 8 characters long and must contain a number and a symbol
There are several table features that can be used to better view, collaborate and analyze the data in Cinchy tables. This section will go over the following features:
When you first create a table, a default view called All Data will be created for you under Manage Data. Cinchy builders can create different views for users to manage their data in Cinchy where Views can be filtered and/or sorted according to the requirements.
To switch between views simply select the view from the left navigation toolbar under Manage Data.
Users can filter data in a view for one or more columns. Filters persist when users navigate from one view to another. The number of filter criteria is identified against the filter icon.
Users can add, remove or rearrange the columns in a view based on how they need the data represented in the View.
To add a column to a View, complete the following:
Click Display Columns in the top toolbar
From the ‘Add a Column’ drop down, locate and select the appropriate column.
To remove a column from a View, complete the following:
Click the “X” to the right of the column name to remove.
To rearrange the columns in a View, complete the following:
Drag the column to the appropriate location in the list of visible columns.
Ensure you click ‘Apply’ to save the modified columns displayed.
Please note that Display Columns DO NOT persist. When you move away from the View, any modifications will be lost.
Users can sort data in a view for one or more columns. Sorting can be done by clicking on a column to sort in ascending or descending order.
Sorting can also be done by clicking on the Sorting button and selecting the column(s) to be sorted and the order in which the sorting should occur.
Sorting Columns DO NOT persist, when you move away from the View any modifications will be lost.
Scrolling “Top” & “Bottom” allows you to jump from the top to the bottom of a view without scrolling.
Row height can be either Collapsed or Expanded using the Row Height drop-down.
In addition to the row height selection, you can now also manually resize a row (or multiple rows if you select more of them). You can also double click on the default row number on the left to auto expand the row height.
Cinchy allows you to freeze and unfreeze a row similar to Excel.
To freeze or unfreeze a row, complete the following:
Select the row for freezing/unfreezing
Right-click on the row and select Freeze/Unfreeze Row from the menu
Cinchy allows you to freeze and unfreeze a column similar to Excel.
To freeze or unfreeze a column, complete the following:
Select the column for freezing/unfreezing
Right-click on the column and select Freeze/Unfreeze Column from the menu
