Ansible-Sybase

Included content

• Modules:

  • sybase_db: Database import/export using bcp wrapper, and removal/simple creation using pyodbc and FreeTDS python drivers.
  • sybase_isql: Run SQL scripts using isql64 or isql command wrapper.
  • sybase_query: Run SQL queries using pyodbc and FreeTDS python drivers.

• Roles:

  • sybase-ase: Install SAP Adaptive Server Enterprise (ASE / Sybase) server
  • sybase-ocs: Install SAP OpenClient (OCS) client
  • liquidbase: Install Liquidbase database development tool
  • openjdk-8: Install AdoptOpenJDK 8 (required for roles/liquidbase)
  • common-firewall (vagrant only): Manage firewalld (Required for roles\sybase-ase)

Cloning

This repository is designed as per Ansible Collections guidelines. It therere required to clone this repository in a specific directory structure.

mdkdir -p ansible_collections/sqlops/ && \
cd ansible_collections/sqlops/ && \
git clone "https://github.com/fjudith/ansible-sybase" sybase

Tested with Ansible

• 2.9.x: Centos 7, Ubuntu Bionic (18.04 LTS), Ubuntu Focal (20.04 LTS)
• 2.10.x: : Centos 7, Ubuntu Bionic (18.04 LTS), Ubuntu Focal (20.04 LTS)

Roadmap

Please refer to the ROADMAP for more details on the progress.

Technologies

• Vagrant: Local development environment provisionning
• Cloud-Init: Initial instance bootime provisionning
• Ansible: Software provisionning and configuration management
• Liquibase: Database operation management

Languages

• Ansible: YAML based Domain-specific language (DSL) for configuration management
• Ansible-Lint: Code style compliance processor
• Bash: Language used for general shell scripting
• Python: Language used to write unit tests and Ansible modules
• PyODBC: Open source Python module that makes accessing ODBC databases simple
• Powershell Core: Language used for Windows specific shell scripting (ref. hack)

License