Data source table information

Source-to-Pay Operations > Sourcing and Procurement Operations >

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 .request for taking the data and .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: <a class="link" href="../../../product/sourcing-procurement-operations/concept/procurement-file-transfer-framework.html" title="Procurement File Transfer Framework (PFTF) helps you transfer information between the ServiceNow database and a third-party reseller through a File Transfer Protocol (FTP). You can set up an FTP server for access and transfer of reseller data without any spoke development by the third-party reseller.">Procurement File Transfer Framework