February 4, 2022 at 8:16 am
OK so I have a customer with a hosted website with eCommerce options. Essentially if you a good CC and the shipping address matches the address on the card, they will take your order.
This order information is stored in a MySQL database that they log into via a website, where they proceed to physically print these orders and and re-key the info into their ERP system manually. (ugly I know). This ERP system is the MS SQL 2012 I mentioned in the title.
So we already have a very nice API for the ERP system, but it only reads other MS SQL tables. So I want to use SQL Server Integration Services (SSIS) https://9apps.ooo/ to periodically get the MySQL data and dump it into a MS SQL table. Then the API can take it from there and eliminate the manual entry.
My issue is I have never done anything like this from an external data source and a non MS SQL data source at that.
Is this doable? Has anyone else out there handled anything similar to this? I thought I would just jump in and start to try this myself but then I thought I'd ask here first. Any insights appreciated.
February 4, 2022 at 3:40 pm
Found an old article on this, but I expect it is still valid:
I would recommend doing it on a test system first and trying things out and once you are happy that it works, then migrate the package to live. I never test anything SSIS against live. I will sometimes pull data from live and push to a test environment, but I prefer to pull from test and push to test so I don't have to worry about data changing while I am validating that it worked as I expected.
Also - something to note when working with SSIS, if you are deploying to a SQL Server 2012 instance, make sure you use SSIS 2012 or deploy from Visual Studio to reduce the chance of error.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply