## Add Table dialog

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 Schemas 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 or JSON 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.

###### Related topics:

- Tables/Views/Synonyms
- Managing tables in a JSON connection
- Managing tables in an XML connection
- Adding tables to a web service connection
- Managing tables in a MongoDB connection