{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":50298,"path":"source-to-pay-operations/sourcing-and-procurement-operations/data-sources-info.md","title":"Data source table information","bundle":null,"doc_type":null,"release":"australia","body":"\n# Data source table information\n\nThe following information can help you with the FTP import and export data.\n\n## Data source types\n\nData sources are used to create an import set so that data can be processed, if necessary, prior to being mapped onto a production table.\n\n|Label|Name|\n|-----|----|\n|File|Data is in a recognized file format, accessible locally or remotely through several file retrieval methods.|\n|JDBC|Data is in a database, accessible using JDBC. ServiceNow Technical Support supports Oracle, MySQL, Sybase, DB2 Universal, and MS SQL Server drivers.|\n|LDAP|Data is in an LDAP server, accessible through the LDAP or LDAPS ports, 389 and 636 respectively.|\n|OIDC|Data is accessible via OIDC.|\n|REST \\(IntegrationHub\\)|Data is in a REST API, accessible through IntegrationHub.|\n|Data Stream IntegrationHub|Data is loaded from a Data Stream Action, accessible through IntegrationHub.|\n|Custom \\(Load by Script\\)|Data is obtained using a custom script.|\n\n## Folder structure\n\nSee 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:\n\n```\ncatalog.request\ncatalog.response\n\ninvoice.request\ninvoice.response\n\norders.request\norders.response\n\nshipment.request\nshipment.response\n```\n\n## Associated Table Transform Map\n\nTo import data, define a data source and transform map, and schedule or run an import at some regular interval.\n\nTable 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.\n\n|Label|Name|\n|-----|----|\n|Invoice Import|sn\\_spend\\_intg\\_imp\\_invoice|\n|Catalog Import|sn\\_spend\\_intg\\_imp\\_catalog|\n|Availability Import|sn\\_spend\\_intg\\_imp\\_availability|\n|Shipment Import|sn\\_spend\\_intg\\_imp\\_shipment|\n|Order Acknowledgment|sn\\_spend\\_intg\\_imp\\_purchase\\_order\\_ack|\n|Price Import|sn\\_spend\\_intg\\_imp\\_price|\n\n-   **[Payloads samples and errors](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/source-to-pay-operations/sourcing-and-procurement-operations/payloads-information.md)**  \nUse the following sample payloads to enable procurement data import and export.\n\n**Parent Topic:**[Procurement File Transfer Framework](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/source-to-pay-operations/sourcing-and-procurement-operations/procurement-file-transfer-framework.md)\n\n"}}