Open topic with navigation

TIBCO Flogo® Connector for Oracle MySQL 2.4.5

# Manually Configuring Metadata

You can use the Manually Configure Metadata option to fetch table metadata manually.

When the field is set to `True`, one more Query field at the bottom of this option is displayed. To retrieve and configure the database schema fields, you must first enter a simple schema query in this field and click Fetch. For example, you can enter the following schema query to fetch the metadata:

`SELECT * FROM CUSTOMERS;`

After the successful processing of the query, the table field at the bottom is populated with the column metadata information. You can add, edit, and remove fields in the table. The fields marked as Selected in the table are available on the Output tab of the activity. The fields selected in the Parameter column are available on the Input tab of the activity. The fields selected in the Value column are available on the Output tab of the activity. You can modify these settings by selecting or clearing the checkboxes.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO Flogo® Connector for Oracle MySQL

Copyright © 2020-2024. Cloud Software Group, Inc. All Rights Reserved. Confidential & Proprietary.