Anaconda provides access to the foundational open-source Python and R packages used in modern AI, data science, and machine learning. These enterprise-grade solutions enable corporate, research, and academic institutions around the world to harness open-source for competitive advantage and research. Anaconda also provides enterprise-grade security to open-source software through the Premium Repository.
$0
per month
SSIS
Score 7.9 out of 10
N/A
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
I have asked all my juniors to work with Anaconda and Pycharm only, as this is the best combination for now. Coming to use cases: 1. When you have multiple applications using multiple Python variants, it is a really good tool instead of Venv (I never like it). 2. If you have to work on multiple tools and you are someone who needs to work on data analytics, development, and machine learning, this is good. 3. If you have to work with both R and Python, then also this is a good tool, and it provides support for both.
Ideal for daily standard ETL use cases whether the data is sourced from / transferred to the native connectors (like SQL Server) or FTP. Best if the company uses MS suite of tools. There are better options in the market for chaining tasks where you want a custom flow of executions depending on the outcome of each process or if you want advanced functionality like API connections, etc.
Anaconda is a one-stop destination for important data science and programming tools such as Jupyter, Spider, R etc.
Anaconda command prompt gave flexibility to use and install multiple libraries in Python easily.
Jupyter Notebook, a famous Anaconda product is still one of the best and easy to use product for students like me out there who want to practice coding without spending too much money.
I used R Studio for building Machine Learning models, Many times when I tried to run the entire code together the software would crash. It would lead to loss of data and changes I made.
SSIS has been a bit neglected by Microsoft and new features are slow in coming.
When importing data from flat files and Excel workbooks, changes in the data structure will cause the extracts to fail. Workarounds do exist but are not easily implemented. If your source data structure does not change or rarely changes, this negative is relatively insignificant.
While add-on third-party SSIS tools exist, there are only a small number of vendors actively supporting SSIS and license fees for production server use can be significant especially in highly-scaled environments.
It's really good at data processing, but needs to grow more in publishing in a way that a non-programmer can interact with. It also introduces confusion for programmers that are familiar with normal Python processes which are slightly different in Anaconda such as virtualenvs.
Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
I am giving this rating because I have been using this tool since 2017, and I was in college at that time. Initially, I hesitated to use it as I was not very aware of the workings of Python and how difficult it is to manage its dependency from project to project. Anaconda really helped me with that. The first machine-learning model that I deployed on the Live server was with Anaconda only. It was so managed that I only installed libraries from the requirement.txt file, and it started working. There was no need to manually install cuda or tensor flow as it was a very difficult job at that time. Graphical data modeling also provides tools for it, and they can be easily saved to the system and used anywhere.
SQL Server Integration Services is a relatively nice tool but is simply not the ETL for a global, large-scale organization. With developing requirements such as NoSQL data, cloud-based tools, and extraordinarily large databases, SSIS is no longer our tool of choice.
Raw performance is great. At times, depending on the machine you are using for development, the IDE can have issues. Deploying projects is very easy and the tool set they give you to monitor jobs out of the box is decent. If you do very much with it you will have to write into your projects performance tracking though.
Anaconda provides fast support, and a large number of users moderate its online community. This enables any questions you may have to be answered in a timely fashion, regardless of the topic. The fact that it is based in a Python environment only adds to the size of the online community.
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
I have experience using RStudio oustide of Anaconda. RStudio can be installed via anaconda, but I like to use RStudio separate from Anaconda when I am worin in R. I tend to use Anaconda for python and RStudio for working in R. Although installing libraries and packages can sometimes be tricky with both RStudio and Anaconda, I like installing R packages via RStudio. However, for anything python-related, Anaconda is my go to!
I had nothing to do with the choice or install. I assume it was made because it's easy to integrate with our SQL Server environment and free. I'm not sure of any other enterprise level solution that would solve this problem, but I would likely have approached it with traditional scripting. Comparably free, but my own familiarity with trad scripts would be my final deciding factor. Perhaps with some further training on SSIS I would have a different answer.
It has helped our organization to work collectively faster by using Anaconda's collaborative capabilities and adding other collaboration tools over.
By having an easy access and immediate use of libraries, developing times has decreased more than 20 %
There's an enormous data scientist shortage. Since Anaconda is very easy to use, we have to be able to convert several professionals into the data scientist. This is especially true for an economist, and this my case. I convert myself to Data Scientist thanks to my econometrics knowledge applied with Anaconda.
