How to authenticate to Gmail with Rebex Secure Mail using OAuth 2.0

Google Account passwords are precious and it's not a good idea to share them with random third-party applications you don't fully trust. That's why Google has been promoting OAuth 2.0, an open authentication protocol that makes it possible for users to grant access to Gmail and other services to…

How to register your app for Gmail OAuth 2.0 authentication

To set up OAuth 2.0 for your application, you have to register your application at Google Developers Console (for free). When you register, you will get client ID and client secret that will identify your application and enable OAuth authentication. Steps to set up OAuth 2.0 for Gmail:…

Get-SFTPFiles function for PowerShell

This is a guest post by Tim Smiths, user of Rebex SFTP, who was so kind to share his real-world experience with using SFTP from PowerShell script. Suppose that we have a few imports that require us getting the latest files from an SFTP server, and we're looking to automate…

Using SFTP and FTP/SSL in SSIS package in VS 2012

SFTP and FTP/SSL components (included in Rebex File Transfer Pack) were not especially designed to run inside the SSIS (SQL Server Integration Services). However, with little effort component can be used from inside the SSIS "script task". The FTP/SSL component was chosen as a model for this sample…

How to upload data to FTP or SFTP server from a SQL-CLR procedure (SQL Server 2012 and VS 2012)

Since Microsoft SQL Server 2005, stored procedures (and some other database objects) can be written externally in some .NET language, imported to the SQL database and called as stored procedures. The following sample demonstrates how to call Rebex FTP component from the T-SQL code in the environment of SQL Server…