The CIC Studio supports database integration through several database-related objects - the Data Source, Database Schema, and Database Adapter, along with two specialized wizards: the Database Wizard and Database Refresh Wizard. These objects can be used to create a working integration, and help you keep your Studio objects in sync with changes made in your back-end database. For example, the Database Refresh Wizard can recognize database changes and then help you apply those changes to any relevant object used in database integrations.
This topic describes different ways to use and understand these database objects, and provides a summary description of the objects.
|Data Source||This object defines the information the CIC Studio needs to connect to a single database; it also specifies which tables, views, and columns to be interacted with.|
|Database Schema||The CIC Studio populates the Database Schema with the tables and columns specified in a Data Source, and reads the database's metadata to create the table and column properties.|
|Database Adapter||Database Adapters are used primarily to select data from and insert transformed data into a database. However, they can also aid in the management of database information. They can update columns in a single record or a group of records. They can also delete an individual record or a range of records. Database interaction is confined to a single database, but can span multiple tables.|
|Database Wizard||This wizard helps you create and define the Data Source, Database Schema, and Database Adapter in a single series of steps.|
|Database Refresh Wizard||This wizard updates multiple database-related object definitions simultaneously. When you point the Database Refresh Wizard to an existing Data Source, the CIC Studio detects changes made to the database, and it updates that Data Source to reflect those changes. Then, you can apply those additions, renames, and field changes to one or more selected Database Schemas that reference that Data Source. By extension, Database Adapters that reference those Database Schemas are automatically updated.|