Category: Automation

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: Vincent He. Dear all, We just announced SSIS on Linux CTP2.1 refresh, in this refresh,  besides many other improvements, we add a new feature which are queried by many customers during CTP2.1 – ODBC support. When the package is designed to use the ODBC connection, it will communicate with the ODBC driver manager and drivers installed on Linux system, the driver manager we have tested is unixODBC, and the drivers we have tested are MySQL and SQL Server ODBC driver, in theory, we support any unicode ODBC driver as long as ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: Leo Li - Program Manager of Microsoft. Dear all, I am very pleased to announce that the Linux version SSIS is available in CTP 2.1. Since March 2016 Microsoft announced that SQL Server plan to support Linux platform, SSIS team has been working on any possibility to also support SSIS on Linux OS. Now you can download SQL Server Integration Services CTP 2.1 and try it out on your Linux machines or VM by command lines. In this version, you can: Run SSIS packages on Linux OS, monitor and track execution ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: Vincent He. Dear all, We just announced SSIS on Linux (SSIS Helsinki) CTP2.1 refresh, in this refresh,  besides many other improvements, we add a new feature which are queried by many customers during CTP2.1 – ODBC support. When the package is designed to use the ODBC connection, it will communicate with the ODBC driver manager and drivers installed on Linux system, the driver manager we have tested is unixODBC, and the drivers we have tested are MySQL and SQL Server ODBC driver, in theory, we support any unicode ODBC driver as ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: HelenLi(SQL). As you may already known, SSIS Scale Out is available in SQL Server vNext CTP1. it provides the capability to parallel package execution by distributing the execution to multiple machines. In addition, you can get better performance of execution log writing from SSIS Scale Out. For the user who is used to using verbose logging level to run SSIS package, the performance of package execution will be downgraded heavily when verbose logging level is enabled, in this case the SSIS Scale Out is an excellent choice for you even you ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Justin De Castri. Connected devices have found their way into a myriad of commercial and consumer applications. Industries have already moved, or are in the process of moving to, operational models that require them to measure broad data points in real time and optimize their operations based on their analysis of this data. The move to smart connected devices can become expensive if expensive components must be upgraded across the infrastructure. This blog post explores how AWS IoT can be used to gather remote sensor telemetry and control legacy ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Michael Garcia. AWS IoT customers can now route messages from devices directly to Salesforce IoT Cloud with a new AWS IoT Rules Engine Action that requires only configuration.As part of the strategic relationship between AWS and Salesforce, the combination of AWS IoT and Salesforce IoT Cloud allows you to enrich the messages coming from your devices with customer data residing in Salesforce. This results in deeper insights and allow customers to act on those newly created insights within the Salesforce ecosystem. In this article, we are going to walk ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: Leo Li - Program Manager of Microsoft. Dear all, I am very pleased to announce that the Linux version SSIS is available in CTP 2.1. Since March 2016 Microsoft announced that SQL Server plan to support Linux platform, SSIS team has been working on any possibility to also support SSIS on Linux OS. Now you can download SQL Server Integration Services CTP 2.1 and try it out on your Linux machines or VM by command lines. In this version, you can: Run SSIS packages on Linux OS, monitor and track execution ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: JimmyWongMS. To see the Attunity connectors in the SSIS Toolbox, you always have to install the version of the connectors that targets the same version of SQL Server as the version of SQL Server Data Tools (SSDT) installed on your computer. (You may also have earlier versions of the connectors installed.) This requirement is independent of the version of SQL Server that you want to target in your SSIS projects and packages.+ For example, if you’ve installed the latest version of SSDT, you have version 17 of SSDT with a build ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: Leo Li - Program Manager of Microsoft. Dear all, I am very pleased to announce that the Linux version SSIS is available in CTP 2.1. Since March 2016 Microsoft announced that SQL Server plan to support Linux platform, SSIS team has been working on any possibility to also support SSIS on Linux OS. Now you can download SQL Server Integration Services CTP 2.1 and try it out on your Linux machines or VM by command lines. In this version, you can: Run SSIS packages on Linux OS, monitor and track execution ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Nick Corbett. By 2020 Gartner predicts there’ll be roughly 21 billion Internet of Things (IoT) devices in use. Its easy to get excited about this rapid growth and envisage a future where the digital world extends further into our world. Before you take the decision to deploy devices into the wild, it’s vital to understand how you will maintain your security perimeter.In this post, I will walk you through the security model used by AWS IoT. I will show you how devices can authenticate to the AWS IoT platform ... Read More