Integration Task to gather API data using PowerShell

At the time of writing there isn't a SQL Server Integration Services (SSIS) task that will collect JSON or XML formatted data directly from an API call. There are various add-ons and products that are available however, it is straightforward to achieve this using PowerShell and since you are likely to use PowerShell to automate other tasks on [...] Read more

DreamFactory REST APIs

DreamFactory is a fantastic way to get RESTful APIs to your web and software development teams, it is especially easy when it comes to basic database integration. They have recently released DreamFactory 2.1 see http://blog.dreamfactory.com/dreamfactory-2-1-release-news Why reinvent the layers of security, database integration and event logging? [...] Read more