Skip to main content

Capabilities for Sybase ASE

Justin Stevenson
Updated

Capabilities for Sybase ASE

This section lists the of Fivetran Local Data Processing when using 'Sybase ASE'. For more information about the pre-requisites, access privileges, and other configuration requirements, see .

Capture

Local Data Processing supports the following capabilities on Sybase ASE:

  • changes from location (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Log-based capture (capture from DBMS logging system) (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Capture from Archive log files only (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Log-based capture of tables without a primary key (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Direct access to logs on a file system (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Log-based capture of tables with LOB column (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Rewind log-based capture to specific time ( option -i) (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Online refresh using accurate LSN/SCN (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Populates column hvr_cap_user for use in {hvr_cap_user} substitutions (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Multiple log-based capture jobs can capture from same database (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Log-based capture checkpointing using location property Capture_Checkpoint_Frequency (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Read archives from an alternative directory (location property Archive_Log_Path on the capture location) (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).

Local Data Processing does not support the following capabilities on Sybase ASE:

  • Access to logs using SQL interface.
  • Log-based capture from hidden rowid/RRN column ( with parameter CaptureFromRowId).
  • Rewind log-based capture to the beginning of currently active oldest transaction.
  • Log-based capture of truncate table statements.
  • Capture from tables with basic compression.
  • Trigger-based capture (location property Capture_Method=DB_TRIGGER on the capture location).

Repository Database

Local Data Processing does not support Repository database on Sybase ASE.

Integrate

Local Data Processing supports the following capabilities on Sybase ASE:

  • changes into location (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Burst integration ( with parameter Method=BURST) (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • with parameter BurstCommitFrequency (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Continuous integration ( with parameter Method=CONTINUOUS) (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Tables without a key and without with NoDuplicateRows for continuous integration (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Continuous with parameter OnErrorSaveFailed (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • with parameter SoftDelete (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Creation and update of Local Data Processing state tables (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).

Local Data Processing does not support the following capabilities on Sybase ASE:

  • Disable/enable database triggers during (with parameter NoTriggerFiring).
  • with parameter DbProc.

Bi-directional Replication

Local Data Processing supports the following capabilities on Sybase ASE:

  • Detection of changes made by Local Data Processing in a bidirectional channel to prevent loop-back (Sybase ASE from version 16.0 SP00 to version 16.0 SP03, state table needs to be created before replication starts).
  • with parameter TimestampColumn (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).

Local Data Processing does not support the following capabilities on Sybase ASE:

  • with Log-based Capture (without parameter TimestampColumn).

Refresh and Compare

Local Data Processing supports the following capabilities on Sybase ASE:

  • or from source location (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • into target location (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Row-wise into target location (option -g) (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).

Local Data Processing does not support the following capabilities on Sybase ASE:

  • Select more than 4 billion rows during or .

Other Capabilities

Local Data Processing supports the following capabilities on Sybase ASE:

  • International table and column names where DBMS is not configured with UTF-8 encoding (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).
  • Treat DBMS table names and columns as case sensitive if configured (location property Case_Sensitive_Names) (Sybase ASE from version 16.0 SP00 to version 16.0 SP03).

Local Data Processing does not support the following capabilities on Sybase ASE:

  • Use distribution key for parallelizing changes within a table ( with parameter DistributionKey).
  • Distinguish and support capture from 'materialized views'.

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk