We are starting with a .bak file placed in an SFTP site, I am wondering if Talend can open or convert that .bak file to csv files? Is this possible to set up as we are trying to create a fully automated process to start with accessing this bak file, converting, working with the extracted csv files to then transform and load to Salesforce. Thanks!
no, it is impossible
what you can do with Talend (really with SQL command line tools and tSystem) - restore this backup on local SQL Server and than use standard components to access data on this SQL server
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.