Connecting to SQLMX
I am working on connecting to a SQLMX database using the JDBC connection.
The connection is successful when I add the details in the JDBC account, but when I try to execute queries from the pipelin...
Forum Discussion
Tested with a sample file and with the mapper settings as below:
Closing this thread as the solution worked.
What about Copy and a File Writer? At the same time you can write the file to SLDB and to another server, or use a File Reader/File Writer if you want to keep it as a separate process.
Thanks. I did see that we would have to (re)read and then use File Writer. This may be an option with a copy/router to only execute on the desired day(s) of month.
Do you want to automate the process of coping the files from SLDB to another server? Or, do you want to copy files from one source location/server to SLDB and target server?
If first, then one pipeline with Directory Browser Snap to scan and get files from SLDB, File Reader Snap(to read the files) and File Writer Snap(to write files to target location). Also you can create a scheduled task to run on predestined time.
If second, probably you will have two pipelines:
1) One pipeline that will read files from source server to SLDB.
2) Second pipeline that will read files from SLDB to target server.Also, those pipelines can be scheduled to run based on your requirements.
File Operation Snap will work only with: local file (file:///), FTP, SFTP, S3, WASB, and WASBS - file protocols.
Regards,
Spiro TaleskiThank you for the options/insight.
I think we’re probably looking at the first scenario. The files are generated daily and saved in the Snaplogic folder (SLDB?).
On certain days of the month they need to be copied to a target server.I think whatever approach we decide on, we’ll need to (re)read the files based on their file types and then use the corresponding file writer snap to write to the target server.
Appreciate everyone’s input.
Having a scheduled process/task that will run on certain days of the month, scanning the SLDB project/directory for a files(using Directory Browser Snap), File Reader Snap(to read the files), and File Writer Snap(to write the file to target system), will work, but also you should think of a logic where once copied files from SLDB to not be picked again in the next execution.
Regards,
Spiro Taleski
