Versions Compared

Old Version 7

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Amy Smith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

...

The database must be set up with permissions for the Datical user before you create DbDefs for it. 

See Configuring Databases for Datical DB Liquibase Enterprise Release Pipelines. 

Information in a Step

The information in a step includes:

...

Project Creation Scripts

See Creating a Datical Project Liquibase Enterprise Using the Project Creation Script (project_creator.groovy).


DB2 Database Step Settings

...

Datical DB GUIDescription
Connection Settings
HostnameHostname or IP address for the database.
Port50000 by default. 
DatabaseDatabase name
REORG:
  •  Automatically Perform with each Deploy

Perform a DB2 reorg operation when changes are deployed to this step. The operation reclaims unused space. 

z/OS:

  •  Connection targets DB2 for z/OS

Select if this is a DB2 system running on z/OS

Database Credentials
UsernameService name used by Datical to access the managed database for the step. 
PasswordPassword for the service name.  We strongly recommend to use runtime credentials because it is more secure than stored credentials (due to the possibility of the stored password being decoded).
Optional Information
ContextsAffects where changesets are deployed.
LabelsDefines labels to be applied to changesets deployed to this step. 
Schema NameSchema name to use. Requires Database property. 
CLPPlus Timeout (seconds)Time to wait for a CLPPlus script to complete.  We recommend setting a value for this for all of your REF dbDefs, but only your REF dbDefs.

Storage Settings:

  •  Include Table and Index Storage Information
Include information about where and how the database is stored. 
Project Creation Settings
Baseline
  •  Create Baseline Changelog - select to create a baseline changelog from a snapshot of the schema. All objects currently in the database are captured and represented in the changelog. 
StoredLogic
  •  Externalize Stored Logic (Procedures, Package, Functions) - select to save stored logic objects outside of the changelog. 

...

Datical DB GUIDescription
Connection Settings
Connection Type:

Choose one:

  • BASIC - Basic (EZCONNECT) connection. Requires the following properties:
    • Hostname
    • Port
    • Service Name or SID
  • TNSNAMES/LDAP - TNSNAMES (local file) or LDAP (server). Requires the following properties:
    • TNS Alias
HostnameHostname or IP address for the database.
Port1521 by default
Identifier

Choose one and provide value:

  • Service Name - Oracle Service Name, orcl is the default
  • SID - Oracle Service Identifier
TNS Alias

Service Name. It must match the service name you want

  • TNSNAMES - service name defined in a tnsnames.ora file
  • LDAP - service name defined on an LDAP server. The LDAP server is one specified in an ldap.ora file

Accelerator:

  •  Enable Accelerator for Oracle (Improves PerformanceImproved performance in some environments)
Off by default. Datical provided an optional accelerator that compressed results before sending them from the database over the network and then decompressed them when they are received.  The accelerator/compression driver was only available with versions 7.15 or lower.  It has been deprecated with versions 7.16 and higher.
Database Credentials
UsernameService name used by Datical to access the managed database for the step. 
PasswordPassword for the service name.  We strongly recommend to use runtime credentials because it is more secure than stored credentials (due to the possibility of the stored password being decoded).
Optional Information
ContextsAffects where changesets are deployed.
LabelsDefines labels to be applied to changesets deployed to this step. 
Schema NameSchema to use.
SQL*Plus Timeout (seconds)Time to wait for a SQL*Plus script to complete. We recommend setting a value for this for all of your REF dbDefs, but only your REF dbDefs.

Storage Settings

  •  Include Table and Index Storage Information

Include the storage clause information for XML changesets. The storage clause will be derived based upon the settings of the RefDB.  Storage information includes table and index partition settings.  You must include table and index storage information when packaging partitioned objects using the DDL or CONVERT package method.

Project Creation Settings
Baseline
  •  Create Baseline Changelog - select to create a baseline changelog from a snapshot of the schema. All objects currently in the database are captured and represented in the changelog. 
StoredLogic
  •  Externalize Stored Logic (Procedures, Package, Functions) - select to save stored logic objects outside of the changelog. 

...


PostgreSQL Database Step Settings


Datical DB GUIDescription
Connection Settings
HostnameHostname or IP address for the database.
Port5432 by default
DatabaseDatabase to access
Database Credentials
Username

Service name used by Datical to access the managed database for the step.

 



Note: To create a username, you must initially run:

CREATE USER "<datical_user>" WITH PASSWORD '<password>'

to create a user.

Info
Azure Postgres ONLY: Once the user is created, your complete connection username should be <username>@<server_name>. It is essential that @<server_name> is at the end of the username.
Learn more here


PasswordPassword for the service name.  We strongly recommend to use runtime credentials because it is more secure than stored credentials (due to the possibility of the stored password being decoded).
Optional Information
ContextsAffects where changesets are deployed.
LabelsDefines labels to be applied to changesets deployed to this step. 
Schema NameSchema to use, requires Database property
EDB*Plus Timeout (seconds)Time to wait for an EDB*Plus or PSQL script to complete.  We recommend setting a value for this for all of your REF dbDefs, but only your REF dbDefs.

Storage Settings

  •  Include Table and Index Storage Information

Include information about where and how the database is stored. 

Project Creation Settings
Baseline
  •  Create Baseline Changelog - select to create a baseline changelog from a snapshot of the schema. All objects currently in the database are captured and represented in the changelog. 
StoredLogic
  •  Externalize Stored Logic (Procedures, Package, Functions) - select to save stored logic objects outside of the changelog. 

...

SQL Server Database Step Settings


Datical DB GUIDescription
Connection Settings
HostnameHostname or IP address for the database.
Port1433 by default
Application NameDatical DB (application accessing the database)
Database NameDatabase to access
Instance NameSQL Server instance to use (database server). The default instance is used if an instance name is not specified. 

Security

  •  Integrated Security

Use Windows authentication to access the database. 

When set for a DbDef, overrides the project setting to use runtime credentials. 

Database Credentials
UsernameService name used by Datical to access the managed database for the step. 
PasswordPassword for the service name. We strongly recommend to use runtime credentials because it is more secure than stored credentials (due to the possibility of the stored password being decoded).
Optional Information
ContextsAffects where changesets are deployed.
Labels

Defines labels to be applied to changesets deployed to this step. 

multiSubnetFailover(only applies to SQLServer) Allows you to connect to the availability group listener of a SQL Server availability group or a SQL Server Failover Cluster Instance.
Set to true to connect.
Schema NameSchema to use, requires Database property
SQLCMD Timeout (seconds)Time to wait for a SQLCMD script to complete.
  We recommend setting a value for this for all of your REF dbDefs, but only your REF dbDefs.
 

Storage Settings

  •  Include Table and Index Storage Information

Include information about where and how the database is stored. 

Project Creation Settings
Baseline
  •  Create Baseline Changelog - select to create a baseline changelog from a snapshot of the schema. All objects currently in the database are captured and represented in the changelog. 
StoredLogic
  •  Externalize Stored Logic (Procedures, Package, Functions) - select to save stored logic objects outside of the changelog.