+4I would like to test this new functionality.
I’ve read: https://support.timextender.com/deliver-109/rest-api-endpoint-1808?tid=1808&fid=109
But I can't understand how to send the tables from the SSL instance to the target DB using this technique. Can you explain me with a clearer example?
Best answer by rory.smith
Hi,
that seems like something you might be able to hook into Exmon MDM or develop Powershell that generates API calls from a table. I tend to avoid implementing Data Integration scenarios directly in TimeXtender as those are usually operational processes and not batch-driven ones. The REST endpoint will definitely not support that scenario.
+7Hi,
this feature is meant to expose the dataset in your SSL / Deliver instance via a REST API hosted by an IIS instance. It is meant to allow pulls, not push into another target.
I.e. someone else / some other system can call this REST API and consume the data you defined in your SSL. The only thing you need to do other than the instructions state is allow the machine identity your IIS pool runs under to access the tables your SSL points to.
+4
Thanks @rory.smith, I am really looking for a method to transfer the data to an external DB that supports REST API to send the data to it.
+7Hi,
if your target DB is an Azure SQL DB and you have Azure API Management to allow the TX REST API to be called, you could invoke your REST API hosted by TX to load data (see: https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-invoke-external-rest-endpoint-transact-sql?view=azuresqldb-current&tabs=request-headers). But otherwise you would need to develop something custom.
+4POST > http(s)://[IP]/InaCatalogAPI/api/iClientes
+7Hi,
that seems like something you might be able to hook into Exmon MDM or develop Powershell that generates API calls from a table. I tend to avoid implementing Data Integration scenarios directly in TimeXtender as those are usually operational processes and not batch-driven ones. The REST endpoint will definitely not support that scenario.
+1Hi,
The original API Server is from Xpert BI and BI Builders. They implemented a PUSH feature. It was also called reverse ETL. This could be used to export data to another API server.
Please vote 😁
BR
Anders
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
