CA Datacom Data Source
You can modernize or extend your applications by enabling data and services for CA Datacom.
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 Creatorsupports. With the JDBC driver installed, the
CA Datacomdata 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 Creatorthat is based on Jetty includes the JDBC driver for Datacom. The JDBC driver is located in the
%JETTY_HOME%/caliveapicreator/lib/extdirectory. 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 Creatoron another Java container, such as Apache Tomcat, copy the license file and the cadcjdbc
.jarfile (the JDBC driver) that is located in the
databaseDriversdirectory 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 Creatorsupports, 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:
- In API Creator, on the APIs page, clickCreate New API.The connection wizard opens.
- ClickDatabase First.The second step in the wizard appears.
- SelectCA Datacomas the data source type.The third step in the wizard appears.
- Complete theHost [optional Port]andPasswordfields, including the following fields, and then clickContinue:ServerNameEnter the name of the server.Example:MY_DATACOM_SERVERSchemaThe 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:MYSCHEMACase 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 (").UsernameThe user name under which you access your database. You database administrator (DBA) assigns you a user name.Example:DBADMINCase 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 Creatormust 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:
signed and unsigned
signed and unsigned
Manage Stored Procedures
Layer7 Live API Creatorexposes 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
Procedurestab. 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
myProcedurestored procedure in
Layer7 Live API Creator:
Test Stored Procedures
Test your stored procedures in the REST Lab. Issue a POST request while passing the
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.