Data source table information

The following information can help you with the FTP import and export data.

Data source types

Data sources are used to create an import set so that data can be processed, if necessary, prior to being mapped onto a production table.

Label Name File Data is in a recognized file format, accessible locally or remotely through several file retrieval methods. JDBC Data is in a database, accessible using JDBC. ServiceNow Technical Support supports Oracle, MySQL, Sybase, DB2 Universal, and MS SQL Server drivers. LDAP Data is in an LDAP server, accessible through the LDAP or LDAPS ports, 389 and 636 respectively. OIDC Data is accessible via OIDC. REST (IntegrationHub) Data is in a REST API, accessible through IntegrationHub. Data Stream IntegrationHub Data is loaded from a Data Stream Action, accessible through IntegrationHub. Custom (Load by Script) Data is obtained using a custom script.

Folder structure

See the following folder structure. You can use the <type>.request for taking the data and <type>.response for posting the data back to the FTP server:

catalog.request
catalog.response

invoice.request
invoice.response

orders.request
orders.response

shipment.request
shipment.response

Associated Table Transform Map

To import data, define a data source and transform map, and schedule or run an import at some regular interval.

Table transform map is associated with the table to transform the File Based Catalog Import [sn_spend_ftp_intg_catalog_stage] data into Catalog Import [sn_spend_intg_imp_catalog]. See the following table transform labels and associated table information.

Label Name Invoice Import sn_spend_intg_imp_invoice Catalog Import sn_spend_intg_imp_catalog Availability Import sn_spend_intg_imp_availability Shipment Import sn_spend_intg_imp_shipment Order Acknowledgment sn_spend_intg_imp_purchase_order_ack Price Import sn_spend_intg_imp_price

• Payloads samples and errors
  Use the following sample payloads to enable procurement data import and export.

Parent Topic:Procurement File Transfer Framework