Cloud Inventory® Documentation

About data sources

A data source contains information about a database and provides an interface between the database and Enhancement Engine.

You add a data source to Enterprise Printing Platform to connect to an Oracle, MS SQL Server, or MySQL Database Management System. After a data source has been added, use Enhancement Engine to access the data source directly by name in functions you write that apply data transformation to incoming label data for enhanced label output. For more information, see About Enhancement Engine.

Utilize the Data Sources setup page to configure a data source and test the connection between EPP and the data source.

Add data source

Add a data source to EPP to provide an interface between an Oracle, MS SQL Server, or MySQL Database Management System (DBMS) and Enhancement Engine.

To add a data source, complete the following steps in EPP.

Go to Admin > Data Sources.
Select Add.
Complete the following steps.
1. Enter a Name for the data source.
2. Select a Database Management System from the Server Type list.
3. Optional. Enter a Description for the data source.
4. Enter the Host Name for the DBMS.
5. Enter the Port for the DBMS.
6. Enter the Database Name.
7. Enter the User Name for the DBMS.
8. Enter the Password for the DBMS.
Step Information

Refer to Data source settings.
Optional. To test the connection between the data source and EPP, select Test Connection.
Select Save, and then Close.

Edit data source

You may need to edit data source settings when there is a DBMS change, such as a connection port number or user password.

To edit a data source, complete the following steps.

Go to Admin > Data Sources.
Select a data source, and then select Edit.
Edit the Data source settings.
Select Save, and then select Close.

Copy data source

You might want to quickly make a copy of a data source in order to keep one as a sandbox and use one in a production environment.

To copy a data source, complete the following steps in EPP.

Go to Admin > Data Sources.
Select a data source, and then select Copy.

Step Information

Note:The words Copy of are appended to the data source name. You must edit the name, as spaces are not permitted.
Edit settings as needed. Refer to Data source settings.

Data source settings

When you add a data source to EPP you provide information about the Database Management System (DBMS) that EPP is connecting with.

Data source setting	Description
Name	A name with which you identify the data source.
Server Type	The type of server on which the DBMS resides.
Description	Optional. A description with which to further identify the data source.
Host Name	The name of the system where the database is running.
Port	The port used to connect to the database.
Database Name	The name of the DBMS.
User Name	The user name of the person who is associated with the DBMS.
Password	The password associated with the User Name.

Delete data source

You can delete a data source. Any functions used by Enhancement Engine that reference the deleted data source will fail.

To delete a data source, complete the following steps in EPP.

Go to Admin > Data Sources.
Select a data source, and then select Delete.
To confirm that you want to delete the data source, select Yes.

Enterprise Printing Platform