 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] DataMigrator and BLOBs? | Login/Join |
| Expert |
What's up with BLOBs? DM errors out when processing them. Fortunately, for now, we only have one BLOB and it's nulls, so we're setting it to '' (double-single-quotes) and that's working. We will use that to store an image of the particular item and will need it then. Thanks in Advance, DougThis message has been edited. Last edited by: Doug,
| ||||
|
| Virtuoso |
What version? I've got customers processing BLOBs just fine. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Expert |
Configuration Date .... 01/30/2017 13:43:27 Build Date ............ 04/13/2017 18:05:09 Gen Number ............ 1083 Release ............... 82 Source Date ........... 04/09/2017 18:49:13 | |||
|
| Virtuoso |
I should have asked to other questions: - Source data type - Target data type Have you approached Tech Support yet? "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Expert |
- Source data type: SQL Server - Target data type: SUFFIX=MSODBC, SEGTYPE=S0 | |||
|
| Virtuoso |
Take this up with techsupport. As I've said, it just works for me, so it might be a versioning thing for you. The one thing that I did notice that bothers me a bit is that it dumps the BLOBs to disk in the foccache when the flow is running before it loads into the target. We did have a bit of space issues and had to add a couple of extra gigs to allow it and the rest of the processes to run without running out of physical space. Other than that, tickety-boo. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Guru |
Support for BLOBs are documented in the DMUG: BLOB. Represents a Binary Large Object. A BLOB is used to store an image, sound, or some other large, unstructured block of data. The corresponding database data types are:
A column described as BLOB can only be copied from source to target. No transformations can be performed. ------------- Note: For MS SQL Server image is to be deprecated and varbinary(max) is preferred. BTW Release 7.7.07 or 82 Gen 1083 was a pre-production gen; the production release was Gen 1086 in May and there have been regular maintenance gens since the release became GA. While I don't see any changes specifically addressing BLOB support I would recommend using the current gen. N/A | |||
|
| Expert |
Thanks Clif, The only way I get that BLOB to to destination is to do a transformation to ''. Would a transformation to itself work? I will try that ASAP, but that may not be today. | |||
|
| Guru |
A transformation to itself, just an assignment, should work. If not please open an IRL case. N/A | |||
|
| Expert |
OK, Thanks Cliff. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |