Skip to Content

Sybase connection guide for Jitterbit App Builder

Overview

This guide describes the system requirements and instructions for connecting App Builder to an Sybase ASE database server.

System requirements

Database server

Sybase ASE Database Server

Client web browser

  • Chrome: 84+

  • Firefox: 73+

  • Safari: 13.0.1+

  • Edge: 84+

Connection instructions

Adding a server

  1. Navigate to the App Builder IDE

  2. From the Connect menu, click the Data Servers button

  3. Click the + Server button on the top left of the Data Servers panel. This will bring up the Server page.

    • Server Name: Identifiable name for server connection

    • Type: Sybase ASE

    • Host Name: Host associated with Sybase ASE Database instance

    • Instance Name: Instance name is actually the database name

    • Port: Will default as 5000 but double check server settings to see if it is different from default port

    • Instance Name: Name of the Sybase ASE instance

    • User Name/Password: Credentials associated with Sybase ASE DB Database instance

    attachment

  4. Click Save to complete server connection

  5. From Testing, click Test Connection to ensure connection works properly

Importing database

  1. Navigate to the App Builder IDE

  2. From the Connect menu, click on the Data Servers button

  3. From the Data Servers panel, locate the Sybase Data Server and select it

  4. Click the Details button on the right-hand panel

  5. Click the Import button. Sybase ASE Server Connections will populate the Data Storage Layer with a NoSQL Data Source.

    attachment

  6. Expand Import Capabilities

    • Import Pattern: This allows users to import specified tables by listing them in this field. Prefixes can also be used to only import a subset of tables (for example, MyApp_* will import tables that start with "MyApp_"). If the space is left blank, it will import all tables.

    • Click Save to update any changed data source settings

    • Click the Import button to import data. When prompted, click Proceed. The import will be scheduled by App Builder to run in the background.

Reference