We are pleased to announce that Informatica Cloud Data Wizard has been enhanced to support on-premise databases like Oracle and SQL Server. Now you can import/export data between Salesforce and Oracle or SQL Server tables in four easy steps!
Step 1: Download and install the Secure Agent from the Data Wizard application.
An Informatica Cloud Secure Agent is a lightweight program that runs tasks and enables secure communication across the firewall between your organization and Data Wizard.
Step 2: Register the Secure Agent with the install token.
After you download and install the Secure Agent, click “Get Install Token” on the Data Wizard main page and use this token to register the Secure Agent. After you register the Secure Agent, the Secure Agent service starts up. You can access the Secure Agent service from your taskbar.
Refer to this article for more information about the Secure Agent installation process.
Step 3: Create new connections to access your Oracle and SQL Server data sources.
Step 4: Create and run tasks to import/export data with Oracle/SQL Server using the new templates!
Have questions or feedback? Please feel free to post questions or comments to the Data Wizard community or write to us using the “Questions or Feedback” link on the Data Wizard main page!