Our team is always striving to improve and innovate our entire suite of products. In our Fall 2016 release, LegiTest, LegiTest Server, Task Factory, DOC xPress, BI xPress and BI xPress Server have notable updates to help improve your data solutions. Here are some highlights of the new features and enhancements in our suite of tools:
Category: Products18 Results
Over the years, our customers have come to know Pragmatic Works as true experts in developing uniquely powerful ETL solutions through Microsoft SQL Server Integration Services (SSIS). Our industry experts have worked in countless customer environments, each with their own challenging data integration needs. Our consultants, who are NOT shy :), often tell us about their experiences and their long wish lists: "If only I could validate that a text file contained the expected information in the expected format before it completes" or "Man, I wish there was a way to conditionally update or insert data faster than I can today."
As a developer, do you often find yourself frustrated with tasks that should be easier to complete? There are many different aspects of the developer role that can be tedious and drawn out. That's why we created BI xPress to simplify your experience when working inside SSDT. Let’s take a look at some common practices in a BI environment and how BI xPress makes those practices easier and smoother to implement.
The new SQL Server 2016 release is just around the corner (June 1st) and we’re really looking forward to it at Pragmatic Works! It’s also a busy time for the Software team, as we have to make sure all of our products play well with the new SQL Server 2016 features. We have just released the 2016.2 build of all of our products, which is compatible with SQL Server 2016 RC3 and will also work with the 2016 RTM release when it is available.
In my first post on Task Factory's Oracle Upsert Destination, I gave you an in-depth "How To" demonstration. In this blog, I'm going to discuss some troubleshooting tips when you encounter errors.
If you’re an avid user of an Oracle Database, you are no stranger to the oddities that are presented when dealing with Oracle Errors. If this is you, then you may very well be familiar with the following scenario.
The Oracle Database presents a challenge to its users, that once mastered, can be rewarding and make the utilization of Oracle specific tools easier to grasp. If you are an avid Oracle user, you are familiar with the many aspects to Oracle that are vastly different than the standard SQL Server language many of us have grown to appreciate
Have you ever had an SSIS package fail because a source file it reads from was opened somewhere else? This can be especially frustrating if the package in question runs after hours or on weekends. In this post, I'll demonstrate how to avoid this issue with the Task Factory File Properties Task, the Task Factory Timer Task and a For Loop container.
Greetings everyone! Today we are going to create an SSIS package using the REST API Source component from Task Factory. Specifically, we are going to use this source component to connect to Zendesk’s API service. When using the REST API Source to connect to any service you must be knowledgeable on how that particular API and what are valid API endpoints.