I successfully created an export package from Hubspot and an Import package to SQL Server and ran each manually- worked fine. I downloaded the csv file to my hard drive and referred it to crate the import package. Now I need to schedule - where can I put the output from the export to be the import to the SQL Server - and how do I make the Export package a dependency to the Import package? I have a Google drive - and space on the rackspace server.
Export CSV file becomes Import
- Last Post 07 September 2017
- Topic Is Solved
You can implement your scenario in the following way:
1) Create Export package to Google Drive. In the export task specify the Target File Name, e.g. 'Contacts':
JIC: By default the CSV file will have the source object name, followed by export operation timestamp if the Append timestamp to the file name check box is selected for the package. Note that if you specify a custom name, it will not be followed by the timestamp even if this check box is selected for the package; this check box is applied only for export tasks with the default file name. Google Drive doesn't support using File Mask and, thus, default file names are not suitable in this case.
2) Set schedule for your Export package: https://skyvia.com/resources/docs/index.html?scheduling_packages.htm
3) Create new Import package. As a source use Google Drive and 'Contacts.csv' file. Refer to: https://skyvia.com/resources/docs/index.html?how_to_create_import_task.htm
4) Set schedule for your Import package so that it runs after your Export package.
Also, you can try using direct import from HubSpot to SQL Server. For this, create Import package with the HubSpot connection as a Source and SQL Server connection as a Target.
Please tell us if this information helps.