Devart SSIS Data Flow Components Testimonials
Devart's product is quick to download and easy to install and easy to use in SSIS. The 30 day software trial supports data sources such as Oracle, MySQL, DB2, MailChimp, Salesforce, Bigcommerce, and 8 other data sources.
For my first test, I used the Devart Oracle Connection in the Data Flow tab of a project and entered the Server, Port, SID, User, and Password and clicked Test Connection button and it worked on the first try with my Oracle 11g database. Test Connection Succeeded. There were NO error messages about a TNS server not being able to connect, etc. as when working with the some of the free downloads available on the web that require hours of configuration only to find that you are still far from even starting your SSIS project. It was great! I then used the Devart Oracle Source and used the Oracle connection and it displayed the schema for the HR user that I had logged in as and also allowed me to view All Schemas as well from this component. I dragged and dropped the columns that I wanted to use into the Source and clicked OK and was almost done in accomplishing the task.
The next test used the Devart MySQL Connection to connect to a local instance of a MySQL 5.7 database with no problems. I used this connection in a Devart MySQL Lookup to view values and compare them to the data from my Oracle Source. To finish the project, I successfully pushed the data to 2 Excel Files (Lookup Match and Lookup No Match) perfectly! I also pushed data through from the Devart Oracle Source through a Data Conversion task into a SQL Server 2014 database with no issues.
I tried the Devart MailChimp connection by using the web login for my MailChimp account to see if the Devart connection would access it and it did with success and no complications! I pushed an email list out to Excel from the Devart MailChimp Source in SSIS easily via the web connection to MailChimp.
Anyone who has ever tried and been disappointed in a free API or other free download to connect to a non-Microsoft data source for SSIS tools needs this product. It works perfectly upon installation and performs exactly how you would expect. Spend less time troubleshooting and more time creating SSIS packages with many Data Sources with Devart SSIS Data Flow Components!
Michelle Ignacio, Integration Services Specialist in Rust | Omni