This dialog appears when you right-click the Tables node in a connection and click Add Table on the shortcut menu in the Catalog Browser. It helps you to add tables into a JReport catalog via the connection you set up, and varies according to connection types.
If it is a JDBC or HIVE connection, options in the dialog are as follows. See the dialog.
Database Catalogs
Lists all the catalogs in the database.
Schemas
Lists the schemas you have selected in the Schema tab of the Get JDBC Connection Information dialog.
Show All Schemas
If checked, all schemas in the selected catalog will be shown in the Schema box.
Tables
Lists the tables contained in the selected schema after you click the Load Tables button.
Connection
Shows the name of the current connection.
Table Name Pattern
Specifies whether to filter the tables according to the specified filtering condition.
Include System Table
If checked, the system tables will become available in the Tables box.
Include Added Table
If checked, the tables that have been added to the catalog will become available in the Tables box. You can then add them into the catalog again with a different name.
Load Tables
Loads the tables contained in the specified schema into the Tables box.
Add
Adds the selected tables to the JReport catalog.
Done
Completes the adding tables process and closes the dialog.
Help
Displays the help document about this feature.
If it is an XML connection, options in the dialog are as follows. See the dialog.
Database Catalogs
Lists all the catalogs in the database. Not supported on XML connection.
Schemas
Lists the schema transformed from the XML source.
Tables
Lists the tables contained in the schema after you click the Load Tables button.
Connection
Shows the name of the current connection.
Load Tables
Loads the tables contained in the specified schema into the Tables box.
Add
Adds the selected tables to the JReport catalog.
Done
Completes the adding tables process and closes the dialog.
Help
Displays the help document about this feature.
If it is a web service connection, options in the dialog are as follows. See the dialog.
Service Name
Contains all the service information defined in the WSDL file. Select one you want from the drop-down list.
Port Type
Specifies the port type for the selected service. A port type is a set of abstract operations and the abstract messages involved. Available only when the web service is defined by WSDL 1.1. Select one you want from the drop-down list.
Operation Name
Contains all the operation information for the selected service. Select one you want from the drop-down list. An operation is an abstract description of an action supported by the service. Each operation refers to an input message and output messages.
Time Out
Specifies how long to wait to get the service and operation information defined in the WSDL file.
Use Schema from Response
This option is available only when the web service is defined by WSDL 1.1.
When the XML schema in the output message does not match the specific XML instance in the SOAP responded from web service, JReport will not be able to read data properly from that XML instance. In this condition, you can use this option to control whether to ignore the XML schema in the output message and parse the XML schema directly from the specific XML instance in the SOAP for the web service.
Input Message
Lists the input message information for the selected operation.
Value
Specifies the value for the input message. Type in the value, or define a constant level formula or a parameter to be the value.
OK
Accepts the adding table result and closes the dialog.
Cancel
Cancels the adding table process and exists the dialog.
Help
Displays the help document about this feature.
If it is a MongoDB connection, options in the dialog are as follows. See the dialog.
Tables
Lists the tables transformed from the MongoDB schemas.
Added Tables
Lists the tables that you have added.
Adds the selected tables.
Removes the selected tables from the Added Tables box.
OK
Accepts the adding table result and closes the dialog.
Cancel
Cancels the adding table process and exists the dialog.
Help
Displays the help document about this feature.