Understanding Data Origination Types

How to use a data origination type in a data set

The type of data origination you choose when creating a data set depends on where your data comes from, how it's structured, and how you need to access it. There are three available options: SQL Query, HTTP GET, and XML Query. Here's when to use each:

Use SQL Query when:

• Your data is stored in a relational database, such as SQL Server.

• You want to query tables or views using SQL syntax (for example, SELECT * FROM customers).

• You need to filter, sort, or join data using SQL logic.

SQL Query is ideal for internal business applications, forms linked to ERP or CRM systems and dashboards and reporting tools. 

It’s fast, efficient, and well-suited for working with structured, table-based data.

Use HTTP GET when:

• You're retrieving data from an external API or web service.

• The data source is online and responds to HTTP requests.

• You need to access real-time or external system data, such as third-party services or cloud-based platforms.

HTTP GET is best for integrations with public APIs and connecting to Cloud apps. It allows you to connect to REST APIs using a URL to fetch exactly the data you need.

Use XML Query when:

• You're pulling data from IFS FSM or other systems that return data in XML format.

• You need to extract specific values from structured XML documents.

XML Query is best when working with data stored or exchanged as XML and services that don’t support SQL or REST but return XML responses.

If you're unsure which option is right for your needs, consult your IT department or reach out to support@omnibyte.com for assistance.