CA Datacom Data Source

You can modernize or extend your applications by enabling data and services for CA Datacom.
lac52
You can modernize or extend your applications by enabling data and services for CA Datacom. You can then unlock and expose this data using 
Layer7 Live API Creator
. This article includes information about how to install the JDBC driver for Datacom and how to connect to a Datacom database. It also includes a list of the Datacom data types that 
Layer7 Live API Creator
 supports. With the JDBC driver installed, the 
CA Datacom
 data source is available as an option in the connection wizard when creating an API.
In this article:
Install the JDBC Driver for Datacom
The self-contained, single-user version of 
Layer7 Live API Creator
 that is based on Jetty includes the JDBC driver for Datacom. The JDBC driver is located in the 
%JETTY_HOME%/caliveapicreator/lib/ext
 directory. If you have installed this version of 
Layer7 Live API Creator
, no additional steps are required to install the JDBC driver.
If you have installed 
Layer7 Live API Creator
 on another Java container, such as Apache Tomcat, copy the license file and the cadcjdbc
.jar
 file (the JDBC driver) that is located in the 
databaseDrivers
 directory into the directory that is based on the Java container on which you have installed 
Layer7 Live API Creator
For more information about the JDBC drivers that 
Layer7 Live API Creator
 supports, see Installation Requirements and Supported Platforms.
Connect to a Datacom Database
You can connect to your Datacom database using the following methods:
  • (If you have not created your API yet) When you create your API.
    For more information about how to create an API, see Creating APIs.
  • (If you have an existing API) By adding a connection to a Datacom data source.
    For more information about how to add a connection to a data source, see Installing and Upgrading.
The following procedure details how to connect to your Datacom database when creating your API.
When connecting to a Datacom database with multiple AUTHIDs or authorization attributes (schemas), add separate Datacom data source connections for each AUTHID or authorization attribute.
For more information about how to add connections to data sources, see Database Connectivity.
Prerequisites:
 You know your JDBC connection information. 
Follow these steps:
 
  1. In API Creator, on the APIs page, click 
    Create New API
    .
    The connection wizard opens.
  2. Click 
    Database First
    .
    The second step in the wizard appears.
  3. Select 
    CA Datacom
     as the data source type.
    The third step in the wizard appears.
  4. Complete the 
    Host [optional Port]
     and 
    Password
     fields, including the following fields, and then click 
    Continue
    :
    ServerName
    Enter the name of the server.
    Example:
     MY_DATACOM_SERVER
    Schema
    The database-dependent name that points to your schema on the Datacom server. In Datacom, this value is referred to as AUTHID or the authorization attribute.
    Example:
     MYSCHEMA
    Case Sensitive:
     Lowercase is equivalent to uppercase. For example, foo, Foo, and FOO are all equivalent and are converted to uppercase (FOO). If the value uses mixed case, enclose the name in double quotes ("), for example, "Foo". You can enclose the value with the correct case and unusual characters using double-quotes ("). 
    Username
    The user name under which you access your database. You database administrator (DBA) assigns you a user name.
    Example: 
    DBADMIN
    Case Sensitive: 
    Lowercase is equivalent to uppercase. For example, foo, Foo, and FOO are all equivalent and are converted to uppercase (FOO). If the value uses mixed case, enclose the name in double quotes ("), for example, "Foo". You can enclose the value with the correct case and unusual characters using double-quotes (").
You are connected to the database.
Datacom Supported Data Types
When you are setting up a connection to an external data source, 
Layer7 Live API Creator
 must map the data types in the data source to data types in 
Layer7 Live API Creator
. The following table lists the different data type mappings applicable when working with a Datacom database.
For more information about the data type definitions, see the CA Datacom documentation.
You can read and write the following Datacom data types in 
Layer7 Live API Creator
:
Data Type
Modeled as...
Notes
CHAR
string
DATE
SimpleDate
For more information about how to use this data type in JavaScript, see Date, Time, Timestamp, and TimestampOffset.
DECIMAL
decimal
signed and unsigned
DOUBLE
double
FLOAT
float
GRAPHIC
string
INTEGER
integer
LONG VARCHAR
string
NUMERIC
bigdecimal
signed and unsigned
REAL
float
SMALLINT
integer
TIME
SimpleTime
For more information about how to use this data type in JavaScript, see Date, Time, Timestamp, and TimestampOffset.
TIMESTAMP
SimpleTimestamp
For more information about how to use this data type in JavaScript, see Date, Time, Timestamp, and TimestampOffset.
VARCHAR
string
VARGRAPHIC
string
Manage Stored Procedures
Layer7 Live API Creator
 exposes the stored procedures in your database and makes them available as RESTful resource endpoints.
View your Stored Procedures
You can view your stored procedures in API Creator. With your API open, in the Create section, click 
Schema
, and then click the 
Procedures
 tab. API Creator displays your stored procedures as a list of names of each stored procedure.
Identify and Reference Stored Procedures
Stored procedures with unique names appear as REST endpoints.
The following example shows how you can identify or reference the 
myProcedure
 stored procedure in 
Layer7 Live API Creator
:
<prefix>:myProcedure
Test Stored Procedures
Test your stored procedures in the REST Lab. Issue a POST request while passing the 
IN
 argument values.
For more information:
Datacom Data Source Limitations
The following are known limitations in Datacom data sources:
  • The JDBC driver for Datacom includes a limitation that prevents you from doing the following:
    • Calling stored procedures that include parameters. The JDBC driver returns an error.
    • Testing connections to Datacom data sources.
      For more information about this known issue, see Release Notes.
  • If you are connected to a Datacom data source, you cannot add comments (for example, using the –, /*, or // symbols) to the SQL for Free SQL resources.
    For more information about Free SQL resources, see Define Free SQL Resource Types.